Posts
Sort by recent activity
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...
Autocomplete does not correctly prefix columns
See the code below for an absolutely useless query that I created just to repro in a simple AdventureWorks scenario:UPDATE Person.PersonWhen I type the FirstName column name I get two options, from...