Posts
Sort by recent activity
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...
left/right arrows on Analysis Graph
I've either only just noticed this, or is it a new bug?
On the Analysis Graph page, the graph has a grey margin either side, with an arrow - clicking these does nothing. Is that right? I kind of ...
SSMS 2016 unresponsive, then broke SSMS 17
I know that SQL Code Guard is not yet supported on SSMS 17, but are there any known issues about running the 2 products together?
I had installed SQL Code Guard and was using it on SSMS 2016 (build...
Number of blocked descendants: Unknown
What are the causes when I get a Blocking Process alert, but the Number of blocked descendants shows 'Unknown'.
There is a value against Total blocking duration for all descendants, but there are n...
Summarize script ignoring certain query patterns
I'm using SQL Prompt 7.5.1.1000
When I choose Summarize Script for the following queryUSE [AdventureWorks2014]
GO
select
(select top 1 emailaddress from Person.EmailAddress),
dbo.ufnGetPurchaseOr...