Posts
Sort by recent activity
should Blocking Process Alert thresholds be based on duration, not cumulative time
Blocking Process alerts are fired when a threshold of time is passed, however I think the calculation that is used needs some tweaking.From what I've seen, if a process_A is blocking for a duration...
SQL Monitor menu bar on smaller screens
Viewing SQL Monitor maximised on a normal wide monitor, the black menu bar at the top contains 'Documentation', 'Learn' and 'Get in touch' options in between 'Log out' and 'What's new'on a smaller ...
Victimless deadlocks
From 8.0.22, the release notes state victimless (eg Exchange Event) deadlocks are excluded by defaultIn the alert configuration for Deadlock alerts we have the checkbox
Alert when deadlock has no v...
Data storage purging and location
I'm running DLM Dashboard (v1.7.5.1116) and the data is being stored in C:\ProgramData\Red Gate\ SQL Lighthouse\Raven DBThis folder has grown to 33GB, which is nearly 50% of the drive.Is there any ...
NUMA-aware metrics
Without getting into the detail about the relative usefulness of various counters, have you ever considered adding NUMA nodes to the metrics in SQL Monitor?
Some counters (target, total memory) are...
Re-fire or re-check alerts
Can I get SQL Monitor to re-check alerts?
The situation I have is that I was setting up SQL Monitor for a new server, and as soon as data collection was correctly configured, a whole host of alerts...
Mixing metrics on analysis graph
When showing more than one metric on a graph on the Analysis page, I fully understand that it is difficult to merge the units scales on the x axis. So what you get is each graph has it's 'own' x ax...
Deadlock (extended event) not displaying much
So I'm guessing that the new deadlock feature in 7.1.5 only handles certain types of deadlock?
Do you want me to send over the deadlock details for this one?
UniversalAuthenticationAccessTokenCache
Why am I getting lots and lots (over 50 per minute) of these errors in the SQL Prompt log
15 Sep 2017 13:56:26,263 [1] INFO UniversalAuthenticationAccessTokenCache - No access tokens in cache, ret...
Background image on Analysis page date picker
SQL Monitor 7.1.4.8611
On the Analysis page, in the From date picker box, I've got some sort of grey icon behind the text?
F12 gives me
<input class="hour" type="text" style="width: 1.3em; backgro...