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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-03-10 : 07:35:54
|
| Hello ,Is there any way to monitor the database in SQL 7.0 or SQL 2000 through their in-built tools , if exists ? Rather than using third party tools like SQL Diagnostic Manager , Log explorer etc . How can we monitor the database problems on-line in this case and problem determination in SQL Server itself ? This info. would be of great help to me . Thank you very much .admin001 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-03-10 : 08:18:43
|
| AFAIK there is Perfmon that let you choose several counters (memory, disks,...) and of course SQL Server Profiler. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-10 : 23:31:45
|
| There is perfmon as Franco mentioned. Also, profiler, and you can set up alerts in SQL server as well to send you (Or anyone) a notice if certain severity level error occurs.Both perfmon, and profiler will impact system performance, and you don't want to run them cosistently on a production machine.-Chad |
|
|
|
|
|
|
Database Performance in SQL Server .