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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How do i evaluate load on my ISP's SQL Server?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-09 : 09:48:59
Rohan writes "Hi,
I wanted to evaluate the load on a shared SQL Server provided by my ISP. I have tried to use the @@CPU_BUSY,@@IO_IDLE,@@IDLE,@@CONNECTIONS system variables to view relevant information but this does not seem to display a value in milliseconds as described in the documentation. Please note, that i do not have the required rights to execute sp_monitor.

The version of server is SQL Server 7.0 running on Windows 2000 (sp1)

Thanks,
Rohan"

Glockenspiel
Yak Posting Veteran

50 Posts

Posted - 2002-06-25 : 11:31:06
See http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=17104

Go to Top of Page
   

- Advertisement -