CPU and memory monitor

Question

CPU and memory monitor

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

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: 52781 More actions · Answer 2

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 · Answer 3

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