Results 1 to 2 of 2
Feb 21, 2005, 03:18 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
How can i check the sql 2000 database activity?
iam working on a forum.
many users access this forum and post good number of messages.
but sometimes i get strange errors like
"The system cannot find the file specified. "
I suspect this is cuz load factor and want to check it in sql server 2000.
where can i do this?
and also how can i check the asp page activity like
whether all the objects are closed are still running?
early reply appreciated.Happy Coding!!!
Feb 21, 2005, 03:46 #2
What you need to do, for this kind of profiling, is to use the tool called perfmon.exe.
You can add all kinds of measuers to your profiling, including the number of asp connections and requests / seconds. Of course you can also keep an eye an just about all aspects of SQL server from here too.