SQL Server Health Check

The SQL Assessment solution is part of the Insights and Analytics solution offering. The solution provides assessments around the risk and health of your SQL Server environment. At this time, the solution supports SQL Server versions 2012 through 2016, and requires a supported version of .NET Framework 4 on any computers that have the Microsoft Monitoring Agent (MMA) installed. The solution also supports both directly-attached agents and agents that are part of a connected SCOM management group.

After you install the solution in your OMS workspace, a file called AdvisorAssessment.exe is added to servers with agents. The agents then read relevant data and send it to the Log Analytics service endpoints. Any SQL Servers ...

Get Microsoft Operations Management Suite Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.