Posts
Sort by recent activity
Warning: Not enough data to plot one or more items
Get this error when trying to view size metrics (total/data/log) on Analysis.
The database(s) chosen are up and running for the time period chosen....
Clock skew
I'm getting a lot of 'clock skew' alerts, and within a few minutes of synchronizing the clocks on the base and a monitored server, it is out again by 20 secs or more. The monitored server is a VM ...
JOIN condition limited to immediate previous table
A suggestion...
when suggesting the final join conditions for the following
select *
from tableA
join tableB on tableA.Aid = tableB.Aid
join tableC on tableB.Bid = tableC.Bid
join tableD on ..........
Not getting low disk space alerts
I'm having issues with 'low disk space alerts'
I've edited the alert from 80% to 95% for a particular server.
Then I copied some files to exceed that threshold.
I did not get an alert
Check the con...
Enhancement - missing, unused and duplicate indexes
Enhancement Request
using DMVs from SQL2005 and up.
Add to Recommendations:
Missing Indexes
Unused Indexes
Duplicate / overlapping indexes
Enhancement - clear alerts using keyboard
SQL response v1.3.0.58
Sometimes it would just be handy to clear alerts with some keyboard shortcut i.e.without having to right click and choose 'Clear Alert'
You can highlight a chunk of alerts us...
Alert pane UI bug when expanding/collapsing sections
SQL Response 1.3.0.58
In the alert details pane, if you click one of the expandable section headings, the section toggles between expanded and collapsed, and the icon changes from '-' to '+' and vi...
Computer unreachable alert - ServerUpMonitor:COM Error
Intermittently getiting a 'Computer unreachable' alert from one of my monitored servers.
It is in a different domain, however DCOM has been configured through firewall, and up until today all seeme...
Low physical memory alert - no SQL process
On one of my monitored servers I am getting the 'low physical memory' alert, but the alert details does not pick up the fact that SQL is consuming most of the memory:
Low memory detected at 27/04/...
'Job did not start' alerts for 0 duration jobs
I have been getting 'job did not start' alerts for some of the jobs on my production server, but when I check the jobs in SSMS, they have started, succesfully competed, but have a duration of 00:00...