Posts
Sort by recent activity
Don't check Agent status for Express Edition
Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.Well d'uh. It's Express Edition. The Agent service cannot run on it.Instea...
Several questions
Hi all!I have a few questions on SQL Monitor. They are unrelated; I hope combining them in a single post is not too much of a burden? Let me know if you prefer me to take down this post and re-post...
RECOMPILE appears to prevent query capture
I'm trying to investigate the root cause of a very long running data load of the DW server. But even after allowing it to run to completion, the "TOP 50 QUERIES" list does not show any of the offen...
Why are custom alerts not pre-selected when they should?
On the main screen of SQLMonitor, the right-hand side shows the latest alerts aggregated by type. If I click on one such category, e.g. "Job failing", it opens the Alerts page with "Job failing" se...
Custom metric running in transaction?
I am creating a custom metric to check if the service account has the Perform Volume Maintenance Tasks privilege so that Instant File Initialization can't be used. This metric uses xp_cmdshell to c...
Multiple alerts for a single custom metric
I have set up a custom metric that returns a metric as a percentage of the ideal number. (I've done it this way because the ideal number is not a constant).I have also set up an alert to tell me wh...
Alert settings - wildcard for level?
My customer has a standard disk configuration for their servers. C: is the system drive, is used for data files, E: for log files, and F: for tempdb.In SQL Monitor I have set up a disk space alert...
How to create a custom metric that monitors specific CHANGES
All of the custom metrics I have seen so far use a query on the SQL Server DMOs (dynamic management objects) to get a measurement value. That is great, but it excludes some categories of monitoring...
SQLMonitor on SQL Express - how to handle "database full" issue?
Hi all!One of my customers has SQL Monitor installed on a SQL Server Express instance. This morning I noticed that data collection was not working properly. There were no clear messages in the SQL ...
Proper place for product feedback
I always thought that this forum was intended (a.o.) as a means to
collect product feedback from your users (and even from non-users with
an interest in your products).Two weeks ago I opened a to...