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 |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2009-12-25 : 01:07:23
|
| I've been looking at some third party software to deal with deadlocks and optimization and monitoring in general. I won't post their names here (some forums are sensitive about that) but there seems to be 3 or 4 main players. I'm just wondering what some of the established DBAs feel about these tools and if they are just fancy graphical versions of many of the stored procs and reports you can easily produce yourself inside SQL Server? I'm new to the DBA game and don't know if they are considered superfluous or a necessity.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-12-25 : 12:40:19
|
| I just have one. But I need a better way to isolate and deal with deadlocks. Our clients have been complaining about performance periodically. I can't leave the profiler running because the dashboard takes 50 seconds to load when the profiler is running and only 2 seconds when it is not running. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Third party software