SQLUndercover Inspector Build: 2.7
Report date: 06 Dec 2021 23:06

No clutter mode: Off


Server Summary:

Warnings Present -

[PHENOM]






Warning Conditions:

PHENOM - has (14) Database Backup issues

PHENOM - has (1) Database state warnings







Advisory Conditions:

PHENOM - has (1) Database state warnings

PHENOM - has (2) Failed agent jobs

PHENOM - has (3) Server settings changed or differ from your config values

PHENOM - has (1) Read/Write IO Stalls breached your threshold

PHENOM - has (2) Agent jobs where desired state not met






Informational Conditions:

PHENOM - has (6) Database ownerships not set to your preferred owner

PHENOM - has (2) Agent jobs not set to your preferred owner

PHENOM - has (1) Unused log shipping config found





Server [PHENOM]

Instance start: 19 Nov 2021 08:58 (Uptime: 17 Days)
Instance Version/Edition: 13.0.5026.0 - Developer Edition (64-bit)
Physical Servername: PHENOM
Machine type: Virtual
Total RAM: 32 GB
CPU Count: 8
Hyperthread Count: 8
Scheduler Count: 8
CPU Affinity: AUTO

ModuleConfig used: Default
Disabled Modules: None



Potential Ad hoc database creations in the last 7 days
Database nameCreate dateSuppress database
No Ad hoc database creations presentN/AN/A

Back to Top


Drive space Report:

Server nameDriveTotal GBAvailable GB% FreeEst.Daily Growth GBDays Until Disk FullDays RecordedUsage TrendUsage Trend AVG GBCalculation methodThresholds
PHENOMC:\118.7014.1311.900.00N/A136 [Monday 2.00 GB], [Sunday 0.03 GB], [Thursday -0.38 GB]0.00MedianMinimum available space: 11.87 GB (10.00%), Estimated days remaining: 56
PHENOMD:\465.75136.7529.360.00N/A131 [Monday -0.16 GB], [Sunday -0.85 GB], [Thursday 0.89 GB]0.00MedianMinimum available space: 46.58 GB (10.00%), Estimated days remaining: 56

Back to Top


Top 3 wait stats grouped by 2 hourly buckets for the last 1440mins between the hours of 0 and 23

ServerNameWatchedHourlyBucketwait_typewait_time_ms_deltawait_time_minutes_deltawait_time_minutes_per_minutesignal_wait_time_ms_deltawaiting_tasks_count_deltawait_time_ms_per_waitThresholdThresholdType
PHENOM006 Dec 2021 10:00MSQL_DQ147043518.000.00010813615.140.00None
PHENOM006 Dec 2021 10:00PREEMPTIVE_COM_QUERYINTERFACE147043518.000.00010813615.140.00None
PHENOM006 Dec 2021 10:00OLEDB147024318.000.00010813613.360.00None
PHENOM006 Dec 2021 12:00MSQL_DQ196181624.000.00014413623.720.00None
PHENOM006 Dec 2021 12:00PREEMPTIVE_COM_QUERYINTERFACE196181524.000.00014413623.720.00None
PHENOM006 Dec 2021 12:00OLEDB196164324.000.00014413622.520.00None
PHENOM006 Dec 2021 14:00MSQL_DQ196150624.000.00014413621.570.00None
PHENOM006 Dec 2021 14:00PREEMPTIVE_COM_QUERYINTERFACE196150624.000.00014413621.570.00None
PHENOM006 Dec 2021 14:00OLEDB196149824.000.00014413621.510.00None
PHENOM006 Dec 2021 16:00OLEDB163463720.000.00012013621.980.00None
PHENOM006 Dec 2021 16:00MSQL_DQ163433220.000.00012013619.430.00None
PHENOM006 Dec 2021 16:00PREEMPTIVE_COM_QUERYINTERFACE163433120.000.00012013619.430.00None
PHENOM006 Dec 2021 22:00OLEDB98305312.000.0007413284.500.00None
PHENOM006 Dec 2021 22:00PREEMPTIVE_COM_QUERYINTERFACE98295012.000.0007313465.070.00None
PHENOM006 Dec 2021 22:00MSQL_DQ98295012.000.0007313465.070.00None

Back to Top


Suspect Pages Check

Server nameDatabase nameFile IDPage IDEvent typeError countLast update
PHENOMNo Suspect pages found0000-

Back to Top


Availability Group Health Check

Server nameAG nameStateReplica Server NameReplica RoleFailover ReadySuspendedSuspend ReasonFailover Ready Threshold
PHENOMHADR IS NOT ENABLED ON THIS SERVER OR YOU HAVE NO AVAILABILITY GROUPSN/AN/AN/AN/AN/AN/A2

Back to Top


Databases not in an AG

Server nameLast CheckedDatabase nameSuppress database
PHENOMNo Databases marked as AG and not joinedN/AN/A

Back to Top


The following Databases are missing database backups:

ServernameDatabase nameAG nameLast FullLast DiffLast LogFull RecoveryAG Backup PrefPreferred ServersThresholds
PHENOMByteSize_LogshippedPHENOM(Non AG)More than 168 Days AgoMore than 168 Days AgoMore than 168 Days AgoYN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMDBAPHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMFRK_testPHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMFRKUpdatePHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMInspector_2_5PHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 7 Day(s) , Diff: 2 Hour(s) , Log: 20 Minute(s)
PHENOMInspectorAutoUpdatePHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMInspectorAutoUpdate_InspectorDevPHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMInspectorMasterBuildPHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMInspectorNewInstallPHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMmasterPHENOM(Non AG)More than 168 Days AgoN/AN/ANN/A PHENOMFull: 1 Day(s) , Diff: Ignoring , Log: 20 Minute(s)
PHENOMmodelPHENOM(Non AG)More than 168 Days AgoN/AN/ANN/A PHENOMFull: 1 Day(s) , Diff: Ignoring , Log: 20 Minute(s)
PHENOMmsdbPHENOM(Non AG)30 Nov 2021 08:45N/AN/ANN/A PHENOMFull: 1 Day(s) , Diff: Ignoring , Log: 20 Minute(s)
PHENOMTPCC_100_WarehousesPHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)
PHENOMWorkloadPHENOM(Non AG)OK14 Nov 2021 12:56N/ANN/A PHENOMFull: 168 Day(s) , Diff: 48 Hour(s) , Log: 20 Minute(s)

Global Thresholds:
Last FULL backup older than 168 Day/s
Last DIFF backup older than 48 Hour/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
Monday6.0
Tuesday0.0
Sunday0.0

Back to Top


Data or Log files on incorrect drives

Server nameDatabase nameFile typeFile path
PHENOMNo Database File issues presentN/AN/A

Back to Top


The following Databases have an owner that is not sa

Server nameAG nameDatabase nameOwner
PHENOMN/AByteSize_LogshippedPHENOM\adest
PHENOMN/ADBAPHENOM\adest
PHENOMN/AFRK_testPHENOM\adest
PHENOMN/AInspectorAutoUpdatePHENOM\adest
PHENOMN/AInspectorAutoUpdate_InspectorDevPHENOM\adest
PHENOMN/AStackOverflow2013PHENOM\adest

Back to Top


Database settings

CollationTotal
Latin1_General_CS_AS18
SQL_Latin1_General_CP1_CI_AS1
Auto Close Total
Disabled19
Auto Shrink Total
Disabled19
Auto Update Stats Total
Enabled19
Read Only Total
Disabled17
Enabled2
User Access Total
MULTI_USER19
Compatibility Level Total
13019
Recovery Model Total
SIMPLE17
FULL2

Back to Top


Database count by state

Server nameDatabase stateTotalDatabase names
PHENOMONLINE16-
PHENOMSNAPSHOT (more than 10 days old)1 [ByteSize_Logshipped]
PHENOMRECOVERY_PENDING1 [DiskTest]
PHENOMLOG SHIPPED STANDBY1 [ByteSize_Logshipped]

Back to Top


Failed Agent Jobs

Server nameLog DateJob nameLast Step FailedLast Failed DateLast Error
PHENOM06 Dec 2021 10:23LSAlert_PHENOM105 Dec 2021 21:06Executed as user: NT SERVICE\SQLSERVERAGENT. The log shipping secondary database PHENOM.ByteSize_Logshipped has restore threshold of 720 minutes and is out of sync. No restore was performed for 27955 minutes. Restored latency is 0 minutes. Check agen...
PHENOM06 Dec 2021 10:23Blitz Collection SQL2008R2105 Dec 2021 21:05Executed as user: NT SERVICE\SQLSERVERAGENT. Shared Memory Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 42000] (Error 2) OLE DB provider "SQLNCLI11" for linked server "PHENOM\SQL2008R2" returned message "Login timeout expired"....

Back to Top


Failed Login Attempts

Server nameUsernameAttemptsLast Failed AttemptLast Error
PHENOMNo Failed Logins presentN/AN/AN/A

Back to Top


Agent Jobs where the owner is not sa

Server nameJob IDJob name
PHENOMF8D281A4-4AFC-4058-8D5D-61BCCC73B4DFRestore Stackoverflow
PHENOMB5F9C71A-D880-40F6-892F-6E76CE5CBB3ABlitzWho Collection

Back to Top


Long running transactions

Server nameSession idTransaction begin timeDuration (DDHHMMSS)Transaction stateSession stateLogin nameHost nameProgram nameDatabase nameThresholdType
PHENOMNo Long running transactionsN/AN/AN/AN/AN/AN/AN/AN/AN/A

Back to Top


Server settings

Setting nameValue in useOld value in useYour config valueConfig is activeChange typeTime of change
backup checksum default1N/A01No change detected. Server value differs from your config valueN/A
cost threshold for parallelism50N/A551No change detected. Server value differs from your config valueN/A
max degree of parallelism4N/A21No change detected. Server value differs from your config valueN/A

Back to Top


Top 5 Databases by size

Server nameDatabase nameTotal size(MB)
PHENOMStackOverflow201358498
PHENOMDBA19472
PHENOMTPCC_100_Warehouses11920
PHENOMInspectorNewInstall4097
PHENOMInspectorNewInstall_snapshot4096

Back to Top


Unused secondary log shipping config

ServernameDatabase nameState
PHENOMByteSize_Logshippedonline

Back to Top


IO Read/Write stalls exceeding your thresholds for the last 1440 minutes between the hours of 0 and 23

ServerNameCheckDateDriveio_stall_read_ms_averageio_stall_write_ms_averageReadThresholdWriteThreshold
PHENOM06 Dec 2021 22:15C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\1169100100

Back to Top


Recent memory dumps

Server namefilenamecreation timesize in MB
PHENOMNo recent memory dumps foundN/AN/A

Back to Top


Agent jobs not matching your desired state

Server nameJob nameDesired stateEnabled in msdbLast checkedCode to enable
PHENOMDatabaseBackup - SYSTEM_DATABASES - FULL1006 Dec 2021 10:23EXEC msdb.dbo.sp_update_job @job_name = N'DatabaseBackup - SYSTEM_DATABASES - FULL', @enabled = 1 ;
PHENOMDatabaseBackup - USER_DATABASES - DIFF1006 Dec 2021 10:23EXEC msdb.dbo.sp_update_job @job_name = N'DatabaseBackup - USER_DATABASES - DIFF', @enabled = 1 ;

Back to Top




Server [ALL Servers]


Backup space information against backup path(s):

ServernameBackup locationBackup Estimate For tomorrow GBBackup Server FreeSpace GBBackup Server Free Space After Backups GB

Back to Top