SQL Management Pack for SCOM – v7.12.1619.0
The publicly available links for SCOM management packs don’t always get updated correctly. This has been an issue for the last few releases of the SQL Server MP. As of today, this is the latest release (official download page): Microsoft System Center Management Pack (Release To Manufacturing) for SQL ServerVersion: 7.12.1619.0 NGL, this download offering …. Read More
Microsoft.SQLServer.Replication.Windows.Discovery SQL Queries (v7.0.28.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
Microsoft.SQLServer.Replication.Windows.Monitoring SQL Queries (v7.0.28.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
Verify SQL Server Securables with PowerShell
Display the access configuration status of SQL Server Database securables on Windows.(There’s also a management pack with agents tasks located here.) DBEngine Securables Database Securables