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 Administration (2000)
 Simple SQL Question about System Tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-04-25 : 08:17:42
Joel writes "Hello!

I am trying to create a script in T-SQL that will return a snap shot of sql server operations like CPU, disk i/0, failures, exc.

Do you have a suggestion on what i would use for that and if SQL server logs that information so that i could perform a script that would show a history.


Thanks!

Joel"

jason
Posting Yak Master

164 Posts

Posted - 2005-04-25 : 14:41:05
Check out http://www.sql-server-performance.com.

Go to Top of Page
   

- Advertisement -