December 14, 2010 at 1:46 pm
A couple years ago I found a tool that was a lot of fun. It was a little bit heavy handed but it actually provided a good visualization of database activity - and I'll admit I ran it because it was fun to watch.
It had 4 main windows. I know one was based on Cache hit ratio. The one I really want to see again, though, is what we all called "The Bubbles".
It wasn't SQL Spy I don't think. This version of bubbles had one for each request that was active on the server. As the request used more resources the bubble would grow. If there was an open transaction the bubble would develop a red center. And if a request was blocking another request it would draw lines between the bubbles.
If anyone knows what I'm talking about, can you point me in the right direction please? I keep coming back to SQL Spy with my google searches and that isn't the tool I was using.
Thanks
December 14, 2010 at 2:04 pm
Are you referring to Spotlight from Quest Software?
December 14, 2010 at 2:30 pm
I believe SQLHeartbeat is what you are looking for
December 14, 2010 at 2:34 pm
Is it Idera's Diagnostic Manager?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 2:34 pm
Nope. It was free. And wasn't a company I recognized. Thanks for the suggestion.
December 14, 2010 at 2:36 pm
kent.kester (12/14/2010)
Nope. It was free. And wasn't a company I recognized. Thanks for the suggestion.
After checking SQL HeartBeat, it looks like that must be what you are looking for.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 2:40 pm
That's the one! Awesome. Thanks a ton.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply