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 |
|
dontipton
Starting Member
8 Posts |
 Posted - 2002-03-12 : 16:28:40
|
| Can anyone suggest some good monitoring/Tuning software for use with SQL Server 2000?ThanksDondtipton@state.oh.us |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-12 : 16:42:47
|
| SQL Profiler comes with SQL Server and allows you to trace execution and events on the server. Performance Monitor/System Monitor is a Windows utility that has counters that monitor peformance, there are numerous counters for SQL Server that cover pretty much everything. These are not only free but standards. Unless you've already gone through them and find them lacking (can't see how IMHO) they're probably the best tools you can use.SQL Server also has some tuning wizards (Index for one) that can use Profiler traces and other statistics to recommend performance enhancing actions for you. Books Online has details on it. |
 |
|
|
|
|
|
Monitoring/Tuning Software