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)
 monitoring vitals of server

Author  Topic 

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-11-27 : 15:46:50
Hi Gurus !!

I need help to genrate a report that includes CPU utilization and memory utilization for each server that i have added as linked servers. basically i am looking for some scripts that i can schedule as a job and can transfer the output in excel format.
please help me out for solve this issue as this is realy getting critical day by day and i m short of time now :(

Thanks in advance

Regards
Chander

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-27 : 19:02:17
You can use Third-party tools like SQL Diagnostic Manager (Idera) or other Redgate tools for it.
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-11-27 : 21:12:49
Hi Sondeep,

i dont have any third party tool nor i wanna use the same, i actually want to genrate the report with the given utilities of sqlserver, please suggest and advice.

regards
chander
Go to Top of Page
   

- Advertisement -