Comments
Sort by recent activity
Thanks Russell, posted on uservoice. / comments
Thanks Russell, posted on uservoice.
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...
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...
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...
I agree. It shouldn't... / comments
I agree. It shouldn't...
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...