Activity overview
Latest activity by tvandurme
Thanks Russell, posted on uservoice. / comments
Thanks Russell, posted on uservoice.
Performance graphs on disk space alert page
When we get to the disk space alert details it shows -as with all alerts- a bunch of performance graphs like CPU utilization, disk queue length etc... I think the most relevant graph is missing for...
Grant said:
Yay!
Spotlight hides it's own activities from the monitoring results. It's kind of odd. I've never seen a monitoring tool do that before.
Just would like to add a note to this now that we've had SQL Monitor on board for some time. How would you explain the --RedGateIgnore comments inside the monitoring scripts you use? It seems SQL Monitor also hides itself... The predicate for reporting on top queries (using [tempdb]..[redgate_sqlmonitor_topqueries_xxx temp tables) includes WHERE CHARINDEX('RedGateIgnore', batch_text) = 0 Or maybe I'm misinterpreting this? / comments
Grant said:
Yay!
Spotlight hides it's own activities from the monitoring results. It's kind of odd. I've never seen a monitoring tool do that before.
Just would like to add a note to this n...
SQL Express has the SQL Agent service disabled by default - no need to create an alert
Not so much of a question, just a suggestion. SQL Monitor alerted me of the SQL Agent service being disabled on a monitored server that runs Express edition. Make SQL Monitor even smarter and don't...
No problem Alex! Ok, thanks for the detailed answer. I prefer not to touch the repository though. I'll just deal with it as it is [image] Kind regards Thierry / comments
No problem Alex!Ok, thanks for the detailed answer. I prefer not to touch the repository though. I'll just deal with it as it is Kind regardsThierry
Hi Alex thanks for the quick reply! However, as I mentioned, I'd like to suspend rather than disable so I can be sure that after the suspension period I specified, the alert is re-activated automatically. I'm sure we'll forget we disabled it... Kind regards Thierry / comments
Hi Alexthanks for the quick reply! However, as I mentioned, I'd like to suspend rather than disable so I can be sure that after the suspension period I specified, the alert is re-activated automati...
Suspend monitoring for a single job
Hi,I'd like to know whether it's possible to suspend monitoring for a specific job or if it could be added as a new feature. We have dozens of log shipping jobs and we have one failing. That means ...
I agree. It shouldn't... / comments
I agree. It shouldn't...
Actually, we evaluated SQL Monitor already and purchased 35 or so licenses [image] It was just something that caught my eye just now...
Btw, I know Spotlight offers the ability to exclude its sessions from wait events and workload analysis. I don't know if you were referring to that when you say it masks its calls?
Anyway, both have their pros and cons.
Thanks for the quick replies! / comments
Actually, we evaluated SQL Monitor already and purchased 35 or so licenses It was just something that caught my eye just now...
Btw, I know Spotlight offers the ability to exclude its sessions fro...
Grant wrote: »
So the top 10 is always just a snapshot. We don't continually poll the server in such a way that you can see queries scrolling by on your screen. You can update the snapshot just by clicking the button up on the timeline that will move everything to the latest data.
Ok, thanks Grant. The reason I asked... We have both SQL Monitor and Spotlight running and was comparing them when I came to this conclusion. Personally I think a troubleshooting tool should be able to show what is going on in real-time as well as historically. Say for instance a blocking issue is causing issues, Spotlight allows me to see what is going on in real-time and even allows me to kill a specific session. It also allows me to see details about past blocking issues. SQL Monitor only allows the latter... / comments
Grant wrote: »
So the top 10 is always just a snapshot. We don't continually poll the server in such a way that you can see queries scrolling by on your screen. You can update the snapshot just...