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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-10 : 09:09:07
|
| Nickie writes "I would like to find a monitoring tools or perhaps develop one if necessary that will automate the monitoring process within SQL Server 2000 SP2. This should include constant checking the processes resources usage such as CPU and memory and whenever it hit a "spike", the tool is capable of logging what process/program, the sql statement, and probrably the cause of the "spkie" Appreciate if anyone can answer my question. TQ" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-10 : 09:13:32
|
| SQL Server has a built-in alert system that can trigger alerts and log performance spikes or bottlenecks. SQL Profiler also has the ability to monitor some performance information. And the Windows Performance monitor also contains performance counters for SQL Server (and other stuff too) Books Online details all of these very well, it's likely that some combination of them will suit your needs. |
 |
|
|
|
|
|
SQL Processes Monitoring Tools