An updated version of SQL Server Management Pack is ready. It has many new features which are mostly based on your feedback.
Please download at:
Microsoft System Center Management Pack for SQL Server
Added a new “Securables Configuration Status” monitor targeted to SQL Server databases
Updated the “Product Version Compliance” monitor with the most recent versions of public updates for SQL Server
Updated the “Securables Configuration Status” monitor targeted to the DB Engine when a SQL Server instance participates in Availability Groups
Removed the “Securables Configuration Status” monitor targeted to the Availability Replica as non-useful
Updated the “SQL Server Database Engines” discovery; the “Netbios Computer Name” property is now uppercased.
Fixed the Alerting Rules data source to avoid an alert storm after exiting maintenance mode
Fixed the SQL Log Reader data source to support changing of the SQL Authentication method
Fixed the Performance Reader data source to support changing of the SQL Authentication method
We are looking forward to hearing your feedback.
The "Long Running Jobs" monitor often had false positives whenever the SQL Agent is restarted. On this monitor's SQL query can you please join in the Agent's start date as described in here? https://dba.stackexchange.com/questions/63349/oprhaned-entries-in-msdb-sysjobactivity
Hello @RMacN1295 , thanks for reaching us out!
We’ll put this item in our backlog for the next release, but no more precise ETA yet though.
We look forward to hearing your feedback in the future.
Now we're preparing the next release of the SQL Server MP and looked at this feature request. Currently, we found that the monitor "Long Running Jobs" calculates the duration time for jobs that currently running as well as for jobs that have already been completed. Its behavior not quite clear and could lead to false positives. Could you please tell us it's that fix are you waiting for, or are we missing something? Btw, the better way to maintain the conversation is our alias SQLMPsfeedback@microsoft.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.