| | DisplayName | Description | ID | Target | Parent Monitor | Category | Enabled | Instance Name | Counter Name | Frequency | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Monitor Type | Remotable | Accessibility | RunAs |
|---|
 | Missing OS Update KB957065 | Missing OS Update KB957065 to prevent file fragmenetation errors | AK54381.MissingKB957065 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | Normal | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| Missing Update KB971780 | Missing SQLServer update KB971780 can lead to incorrect queries. | AK54808.MissingUpdateKB971780 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | High | True | Microsoft.KnowledgeServices.Library.ScheduledOleDBMonitor | True | Public | |
| Missing SQL Server update KB979779 | KB979779 prevents SQL native client memory corruption | AK55097.MissingSqlUpdateKB979779_v1 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| number of tempdb data files might result in blocking | number of tempdb data files might result in blocking if there is more than one scheduler | AK56184.TempDBFilesBlocking | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.ScheduledOleDBMonitor | True | Public | |
| Missing SQL Server Update KB960770 | Missing SQL Server Update KB960770 or trace flag to potential TempDB errors | AK56185.MissingUpdateKB960770 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| Page_verify is not set to CHECKSUM | Page_verify is not set to CHECKSUM | AK60762.PageVerifyIsNotSetToChecksum | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.SchedulerMonitorEx | True | Public | |
| SQL Server configuration "Service Principal Name" (SPN) is incorrect | Rule for SQL Server configuration "Service Principal Name" is incorrect | AK61124.ServicePrincipalNameIsIncorrect | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| SQL Server has unsupported or invalid startup parameter configured | Generate alert SQL Server has unsupported or invalid startup parameter configured | AK79312.InvalidStartupParameterConfigured | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | High | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| SQL Server configuration "network packet size" can cause memory errors | Generate alert SQL Server configuration "network packet size" can cause memory errors. | AK79927.NetworkPacketSizeCanCauseMemoryError | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.SchedulerMonitorEx | True | Public | |
| Affinity mask conflict rule | Generate alert when "affinity mask" and "affinity io mask" conflicts. | AK79929.AffinityMaskConflict | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| Some modules in SQL server may cause server stability problems | some modules in SQL may cause server stability issues | AK80055.ServerStabilityModule | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.ScheduledOleDBMonitor | True | Public | |
| The Sqlserver is not supported by this version of OS. | In this we check whether the sqlserver is supportedb by the os. | AK80135.OSNotSqlServer | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | High | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| SQL Server 32-bit failover clustering is not supported on a 64-bit edition of Windows | SQL Server 32-bit failover clustering is not supported on a 64-bit edition of Windows | AK80153.32BitClusteringOn64BitWindows | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | High | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| SQL Server configuration "Delegation" may be incorrect | Rule for SQL Server configuration "Delegation" may be incorrect | AK81219.DelegationMayBeIncorrect | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.ScriptMonitorEx | True | Public | |
| SQL Server version is under limited support | Generate alert SQL Server version is under limited support. | AK85357.SqlVersionUnderLimitedSupportV4 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.SchedulerMonitorEx | True | Public | |
| AK115043 | SQL Server linked servers exist without the required providers installed | Monitor_AK115043 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK115317 | SQL Server database collation is different from model database collation | Monitor_AK115317 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.SchedulerMonitorEx | True | Public | |
| AK124404 | SQL Server database contains large number of virtual log files | Monitor_AK124404 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK146625 | SQL Server database transaction log may grow without a LOG backup for a database using the full recovery model | Monitor_AK146625 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK185028 | SQL Server missing update KB2491214 to prevent SQL Server hang | Monitor_AK185028 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Error | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK219342 | SQL Server msdb system database does not have connect permission for guest user | Monitor_AK219342 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK219738 | SQL Server missing update 2506235 to allow proper I/O processing for encrypted databases on hidden schedulers | Monitor_AK219738 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK224774 | Virtual host driver detected that can cause stability problems for SQL Server | Monitor_AK224774 | Microsoft.KnowledgeServices.Windows.OperatingSystem | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK54243 | Rule for Distributed and cross-database transactions are not supported on database mirroring enabled databases | Monitor_AK54243 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK545085 | SQL Server missing update 2550552 to avoid deadlock involving filesystem and filestream driver | Monitor_AK545085 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK546627 | SQL Server database file growth setting is more than the current available disk space | Monitor_AK546627 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK548903 | SQL Server msdb system database has trustworthy option set to OFF | Monitor_AK548903 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK549025 | SQL Server service SID is not present in the correct state | Monitor_AK549025 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK553910 | SQL Server filestream feature can benefit from filesystem settings change | Monitor_AK553910 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK555349 | SQL Server database file might not grow using the configured growth value | Monitor_AK555349 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK555799 | SQL Server missing update KB2277078 to prevent leak of security audit entries in TokenAndPermUserStore | Monitor_AK555799 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK561410 | SQL Server feature 'awe enabled' is deprecated | Monitor_AK561410 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.SchedulerMonitorEx | True | Public | |
| AK561862 | Windows operating system missing update KB2523134 to prevent log shipping process hang. | Monitor_AK561862 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK563234 | SQL Server missing update KB2550375 to prevent deadlock between log shipping jobs | Monitor_AK563234 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK563278 | SQL Server missing update KB2546951 to guarantee principal lazywriter is started | Monitor_AK563278 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK563279 | Windows operating system missing update KB2510206 to prevent performance issues when computer has more than 64 processors | Monitor_AK563279 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK573471 | SQL Server server-level principals configured with non-existent default database | Monitor_AK573471 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK574680 | SQL Server missing update KB2635827 to prevent exception during consistency check on table with spatial index | Monitor_AK574680 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK574681 | SQL Server database master key for master database is not encrypted by service master key | Monitor_AK574681 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK574781 | SQL Server missing update KB2626246 to prevent incorrect results problem | Monitor_AK574781 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK575166 | SQL Server security configuration does not allow System Center Advisor to function properly | Monitor_AK575166 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Error | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK580166 | SQL Server missing recommended updates when using data compression and table partitioning | Monitor_AK580166 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK581089 | System filter driver detected that can cause stability problems for SQL Server filestream feature | Monitor_AK581089 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK581408 | SQL Server database files marked as sparse files | Monitor_AK581408 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK587358 | Virtual machine SCSI configuration can cause stability problems for SQL Server | Monitor_AK587358 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK588769 | System filter driver detected that can cause problems for backups in SQL Server | Monitor_AK588769 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK588978 | SQL Server system health extended event session has incorrect event specification | Monitor_AK588978 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK589291 | SQL Server audit with fail operation option can cause fatal exceptions | Monitor_AK589291 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK589488 | Windows operating system missing update KB2468345 to prevent SQL Server getting paged out | Monitor_AK589488 | Microsoft.KnowledgeServices.Windows.OperatingSystem | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK600182 | Windows operating system missing update KB2679255 to prevent SetFileIoOverlappedRange corruption | Monitor_AK600182 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK606071 | SQL Server missing update KB2682488 to prevent backup failures on databases with CDC feature enabled | Monitor_AK606071 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK607932 | SQL Server configuration trace flag 845 is not necessary to enable locked page memory model | Monitor_AK607932 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK61923 | SQL Server feature "CLR integration" might result in memory errors or CLR load failures in the 32-bit version of SQL Server | Monitor_AK61923 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK63214 | SQL Server missing update KB971622 to avoid linked server usage related memory leak | Monitor_AK63214 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK63308 | SQL Server missing update KB974130 to avoid linked server usage related memory leak | Monitor_AK63308 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK77475 | SQL Server configuration "max degree of parallelism" might result in performance issues | Monitor_AK77475 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK78037 | SQL Server database contains unsupported .Net Framework Library assembly | Monitor_AK78037 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK79935 | Rule for SQL Server database option "Auto_Shrink" is set to ON | Monitor_AK79935 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.SchedulerMonitorEx | True | Public | |
| AK79937 | SQL Server feature "Instant File Initialization" is not enabled | Monitor_AK79937 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK80055 | SQL Server process has loaded modules that can cause server stability problems | Monitor_AK80055 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK80624 | MS DTC configuration for "network DTC access" might result in SQL Server linked server errors | Monitor_AK80624 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Low | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK80629 | SQL Server database present without a backup | Monitor_AK80629 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK80671 | Rule for SQL Server database present without a clean consistency check | Monitor_AK80671 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK80677 | SQL Server installer cache files are missing | Monitor_AK80677 | Microsoft.KnowledgeServices.Windows.OperatingSystem | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK80952 | SQL Server encryption certificates present without a backup | Monitor_AK80952 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK85448 | System filter driver detected that can cause performance and database consistency problems for SQL Server | Monitor_AK85448 | Microsoft.KnowledgeServices.Windows.OperatingSystem | System.Health.ConfigurationState | Alert | True | | | 0 | True | Error | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK85906 | SQL Server database files and backup files exist on the same volume | Monitor_AK85906 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AK96574 | SQL Server has differences between configured and installed configuration values | Monitor_AK96574 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN381575 | SQL Server configuration "max worker threads" might result in performance issues | Monitor_AKN381575 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN382366 | SQL Server database backup appended to existing backup devices might encounter problems | Monitor_AKN382366 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN395853 | Windows operating system missing update KB2155311 to prevent performance issues on a NUMA based computer | Monitor_AKN395853 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN418746 | SQL Server has multiple active traces which can impact performance | Monitor_AKN418746 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN421037 | SQL Server might have performance issue with Large NUMA based system if it has missing Lock pages in memory priviledge. | Monitor_AKN421037 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN421073 | SQL Server has stale statistics which can cause performance issue | Monitor_AKN421073 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN428034 | SQL Server might have performance impact if Indexes have high fragmentation | Monitor_AKN428034 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN428035 | SQL Server database option AUTO_CLOSE can impact performance if turned ON | Monitor_AKN428035 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN461487 | SQL Server agent startup issues with excessive number of agent jobs | Monitor_AKN461487 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN463803 | SQL Server configured with a low blocked process threshold might not detect blocking problems | Monitor_AKN463803 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.SchedulerMonitorEx | True | Public | |
| AKN463897 | SQL Server missing update 2511963 to prevent a query to stop an XEvent from hanging. | Monitor_AKN463897 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN464006 | SQL Server Database mail configuration issue may result in mail not getting processed. | Monitor_AKN464006 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN480157 | SQL Server performance may degrade when running on Windows Server 2008 R2 not using “High Performance” power plan | Monitor_AKN480157 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN480469 | SQL Server 2012 background task System Health Diagnostic collection session stops indefinitely | Monitor_AKN480469 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN518745 | SQL Server Database Files resides in an unsupported FileSystem | Monitor_AKN518745 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN518778 | SQL Server Database Backupset is marked as Damaged | Monitor_AKN518778 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN518816 | In this SQL Server instance advisor detected the absence of update KB976329. This update addresses some issues related to VSS Backup, backups can get corrupted if this update is missing.Refer the KB article for more details. | Monitor_AKN518816 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN538458 | SQL Server might return incorrect result if you query an indexed view by using the NO EXPAND Hint | Monitor_AKN538458 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN540026 | SQL Server database restore is vulnerable due to a broken log backup chain | Monitor_AKN540026 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN540048 | SQL Server Database might reside in a Advanced format type (512E) | Monitor_AKN540048 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN598813 | SQL Server has multiple TVFs which can impact performance | Monitor_AKN598813 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Information | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN598838 | SQL Server instance is 32 bit with AWE enabled and LPIM priviledge is missing | Monitor_AKN598838 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Information | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN598879 | Using filestream may cause SQL Server service to terminate | Monitor_AKN598879 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN616060 | SQL Server reports "non-yielding" message on a server for Service Broker Message Forwarding | Monitor_AKN616060 | Microsoft.KnowledgeServices.SQLServer.Database | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN616074 | The SQL Server build on this instance is lower than SQL Server 2012 CU4. | Monitor_AKN616074 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN616090 | SQL Server can hang when you try to perform snapshot based Backup/Restore | Monitor_AKN616090 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN616093 | This SQL Server instance is missing prerequisite hotfixes for AlwaysOn Availability Groups. | Monitor_AKN616093 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Information | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN616094 | SQL Server might shut down when an AlwaysOn Availability group replica changes role on Windows Server 2008 R2-based failover cluster | Monitor_AKN616094 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Information | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN631089 | Turning on trace flag 834 can cause instability of SQL Server that uses columnstore indexes | Monitor_AKN631089 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN631101 | SQL Server performance may be affected by a large size of transaction log or a large number of VLFs | Monitor_AKN631101 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN631483 | The default health check time-out for one or more replicas for one or more availability groups is altered | Monitor_AKN631483 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN631497 | The number of availability databases per computer exceeds 100 | Monitor_AKN631497 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN631498 | An availability group exists but the HADR Service is not enabled on the instance of SQL Server | Monitor_AKN631498 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Error | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN631838 | SQL Server process has 3rd Party modules that might cause SQL Server to crash. | Monitor_AKN631838 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN638358 | SQL Server Memory leak when queries run against a temporary table in a nested stored procedure in SQL Server 2012 | Monitor_AKN638358 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN638366 | Non-yielding scheduler issue when you use an outer join and a mismatching join criteria | Monitor_AKN638366 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Information | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN652407 | AMD Family 20(14h)/21(15h) Microcode Regression Leads to Instruction Pointer Corruption (RIP/IP) | Monitor_AKN652407 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN652417 | SQL Server Database is unsupported if the key security principals are altered | Monitor_AKN652417 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | High | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
| AKN652454 | SQL Server Database might be unavailable on a virtual machine with hot-add removable storage | Monitor_AKN652454 | Microsoft.KnowledgeServices.SQLServer.DBEngine | System.Health.ConfigurationState | Alert | True | | | 0 | True | Warning | Normal | True | Microsoft.KnowledgeServices.Library.PowerShellMonitorEx | True | Public | |
Home