Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-08-21 : 16:41:58
|
| Since we share the same name.....I used spotlight at my previous employer. Very nice tool, visual and would highlight when certain thresholds were exceeded. It allowed for a quick notification of issues and faster response by us as we weren't running profiler and being totally reactive AFTER the fact. We were still reactive but usually while the issue was occurring, making it easier to determine where the problem was (don't get me wrong, profiler has it's place in my toolbelt!). Never used that particular Idera product but I did use SQLSafe and liked it. Most third party vendors have free eval downloads. I'd suggest downloading both and evaluating them to see which meets your needs the best.Terry |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 23:49:28
|
| SQLDm doesn't put anything on monitored server while spotlight creates db and agent on each of them. |
|
|
|
|
|
|
Performance Monitoring