Reports about issues (planned to be added)







Group Description Status
Restore Possibly Broken Log Shipping Completed
Backup Backups Not Performed Recently Completed at 31/01/2014
Backup Full Recovery Mode Without Log Backups Completed at 31/01/2014
Backup Backing Up to Same Drive Where Databases Reside. Some drive houses both database files AND recently taken backups. This represents a serious risk if that disk array fails. currently under development
Backup TDE Certificate Not Backed Up Recently. The certificate is used to encrypt database, but there certificate was not backuped up recently or backup is not up to date. currently under development
Backup MSDB Backup History Not Purged currently under development
Security Sysadmins List currently under development
??? Serializable Lock Hints Detected In a progress …
??? User-Created Statistics In Place In a progress …
??? Agent Jobs Starting Simultaneously In a progress …
??? RID or Key Lookups in the Plan Cache In a progress …
??? Memory Grants In a progress …
??? Change Tracking Enabled In a progress …
??? Full Text Indexes Not Populating In a progress …
??? Schedulers Disabled In a progress …
??? Extended Stored Procedures In a progress …
??? Change Log In a progress …
??? Documentation In a progress …
??? Poison Wait Detected In a progress …
??? Default Trace Contents In a progress …
??? Trace Flags Enabled Globally In a progress …
??? Transaction Log Larger than Data File In a progress …
??? Partitioned Tables with Non-Aligned Indexes In a progress …
??? @@ServerName Not Set In a progress …
??? High Virtual Log File (VLF) Count In a progress …
??? Failsafe Operator Not Configured In a progress …
??? Database Snapshot In Use In a progress …
??? Old Compatibility Level In a progress …
??? Stored Procedure Created WITH RECOMPILE Option In a progress …
??? Max File Size Set In a progress …
??? DBCC CHECKDB Not Run Recently In a progress …
??? User with Elevated Database Permissions In a progress …
??? Merge Replication with Infinite History In a progress …
??? Implicit Conversion In a progress …
??? Missing Index In a progress …
??? Cursors Found in Slow Queries In a progress …
??? User-Defined Functions Slowing Down SQL Server In a progress …
??? Date Correlation Enabled In a progress …
??? Only One TempDB Data File In a progress …
??? Queries Forcing Order Hints or Join Hints In a progress …
??? Uneven File Growth Settings in One Filegroup In a progress …
??? Page Verification Not Optimal In a progress …
??? Transparent Data Encryption in Use In a progress …
??? Auto Update Stats Disabled In a progress …
??? Tables in the Master Database In a progress …
??? Database Owners < > SA In a progress …
??? Server Logon Triggers Enabled In a progress …
??? System Databases on C Drive In a progress …
??? Endpoints Configured In a progress …
??? Multiple Log Files on the Same Drive In a progress …
??? Auto-Shrink Enabled In a progress …
??? Index Tuning Wizard Left a Mess Behind In a progress …
??? No SQL Server Agent Operators Configured In a progress …
??? Single-Use Plans in the Procedure Cache In a progress …
??? Cluster Node In a progress …
??? User Databases on C Drive In a progress …
??? Agent Alerts Not Configured In a progress …
??? Percent Growth in Use In a progress …
??? Security Admins List In a progress …
??? Linked Servers Configured In a progress …
??? Auto-Close Enabled In a progress …
??? Foreign Keys or Check Constraints Not Trusted In a progress …
??? Non-Default sp_Configure Setting In a progress …
??? Auto Update Stats Async Enabled In a progress …
??? Linked Servers Configured In a progress …
??? Enterprise Edition Features in Use In a progress …
??? Startup Stored Procedure Found In a progress …
??? Replication In Use In a progress …
??? Auto Create Stats Not Enabled In a progress …
??? Collation Mismatch In a progress …
??? Query Plan Guides Enabled In a progress …
??? Server Audits Running In a progress …
??? Tables Without Clustered Indexes In a progress …
??? Tables in the MSDB Database In a progress …
??? Tables in the Model Database In a progress …
??? Triggers Found on Tables In a progress …
??? Jobs Owned by User Accounts In a progress …
??? Memory Dangerously Low or Max Memory Too High In a progress …
??? Forced Parameterization Enabled In a progress …
??? Startup Stored Procedures in Master In a progress …
??? Indexes Disabled In a progress …
??? Resource Governor Enabled In a progress …
??? Slow Storage Reads or Writes In a progress …
??? Storage Corruption Detected In a progress …