SQLUndercover Inspector Build: 1.4

SQLUndercover Catalogue Build: 0.2.1

Catalogue last executed: 08 May 2019 21:53

Report date: 08 May 2019 22:08

No clutter mode: On


Server Summary:

Warnings Present -

[SQL01] [SQL02] [SQL03]






Warning Conditions:

SQL01 - has (1) AG Warnings

SQL01 - has (1) AG Failovers

SQL01 - has (2) Suspect page warnings

SQL01 - has (1) Failed Job warnings

SQL01 - has (10) Database Backup issues



SQL02 - has (7) Database Backup issues



SQL03 - has (4) Database Backup issues







Advisory Conditions:

SQL01 - has (5) Databases not joined to an Availability group

SQL01 - has (3) Agent jobs where the Owner is not sa

SQL01 - has (6) Databases where the Owner is not sa

SQL01 - has (1) Cost Threshold for parallelism, MAXDOP or Max Server memory set to default values



SQL02 - has (4) Databases not joined to an Availability group

SQL02 - has (1) Agent jobs where the Owner is not sa

SQL02 - has (3) Databases where the Owner is not sa

SQL02 - has (3) Cost Threshold for parallelism, MAXDOP or Max Server memory set to default values



SQL03 - has (1) Databases not joined to an Availability group

SQL03 - has (1) Agent jobs where the Owner is not sa

SQL03 - has (1) Databases where the Owner is not sa

SQL03 - has (3) Cost Threshold for parallelism, MAXDOP or Max Server memory set to default values






Informational Conditions:

SQL01 - has (1) Dropped databases



SQL02 - has (1) Missing Logins

SQL02 - has (1) Dropped tables

SQL02 - has (1) Unused secondary log shipping configs present



SQL03 - has (2) Missing Logins





Server [SQL01]

Instance start: 08 May 2019 22:03 (Uptime: 0 Days)
Instance Version/Edition: 14.0.1000.169 - Developer Edition (64-bit)
Physical Servername: SQL01
CPU Count: 1
Total RAM: 2 GB
Machine type: Virtual

ModuleConfig used: Default
Disabled Modules: DatabaseFileCheck



Drive space Report (Using Median based Calculation):
Server name Drive Total GB Available GB % Free Est.Daily Growth GB Days Until Disk Full Days Recorded Usage Trend Usage Trend AVG GB
SQL01C:\59.5141.5969.890.00N/A16 [Tuesday 0.00 GB], [Monday 0.00 GB], [Sunday 0.00 GB], [Saturday 0.00 GB], [Friday 0.10 GB]0.02
SQL01E:\119.8723.6519.730.00N/A16 [Tuesday 0.00 GB], [Monday 0.00 GB], [Sunday 0.00 GB], [Saturday 0.00 GB], [Friday 0.00 GB]0.00

Advisory Highlight - Drive remaining percent below 15%
Warning Highlight - Estimated days remaining until drive is full, is below 56 Days

Back to Top


Availability Group Health Check
Server name AG name State Replica Server Name Replica Role Failover Ready Suspended Suspend Reason Failover Ready Threshold
SQL01AG1HEALTHYSQL01PRIMARYYNN/A3
SQL01AG1HEALTHYSQL02SECONDARYYNN/A3
SQL01AG1HEALTHYSQL03SECONDARYNNN/A3
SQL01AG2HEALTHYSQL01PRIMARYYNN/A2
SQL01AG2HEALTHYSQL02SECONDARYYNN/A2
SQL01AG3HEALTHYSQL01PRIMARYYNN/A2
SQL01AG3HEALTHYSQL02SECONDARYYNN/A2
SQL01AG3HEALTHYSQL03SECONDARYYNN/A2

Back to Top



New Primary servers in the last 24 hours
Previously checked Last checked AG name Primary Replica
08 May 2019 21:4808 May 2019 21:49AG3SQL01

Back to Top


Suspect Pages Check
Server name Database name File ID Page ID Event type Error count Last update
SQL01CorruptionChallenge12442424 Apr 2019 23:00
SQL01CorruptionChallenge124411130 Apr 2019 20:00

Back to Top


Databases not joined to an Availability group
Server name Last Checked Database name Suppress database
SQL0108 May 2019 22:08CorruptionChallengeEXEC [Inspector].[SuppressAGDatabase] @Databasename = 'CorruptionChallenge', @Servername = 'SQL01';
SQL0108 May 2019 22:08MinionEXEC [Inspector].[SuppressAGDatabase] @Databasename = 'Minion', @Servername = 'SQL01';
SQL0108 May 2019 21:42MyLogShipDBEXEC [Inspector].[SuppressAGDatabase] @Databasename = 'MyLogShipDB', @Servername = 'SQL01';
SQL0108 May 2019 22:08SQLUndercoverEXEC [Inspector].[SuppressAGDatabase] @Databasename = 'SQLUndercover', @Servername = 'SQL01';
SQL0108 May 2019 22:08StackoverflowEXEC [Inspector].[SuppressAGDatabase] @Databasename = 'Stackoverflow', @Servername = 'SQL01';

Back to Top


Database Count by State
Server name Database state Total Database names
SQL01ONLINE11-

Back to Top


Failed Agent Jobs in the last 24hrs
Server name Log Date Job name Last Step Failed Last Failed Date Last Error
SQL0108 May 2019 22:08LSBackup_MyLogShipDB108 May 2019 22:00Executed as user: SQLUNDERCOVER\sql01service. The step failed....

Back to Top


Databases dropped in the last 24hrs:
Servername Database name AG name File paths DaysSeenByCatalogue LastSeenByCatalogue
SQL01MyLogShipDBNot in an AGE:\SQLDATA\MyLogShipDB.mdf, E:\SQLLOGS\MyLogShipDB_log.ldf7408 May 2019 21:42

Back to Top


Agent Jobs where the owner is not sa
Server name Job ID Job name
SQL015871A749-FAD4-4CC7-B435-21CB2EA498B8AlwaysOn_Latency_Data_Collection
SQL010CCC3394-CBC2-4ADE-8928-535260BA706ETransLog backups.Subplan_1
SQL0108AD8013-04C4-4D19-9C83-DA8A467E45FEFULL backups.Subplan_1

Back to Top


Top 5 Databases by size
Server name Database name Total size(MB)
SQL01Stackoverflow93767
SQL01DBA3348
SQL01SyncDatabase1772
SQL01Minion322
SQL01AG2208

Back to Top


The following Databases are missing database backups:
Servername Database name AG name Last Full Last Diff Last Log Full Recovery AG Backup Pref Preferred Servers
SQL01AG2AG2More than 8 Days AgoN/AOKYPrimary onlySQL01
SQL01CorruptionChallengeNot in an AGMore than 8 Days AgoN/AOKYN/ASQL01
SQL01DBAAG3More than 8 Days AgoN/AOKYPrimary onlySQL01
SQL01masterNot in an AGMore than 8 Days AgoN/AN/ANN/A SQL01
SQL01MinionNot in an AGMore than 8 Days AgoN/AOKYN/ASQL01
SQL01modelNot in an AGMore than 8 Days AgoN/AN/AYN/A SQL01
SQL01msdbNot in an AGMore than 8 Days AgoN/AN/ANN/A SQL01
SQL01SQLUndercoverNot in an AGMore than 8 Days AgoN/AOKYN/ASQL01
SQL01StackoverflowNot in an AGMore than 8 Days AgoN/AOKYN/ASQL01
SQL01SyncDatabase1AG1More than 8 Days AgoN/AOKYPrefer secondarySQL01

Warning Highlight Thresholds:
Last FULL backup older than 8 Day/s
DIFF backups excluded from check
Last Log backup older than 20 Minute/s
Databases Excluded for this server: 0

Back to Top


The following Databases have an owner that is not sa:
Server name AG name Database name Owner
SQL01AG2AG2SQLUNDERCOVER\Administrator
SQL01Not in an AGCorruptionChallengeSQLUNDERCOVER\Administrator
SQL01Not in an AGMinionSQLUNDERCOVER\Administrator
SQL01Not in an AGSQLUndercoverSQLUNDERCOVER\Administrator
SQL01Not in an AGStackoverflowSQLUNDERCOVER\Administrator
SQL01AG1SyncDatabase1SQLUNDERCOVER\Administrator

Back to Top


Backup Sizes by Day for server:
Day Of Week Total Backup Size GB
Wednesday0.0
Wednesday0.0

Back to Top


Database Settings
Database Settings
Collation Total
Latin1_General_CI_AS9
SQL_Latin1_General_CP1_CI_AS1
SQL_Latin1_General_CP1_CS_AS1
Auto Close Total
Disabled11
Auto Shrink Total
Disabled11
Auto Update Stats Total
Enabled11
Read Only Total
Disabled11
User Access Total
MULTI_USER11
Compatibility Level Total
1409
1001
1301
Recovery Model Total
FULL8
SIMPLE3

Back to Top


Server Settings
Server Settings
Collation Total
cost threshold for parallelism50
max degree of parallelism2
max server memory (MB)2147483647
backup compression default1
optimize for ad hoc workloads0
backup checksum default0
automatic soft-NUMA disabled0
Agent XPs1
Database Mail XPs0
xp_cmdshell1

Back to Top




Server [SQL02]

Instance start: 08 May 2019 22:03 (Uptime: 0 Days)
Instance Version/Edition: 14.0.1000.169 - Developer Edition (64-bit)
Physical Servername: SQL02
CPU Count: 1
Total RAM: 2 GB
Machine type: Virtual

ModuleConfig used: Default
Disabled Modules: DatabaseFileCheck



Drive space Report (Using Median based Calculation):
Server name Drive Total GB Available GB % Free Est.Daily Growth GB Days Until Disk Full Days Recorded Usage Trend Usage Trend AVG GB
SQL02C:\59.5110.3817.440.00N/A16 [Tuesday 0.00 GB], [Monday 0.00 GB], [Sunday 0.00 GB], [Saturday 0.00 GB], [Friday 0.11 GB]0.02
SQL02E:\199.87119.7559.910.00N/A14 [Tuesday 0.00 GB], [Monday 0.00 GB], [Sunday 0.00 GB], [Saturday 0.00 GB], [Friday 0.00 GB]0.00

Advisory Highlight - Drive remaining percent below 15%
Warning Highlight - Estimated days remaining until drive is full, is below 56 Days

Back to Top


Availability Group Health Check
Server name AG name State Replica Server Name Replica Role Failover Ready Suspended Suspend Reason Failover Ready Threshold
SQL02AG1HEALTHYSQL02SECONDARYYNN/A3
SQL02AG2HEALTHYSQL02SECONDARYYNN/A2
SQL02AG3HEALTHYSQL02SECONDARYYNN/A2

Back to Top


Databases not joined to an Availability group
Server name Last Checked Database name Suppress database