Getting CPU and I/0 usage from several Sql Servers

• vaddi

  SSC Enthusiast

  Points: 173

  More actions

  November 3, 2006 at 3:32 pm

  #61006

  Hello ,

  I would like a script for MSSQL 2000 for collection of utilization data for cpu and ram. I need to have the data from several servers.

  This data for all servers should be stored in a database. I am looking for 10 minute increments.

  How can I go about this.

  Thanks

• Sergiy

  SSC Guru

  Points: 110192

  More actions

  November 5, 2006 at 8:35 pm

  #669982

  exec ServerName.master.dbo.sp_monitor

  _____________
  Code for TallyGenerator