question

nick2012 avatar image
nick2012 asked

CPU/RAM utilization

Hi all, Is there any way to check CPU/RAM utilization from a last week at a particular time and whats causing it. Thanks
performancecpucheckweekslast
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Do you have monitoring software? Was it running at the time?
1 Like 1 ·

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered
I suspect that going back through the history of your monitoring application (if you have one) will be your best bet. If you need something a bit nearer to the present, this query might help (Nicked from Benjamin Nevarez - read the rest of his blog post [Getting CPU Utilization Data from SQL Server][1] for a more details and another friendlier query): SELECT timestamp , DATEADD(ss, ( -1 * ( ( cpu_ticks / CONVERT (FLOAT, ( cpu_ticks / ms_ticks )) ) - [timestamp] ) / 1000 ), GETDATE()) AS EventTime , CONVERT(XML, record) AS record FROM sys.dm_os_ring_buffers CROSS JOIN sys.dm_os_sys_info WHERE ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR' AND record LIKE '% %'; But it only goes back four hours or so. [1]: http://sqlblog.com/blogs/ben_nevarez/archive/2009/07/26/getting-cpu-utilization-data-from-sql-server.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.