SQLUndercover Inspector Build: 2.6
Report date: 14 May 2021 21:30

No clutter mode: Off


Server Summary:

Warnings Present -

[PHENOM]






Warning Conditions:

PHENOM - has (3) Database Backup issues







Advisory Conditions:

PHENOM - has (1) Drive space thresholds breached

PHENOM - has (1) Database state warnings

PHENOM - has (1) Failed logins

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



ALL_SERVERS - has (1) Database Growths in the last 24 hours exceeding thresholds




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: 14 May 2021 20:49 (Uptime: 0 Days)
Instance Version/Edition: 13.0.5026.0 - Developer Edition (64-bit)
Physical Servername: PHENOM

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.7011.099.340.00N/A65 [Friday 0.07 GB], [Thursday 1.95 GB], [Wednesday -2.98 GB], [Tuesday -0.13 GB], [Monday 1.15 GB]0.00MedianMinimum available space: 11.87 GB (10.00%), Estimated days remaining: 56
PHENOMC:\MOUNTPOINTS\USBDATA\7.457.2397.050.00N/A19 [Friday 0.00 GB], [Thursday 0.00 GB], [Wednesday 0.00 GB], [Tuesday 0.00 GB], [Monday 0.00 GB]0.00AverageMinimum available space: 0.75 GB (10.00%), Estimated days remaining: 56
PHENOMD:\465.75206.4644.330.0120646.0021 [Friday 0.12 GB], [Thursday 0.35 GB], [Wednesday 0.93 GB], [Tuesday -3.86 GB], [Monday 14.28 GB]0.00AverageMinimum available space: 46.58 GB (10.00%), Estimated days remaining: 56
PHENOME:\465.75361.9377.710.0136193.0032 No data available0.00AverageMinimum available space: 23.29 GB (5.00%), Estimated days remaining: 60
PHENOMY:\8000.004870.2460.880.3115710.4537 No data available0.00MedianMinimum available space: 800.00 GB (10.00%), Estimated days remaining: 56
PHENOMZ:\1000.00797.8279.780.00N/A37 No data available0.00MedianMinimum available space: 100.00 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
PHENOM013 May 2021 20:00MEMORY_ALLOCATION_EXT13660.000.00012482070.000.00None
PHENOM013 May 2021 20:00WRITELOG10780.000.0017521390.500.00None
PHENOM013 May 2021 20:00PREEMPTIVE_OS_AUTHENTICATIONOPS7670.000.00022860.340.00None
PHENOM013 May 2021 22:00WRITELOG148440.000.001114148371.000.00None
PHENOM013 May 2021 22:00MEMORY_ALLOCATION_EXT82150.000.00076674640.000.00None
PHENOM013 May 2021 22:00CXPACKET70650.000.0015151013.850.00None
PHENOM014 May 2021 08:00CXCONSUMER172500.000.005220484.560.00None
PHENOM014 May 2021 08:00CXPACKET104190.000.008229934.850.00None
PHENOM014 May 2021 08:00WRITELOG50690.000.00110592410.550.00None
PHENOM014 May 2021 10:00WRITELOG123180.000.001302134150.920.00None
PHENOM014 May 2021 10:00MEMORY_ALLOCATION_EXT82070.000.00076138560.000.00None
PHENOM014 May 2021 10:00MSQL_XP63680.000.00011605.490.00None
PHENOM014 May 2021 12:00MEMORY_ALLOCATION_EXT82400.000.00075684420.000.00None
PHENOM014 May 2021 12:00WRITELOG79540.000.001493123430.640.00None
PHENOM014 May 2021 12:00PREEMPTIVE_OS_AUTHENTICATIONOPS43500.000.000141660.310.00None
PHENOM014 May 2021 14:00WRITELOG85370.000.001181123610.690.00None
PHENOM014 May 2021 14:00MEMORY_ALLOCATION_EXT81150.000.00076185890.000.00None
PHENOM014 May 2021 14:00PREEMPTIVE_OS_AUTHENTICATIONOPS42180.000.000138900.300.00None
PHENOM014 May 2021 16:00MEMORY_ALLOCATION_EXT80610.000.00076068520.000.00None
PHENOM014 May 2021 16:00WRITELOG77940.000.001434123090.630.00None
PHENOM014 May 2021 16:00PREEMPTIVE_OS_AUTHENTICATIONOPS45060.000.000138600.330.00None
PHENOM014 May 2021 18:00MEMORY_ALLOCATION_EXT81380.000.00075768240.000.00None
PHENOM014 May 2021 18:00WRITELOG79950.000.001969122960.650.00None
PHENOM014 May 2021 18:00PREEMPTIVE_OS_AUTHENTICATIONOPS46940.000.000137280.340.00None
PHENOM014 May 2021 20:00MEMORY_ALLOCATION_EXT72300.000.00060085990.000.00None
PHENOM014 May 2021 20:00WRITELOG63660.000.00929116600.550.00None
PHENOM014 May 2021 20:00PREEMPTIVE_OS_AUTHENTICATIONOPS32950.000.000112920.290.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
PHENOMmasterPHENOM(Non AG)More than 8 Days AgoN/AN/ANN/A PHENOM
PHENOMmodelPHENOM(Non AG)More than 8 Days AgoN/AN/AYN/A PHENOM
PHENOMmsdbPHENOM(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: 0

Back to Top


Backup Sizes by Day for server:

Day Of WeekTotal Backup Size GB
Friday2.0
Monday20.0
Tuesday0.0
Wednesday0.0
Thursday0.0
Friday0.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/ABlitzPHENOM\adest
PHENOMN/ADBAPHENOM\adest
PHENOMN/ADBAtoolsPHENOM\adest
PHENOMN/ADiskTestPHENOM\adest
PHENOMN/AInspectorAutoUpdatePHENOM\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
Disabled14
Enabled2
User Access Total
MULTI_USER16
Compatibility Level Total
13016
Recovery Model Total
SIMPLE11
FULL5

Back to Top


Database count by state

Server nameDatabase stateTotalDatabase names
PHENOMONLINE14-
PHENOMSNAPSHOT (more than 10 days old)2 [DBA_snapshot] , [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
PHENOMNT Service\SQLAgent$SQL2019114 May 2021 08:57Login failed for user 'NT Service\SQLAgent$SQL2019'. 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
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

SettingServerSettingInUseold_valueYourConfigValueConfigIsActiveChangeTypeLastUpdatedSetConfigToMatchCurrent
backup checksum default1001No change detected. Server value differs from your config value10 May 2021 22:32:41UPDATE [Inspector].[ServerSettingsConfig] SET [IsActive] = 1, [value_in_use] = 1 WHERE [Servername] = N'PHENOM' AND [Setting] = N'backup checksum default';

Back to Top


Top 5 Databases by size

Server nameDatabase nameTotal size(MB)
PHENOMStackOverflow201352000
PHENOMTPCC_100_Warehouses11920
PHENOMDBA8400
PHENOMDBA_snapshot5192
PHENOMInspectorNewInstall4098

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




Server [ALL Servers]


The following Database files have grown more than 1 time(s) in the past 24hours:

Server nameDatabase nameType descFile IDFilenamePre Growth Size MBGrowth Rate MBGrowth IncrementsPost Growth Size MBSuggested Growth Rate MBGrowth Rate trend (Last 5 days)
PHENOMDBAROWS1DBA.mdf71126467496100 [Thursday 384 MB], [Wednesday 320 MB], [Tuesday 64 MB], [Sunday 64 MB]

Advisory Highlight - More than 1 growth event/s in the past 24 hours
Warning Highlight - 10 or more growth event/s in the past 24 hours

Back to Top