SQLUndercover Inspector Build: 2.01

SQLUndercover Catalogue Build: 0.4.0

Catalogue last executed: 18 Dec 2019 17:04

Report date: 03 Jan 2020 17:20

No clutter mode: On


Server Summary:

Warnings Present -

[DESTINY] [DESTINY\SQL02]






Warning Conditions:

DESTINY - has (1) DriveSpace

DESTINY - has (13) Database Backup issues



DESTINY\SQL02 - has (1) DriveSpace

DESTINY\SQL02 - has (22) Database Backup issues

DESTINY\SQL02 - has (2) CPU has exceeded your threshold

DESTINY\SQL02 - has (1) Database state warnings



ALL_SERVERS - has (1) Backup space issues





Advisory Conditions:

DESTINY - has (1) Failed agent jobs

DESTINY - has (1) Failed logins

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



DESTINY\SQL02 - has (1) Database state warnings

DESTINY\SQL02 - has (3) Failed agent jobs

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






Informational Conditions:

DESTINY - has (10) Database ownerships not set to your preferred owner

DESTINY - has (1) Agent jobs not set to your preferred owner



DESTINY\SQL02 - has (1) CPU has exceeded your threshold

DESTINY\SQL02 - has (18) Database ownerships not set to your preferred owner

DESTINY\SQL02 - has (1) Database Auto Close or Auto Shrink settings enabled or Auto Update Stats Disabled

DESTINY\SQL02 - has (4) Agent jobs not set to your preferred owner





Server [DESTINY]

Instance start: 18 Dec 2019 22:21 (Uptime: 16 Days)
Instance Version/Edition: 13.0.1742.0 - Developer Edition (64-bit)
Physical Servername: DESTINY

ModuleConfig used: Default
Disabled Modules: Feature disabled



Drive space Report:
Server nameDriveTotal GBAvailable GB% FreeEst.Daily Growth GBDays Until Disk FullDays RecordedUsage TrendUsage Trend AVG GBCalculation method
DESTINYC:\117.8524.8521.092.808.8828 [Thursday 0.74 GB], [Wednesday 0.63 GB]0.69Average

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

Back to Top


Top 3 wait stats grouped by 2 hourly buckets for the last 1440 minutes
ServerNameHourlyBucketwait_typewait_time_ms_deltawait_time_minutes_deltawait_time_minutes_per_minutesignal_wait_time_ms_deltawaiting_tasks_count_deltawait_time_ms_per_wait
DESTINY02 Jan 2020 16:00WRITELOG6840.000.002327300.94
DESTINY02 Jan 2020 16:00PREEMPTIVE_OS_AUTHENTICATIONOPS4500.000.0009980.45
DESTINY02 Jan 2020 16:00PREEMPTIVE_OS_PIPEOPS3220.000.0003107.33
DESTINY03 Jan 2020 10:00WRITELOG357520.000.0011052100633.55
DESTINY03 Jan 2020 10:00PREEMPTIVE_OS_AUTHENTICATIONOPS124580.000.000142160.88
DESTINY03 Jan 2020 10:00SOS_SCHEDULER_YIELD70120.000.006962429390.16
DESTINY03 Jan 2020 12:00WRITELOG84120.000.00270349511.70
DESTINY03 Jan 2020 12:00PREEMPTIVE_OS_AUTHENTICATIONOPS43340.000.00066020.66
DESTINY03 Jan 2020 12:00MEMORY_ALLOCATION_EXT22110.000.00017161200.00
DESTINY03 Jan 2020 14:00WRITELOG452180.000.0014496158992.84
DESTINY03 Jan 2020 14:00PREEMPTIVE_OS_AUTHENTICATIONOPS213920.000.000211541.01
DESTINY03 Jan 2020 14:00SOS_SCHEDULER_YIELD194980.000.0019425571400.34
DESTINY03 Jan 2020 16:00WRITELOG251220.000.008927122302.05
DESTINY03 Jan 2020 16:00PREEMPTIVE_OS_AUTHENTICATIONOPS131560.000.000161980.81
DESTINY03 Jan 2020 16:00SOS_SCHEDULER_YIELD80850.000.008032423740.19

Back to Top


The following Databases are missing database backups:
ServernameDatabase nameAG nameLast FullLast DiffLast LogFull RecoveryAG Backup PrefPreferred Servers
DESTINYCollationDBDESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoN/ANN/A DESTINY
DESTINYDBADESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY
DESTINYGrowthTestDESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoN/ANN/A DESTINY
DESTINYInspectorV2DESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY
DESTINYmasterDESTINY(Non AG)More than 8 Days AgoN/AN/ANN/A DESTINY
DESTINYmodelDESTINY(Non AG)More than 8 Days AgoN/AN/AYN/A DESTINY
DESTINYmsdbDESTINY(Non AG)More than 8 Days AgoN/AN/ANN/A DESTINY
DESTINYPSInstallationDESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY
DESTINYPSTestDESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY
DESTINYSentryOneDESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoN/ANN/A DESTINY
DESTINYSQLUndercoverDESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY
DESTINYSQLUndercoverV1_2DESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY
DESTINYSQLUndercoverV1_4DESTINY(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY

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

Back to Top


Backup Sizes by Day for server:
Day Of WeekTotal Backup Size GB
No Backups for the past 7 daysN/A

Back to Top


The following Databases have an owner that is not sa
Server nameAG nameDatabase nameOwner
DESTINYN/ACollationDBDESTINY\adest
DESTINYN/ADBADESTINY\adest
DESTINYN/AGrowthTestDESTINY\adest
DESTINYN/AInspectorV2DESTINY\adest
DESTINYN/APSInstallationDESTINY\adest
DESTINYN/APSTestDESTINY\adest
DESTINYN/ASentryOneDESTINY\adest
DESTINYN/ASQLUndercoverDESTINY\adest
DESTINYN/ASQLUndercoverV1_2DESTINY\adest
DESTINYN/ASQLUndercoverV1_4DESTINY\adest

Back to Top


Database settings
CollationTotal
Latin1_General_CS_AS12
SQL_Latin1_General_CP1_CI_AS1
SQL_Latin1_General_CP1_CS_AS1
Auto Close Total
Disabled14
Auto Shrink Total
Disabled14
Auto Update Stats Total
Enabled14
Read Only Total
Disabled14
User Access Total
MULTI_USER14
Compatibility Level Total
13014
Recovery Model Total
FULL8
SIMPLE6

Back to Top


Database count by state
Server nameDatabase stateTotalDatabase names
DESTINYONLINE14-

Back to Top


Failed Agent Jobs
Server nameLog DateJob nameLast Step FailedLast Failed DateLast Error
DESTINY03 Jan 2020 10:50Inspector Auto [InspectorV2]103 Jan 2020 10:50Executed as user: NT SERVICE\SQLSERVERAGENT. ModuleConfig selected for server: Default [SQLSTATE 01000] (Message 50000) Running [Inspector].[InstanceStartInsert] [SQLSTATE 01000] (Message 50000) Running [Inspector].[InstanceVersionInsert] [SQLSTATE...

Back to Top


Failed Login Attempts
Server nameUsernameAttemptsLast Failed AttemptLast Error
DESTINYNT Service\SQLAgent$SQL02103 Jan 2020 10:49Login failed for user 'NT Service\SQLAgent$SQL02'. Reason: Could not find a login matching the name provided. [CLIENT: ]

Back to Top


Agent Jobs where the owner is not sa
Server nameJob IDJob name
DESTINY1DFB7A78-9A91-4CA5-B7BD-C4E01F24A350Blitz collection

Back to Top


Server settings
SettingTotal
cost threshold for parallelism50
max degree of parallelism0
max server memory (MB)3072
backup compression default0
optimize for ad hoc workloads0
backup checksum default0
automatic soft-NUMA disabled0
Agent XPs1
Database Mail XPs0
xp_cmdshell1

Back to Top


Top 5 Databases by size
Server nameDatabase nameTotal size(MB)
DESTINYDBA2064
DESTINYSQLUndercover400
DESTINYGrowthTest2048
DESTINYSentryOne158
DESTINYSQLUndercoverV1_2100

Back to Top




Server [DESTINY\SQL02]

Instance start: 18 Dec 2019 16:56 (Uptime: 16 Days)
Instance Version/Edition: 13.0.1742.0 - Developer Edition (64-bit)
Physical Servername: DESTINY

ModuleConfig used: Default
Disabled Modules: Feature disabled



Drive space Report:
Server nameDriveTotal GBAvailable GB% FreeEst.Daily Growth GBDays Until Disk FullDays RecordedUsage TrendUsage Trend AVG GBCalculation method
DESTINY\SQL02C:\117.8524.8521.091.5615.9356 [Thursday 0.75 GB], [Wednesday 0.62 GB]0.69Average

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

Back to Top


Top 3 wait stats grouped by 2 hourly buckets for the last 1440 minutes
ServerNameHourlyBucketwait_typewait_time_ms_deltawait_time_minutes_deltawait_time_minutes_per_minutesignal_wait_time_ms_deltawaiting_tasks_count_deltawait_time_ms_per_wait
DESTINY\SQL0202 Jan 2020 16:00SOS_SCHEDULER_YIELD88560.000.00885342862.07
DESTINY\SQL0202 Jan 2020 16:00WRITELOG65610.000.00352825072.62
DESTINY\SQL0202 Jan 2020 16:00PREEMPTIVE_OS_AUTHENTICATIONOPS26700.000.00022221.20
DESTINY\SQL0203 Jan 2020 10:00SOS_SCHEDULER_YIELD1634370.000.00163358688612.37
DESTINY\SQL0203 Jan 2020 10:00WRITELOG1210420.000.0057955323423.74
DESTINY\SQL0203 Jan 2020 10:00PREEMPTIVE_OS_AUTHENTICATIONOPS460350.000.000284121.62
DESTINY\SQL0203 Jan 2020 12:00SOS_SCHEDULER_YIELD666470.000.0066608323012.06
DESTINY\SQL0203 Jan 2020 12:00WRITELOG414130.000.0023017155902.66
DESTINY\SQL0203 Jan 2020 12:00PREEMPTIVE_OS_AUTHENTICATIONOPS170280.000.000144521.18
DESTINY\SQL0203 Jan 2020 14:00SOS_SCHEDULER_YIELD2634480.000.00263331972102.71
DESTINY\SQL0203 Jan 2020 14:00WRITELOG1608660.000.0083477507653.17
DESTINY\SQL0203 Jan 2020 14:00PREEMPTIVE_OS_AUTHENTICATIONOPS680080.000.000456591.49
DESTINY\SQL0203 Jan 2020 16:00SOS_SCHEDULER_YIELD2062160.000.00206118780852.64
DESTINY\SQL0203 Jan 2020 16:00WRITELOG1212220.000.0062897393313.08
DESTINY\SQL0203 Jan 2020 16:00PREEMPTIVE_OS_AUTHENTICATIONOPS437750.000.000363781.20

Back to Top


The following Databases are missing database backups:
ServernameDatabase nameAG nameLast FullLast DiffLast LogFull RecoveryAG Backup PrefPreferred Servers
DESTINY\SQL02aDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY\SQL02
DESTINY\SQL02CaseInsensitiveDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoN/ANN/A DESTINY\SQL02
DESTINY\SQL02CredsDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY\SQL02
DESTINY\SQL02DBADESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02FreshInstallDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02GrowthTestDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoN/ANN/A DESTINY\SQL02
DESTINY\SQL02InspectorDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02InspectorV2DESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02InspectorVNextDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoN/ANN/A DESTINY\SQL02
DESTINY\SQL02masterDESTINY\SQL02(Non AG)More than 8 Days AgoN/AN/ANN/A DESTINY\SQL02
DESTINY\SQL02modelDESTINY\SQL02(Non AG)More than 8 Days AgoN/AN/AYN/A DESTINY\SQL02
DESTINY\SQL02msdbDESTINY\SQL02(Non AG)More than 8 Days AgoN/AN/ANN/A DESTINY\SQL02
DESTINY\SQL02NewDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02NewCatalogueDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02NewInstallDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02PSInstallationDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02PSTestDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02SQLUndercoverDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02
DESTINY\SQL02SQLUndercoverV1_2DESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY\SQL02
DESTINY\SQL02SQLUndercoverV1_3DESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoMore than 8 Days AgoYN/A DESTINY\SQL02
DESTINY\SQL02SQLUndercoverV1_4DESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoN/ANN/A DESTINY\SQL02
DESTINY\SQL02TestDESTINY\SQL02(Non AG)More than 8 Days AgoMore than 8 Days AgoOKYN/ADESTINY\SQL02

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

Back to Top


Backup Sizes by Day for server:
Day Of WeekTotal Backup Size GB
Thursday0.0

Back to Top


CPU greater than 75%
ServernameEventTimeSystemCPUUtilizationSQLCPUUtilizationOtherCPU
DESTINY\SQL0202 Jan 2020 09:35:51:81081
DESTINY\SQL0202 Jan 2020 09:36:47:100793
DESTINY\SQL0203 Jan 2020 11:04:16:100199

Back to Top


The following Databases have an owner that is not sa
Server nameAG nameDatabase nameOwner
DESTINY\SQL02N/AaDESTINY\adest
DESTINY\SQL02N/ACaseInsensitiveDESTINY\adest
DESTINY\SQL02N/ADBADESTINY\adest
DESTINY\SQL02N/AFreshInstallDESTINY\adest
DESTINY\SQL02N/AGrowthTestDESTINY\adest
DESTINY\SQL02N/AInspectorDESTINY\adest
DESTINY\SQL02N/AInspectorV2DESTINY\adest
DESTINY\SQL02N/AInspectorVNextDESTINY\adest
DESTINY\SQL02N/ANewDESTINY\adest
DESTINY\SQL02N/ANewCatalogueDESTINY\adest
DESTINY\SQL02N/ANewInstallDESTINY\adest
DESTINY\SQL02N/APSInstallationDESTINY\adest
DESTINY\SQL02N/APSTestDESTINY\adest
DESTINY\SQL02N/ASQLUndercoverDESTINY\adest
DESTINY\SQL02N/ASQLUndercoverV1_2DESTINY\adest
DESTINY\SQL02N/ASQLUndercoverV1_3DESTINY\adest
DESTINY\SQL02N/ASQLUndercoverV1_4DESTINY\adest
DESTINY\SQL02N/ATestDESTINY\adest

Back to Top


Database settings
CollationTotal
Latin1_General_CS_AS28
SQL_Latin1_General_CP1_CI_AS1
Latin1_General_CI_AS1
Auto Close Total
Disabled30
Auto Shrink Total
Disabled29
Enabled1
Auto Update Stats Total
Enabled30
Read Only Total
Disabled24
Enabled6
User Access Total
MULTI_USER30
Compatibility Level Total
13029
1001
Recovery Model Total
FULL22
SIMPLE8

Back to Top


Database count by state
Server nameDatabase stateTotalDatabase names
DESTINY\SQL02ONLINE22-
DESTINY\SQL02SNAPSHOT (more than 10 days old)6 [SQLUndercoverV1_3_snapshot] , [SQLUndercoverV1_2_snapshot] , [SQLUndercoverV1_4_snapshot] , [DBA_snapshot] , [FreshInstall_snapshot] , [NewCatalogue_snapshot]
DESTINY\SQL02RESTORING1 [StackOverflow2010]
DESTINY\SQL02RECOVERY_PENDING1 [GrowthTest2]

Back to Top


Failed Agent Jobs
Server nameLog DateJob nameLast Step FailedLast Failed DateLast Error
DESTINY\SQL0203 Jan 2020 10:50SQLUndercover PeriodicZZ Backups Report103 Jan 2020 10:48Executed as user: NT SERVICE\SQLAgent$SQL02. Invalid column name 'CPUCount'. [SQLSTATE 42S22] (Error 207) Invalid column name 'PhysicalMemoryMB'. [SQLSTATE 42S22] (Error 207) Invalid column name 'VMType'. [SQLSTATE 42S22] (Error 207) Reporting on ...
DESTINY\SQL0203 Jan 2020 10:50SQLUndercover InspectorZZ Report103 Jan 2020 10:48Executed as user: NT SERVICE\SQLAgent$SQL02. ...alid column name 'PhysicalMemoryMB'. [SQLSTATE 42S22] (Error 207) Invalid column name 'VMType'. [SQLSTATE 42S22] (Error 207) Reporting on Module: [ADHocDatabaseCreations] for server [DESTINY] [SQLSTAT...
DESTINY\SQL0203 Jan 2020 10:50sp_whoisactive collection103 Jan 2020 10:50Executed as user: NT SERVICE\SQLAgent$SQL02. Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Messag...

Back to Top


Agent Jobs where the owner is not sa
Server nameJob IDJob name
DESTINY\SQL0269960696-0554-4D4E-8D3E-09046653E62CSQL Sentry 2.0 Alert Trap
DESTINY\SQL026B250F62-EE9C-4068-BE5E-263B740723AAInspectorPS
DESTINY\SQL02E4FB0ACD-1ED1-4160-B2E9-8E23978C9034Blitz collection
DESTINY\SQL02D9439A4B-6BD2-4FAD-9313-FDC770BA8170sp_whoisactive collection

Back to Top


Server settings
SettingTotal
cost threshold for parallelism5
max degree of parallelism0
max server memory (MB)3072
backup compression default0
optimize for ad hoc workloads0
backup checksum default0
automatic soft-NUMA disabled0
Agent XPs1
Database Mail XPs0
xp_cmdshell1

Back to Top


Top 5 Databases by size
Server nameDatabase nameTotal size(MB)
DESTINY\SQL02StackOverflow20109075
DESTINY\SQL02DBA6736
DESTINY\SQL02GrowthTest2063
DESTINY\SQL02GrowthTest21000
DESTINY\SQL02FreshInstall272

Back to Top




Server [ALL Servers]


Backup space information against backup path(s): F:\Backups\,C:\SQLBackups
ServernameBackup locationBackup Estimate For Tonight GBBackup Server FreeSpace GBBackup Server Free Space After Backups GB
N\AF:\Backups0.0Invalid Backup Path Specified in [Inspector].[Settings]N/A
DESTINY\SQL02C:\SQLBackups0.023.523.5

Back to Top