SQLUndercover Inspector Build: 2.6
Report date: 20 Jul 2021 23:21

No clutter mode: Off


Server Summary:

Warnings Present -

[PHENOM]






Warning Conditions:

PHENOM - has (1) Database Backup issues

PHENOM - has (3) CPU has exceeded your threshold

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







Advisory Conditions:

PHENOM - has (1) Database state warnings

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






Informational Conditions:

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

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





Server [PHENOM]

Instance start: 20 Jul 2021 19:34 (Uptime: 0 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.7022.8719.270.00N/A74 [Tuesday 0.42 GB], [Monday 0.20 GB], [Friday 0.02 GB]0.00MedianMinimum available space: 11.87 GB (10.00%), Estimated days remaining: 56
PHENOMC:\MOUNTPOINTS\USBDATA\7.457.0794.900.00N/A45 [Tuesday 0.00 GB], [Monday 0.00 GB], [Friday 0.00 GB]0.00AverageMinimum available space: 0.75 GB (10.00%), Estimated days remaining: 56
PHENOMD:\465.75175.9937.790.00N/A69 [Tuesday -5.34 GB], [Monday -0.94 GB], [Friday 0.24 GB]0.00AverageMinimum available space: 46.58 GB (10.00%), Estimated days remaining: 56

Back to Top


Suspect Pages Check

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

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
PHENOM020 Jul 2021 08:00MSQL_DQ166900.000.000120139.080.00None
PHENOM020 Jul 2021 08:00OLEDB165250.000.00030055.080.00None
PHENOM020 Jul 2021 08:00WRITELOG164240.000.001357117921.390.00None
PHENOM020 Jul 2021 10:00MSQL_DQ295320.000.000240123.050.00None
PHENOM020 Jul 2021 10:00OLEDB291680.000.00060048.610.00None
PHENOM020 Jul 2021 10:00WRITELOG102700.000.001857180780.570.00None
PHENOM020 Jul 2021 12:00MSQL_DQ95360.000.00080119.200.00None
PHENOM020 Jul 2021 12:00OLEDB94260.000.00020047.130.00None
PHENOM020 Jul 2021 12:00WRITELOG35490.000.0076956330.630.00None
PHENOM020 Jul 2021 18:00MSQL_DQ38280.000.0004095.700.00None
PHENOM020 Jul 2021 18:00OLEDB37870.000.00010037.870.00None
PHENOM020 Jul 2021 18:00SOS_SCHEDULER_YIELD36410.000.003631168900.220.00None
PHENOM020 Jul 2021 20:00MSQL_DQ225260.000.00024093.860.00None
PHENOM020 Jul 2021 20:00OLEDB222330.000.00060037.060.00None
PHENOM020 Jul 2021 20:00WRITELOG102210.000.002106171990.590.00None
PHENOM020 Jul 2021 22:00MSQL_DQ195000.000.000170114.710.00None
PHENOM020 Jul 2021 22:00OLEDB192960.000.00042545.400.00None
PHENOM020 Jul 2021 22:00WRITELOG141400.000.002307134891.050.00None

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 Servers
PHENOMmodelPHENOM(Non AG)More than 8 Days AgoN/AN/ANN/A PHENOM

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

Back to Top


Backup Sizes by Day for server:

Day Of WeekTotal Backup Size GB
Tuesday0.0
Wednesday2.0
Thursday2.0
Friday2.0
Monday20.0

Back to Top


CPU greater than 80% in the last 1440mins between the hours of 0 and 23 with consecutive breaches of 2 or more

ServernameEventTimeSystemCPUUtilizationSQLCPUUtilizationOtherCPU
PHENOM20 Jul 2021 22:28:31:5971000100
PHENOM20 Jul 2021 22:28:31:6901000100
PHENOM20 Jul 2021 22:29:31:7601000100

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/ADBAPHENOM\adest
PHENOMN/ADiskTestPHENOM\adest
PHENOMN/AInspectorAutoUpdatePHENOM\adest
PHENOMN/AInspectorAutoUpdate_InspectorDevPHENOM\adest
PHENOMN/AInspectorDevPHENOM\adest
PHENOMN/AStackOverflow2013PHENOM\adest

Back to Top


Database settings

CollationTotal
Latin1_General_CS_AS15
SQL_Latin1_General_CP1_CI_AS1
Auto Close Total
Disabled16
Auto Shrink Total
Disabled16
Auto Update Stats Total
Enabled16
Read Only Total
Disabled15
Enabled1
User Access Total
MULTI_USER16
Compatibility Level Total
13016
Recovery Model Total
SIMPLE16

Back to Top


Database count by state

Server nameDatabase stateTotalDatabase names
PHENOMONLINE15-
PHENOMSNAPSHOT (more than 10 days old)1 [InspectorNewInstall_snapshot]

Back to Top


Failed Agent Jobs

Server nameLog DateJob nameLast Step FailedLast Failed DateLast Error
PHENOMN/ANo Failed Jobs presentN/AN/AN/A

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

Back to Top


Transactions that exceed the threshold of 300 seconds

Server nameSession idTransaction begin timeDuration (DDHHMMSS)Transaction stateSession stateLogin nameHost nameProgram nameDatabase name
PHENOMNo Long running transactionsN/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
max degree of parallelism4221A change to server configuration was detected. Server value differs from your config valueChange occurred between 20 Jul 2021 22:20 and 20 Jul 2021 22:21
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

Back to Top


Top 5 Databases by size

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

Back to Top


Unused secondary log shipping config

ServernameDatabase nameState
PHENOMNo unused log shipping config presentN/A

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