CPU and memory monitor

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737630

  More actions

  June 13, 2011 at 9:32 am

  #1337842

  Look at the columns in the DMV. Create a table with the same columns, perhaps with one more for timestamping. Then insert data from the DMV select into that table.

• sqlfriend

  SSC Guru

  Points: 52792

  More actions

  June 13, 2011 at 11:24 am

  #1337928

  Thanks, but for monitoring Memory and CPU which are the dmv tables should I use?

  Thanks

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  June 13, 2011 at 12:25 pm

  #1337970

  You should look into using SQL Server Extended Events for this monitoring.

  Introducing SQL Server Extended Events

  http://msdn.microsoft.com/en-us/library/bb630354(v=SQL.100).aspx