Tag Archives: DMV

Wrapping up CPU Load Graphs into a Stored Procedure

Posted on September 27, 2019 by thomasrushton

After the fun of the last few days, I thought it might be a better idea if I wrapped this all up into a single stored procedure. So I did that. Parameters I have implemented the following parameters: @ShowCPUAsLines (BIT, … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | Leave a comment

CPU Load Graphs with Deadlocks

Posted on September 25, 2019 by thomasrushton

Continuing on disappearing down the rabbit hole… Send help! Or coffee! Deadlocks I’m always being asked, sometimes being asked, somebody asked me once “what about the deadlocks? Can you show them on your CPU load graphs?” Oh, go on. First, … Continue reading →

Posted in Uncategorized | Tagged , , , , , | 1 Comment

CPU Load graphs

Posted on September 24, 2019 by thomasrushton

Following on from my recent post about CPU load discrepancies in the ring buffer, and in conjunction with some other stuff I’m doing at the moment, I found myself trying to draw graphs of the CPU load in SQL. Line … Continue reading →

Posted in Uncategorized | Tagged , , , | 4 Comments

Ring Buffer CPU Load Discrepancies

Posted on September 23, 2019 by thomasrushton

That’s quite a title. What does it mean? Ring Buffer CPU Load No, nothing to do with Wagner’s Ring Cycle This is about sys.dm_os_ring_buffers, an undocumented DMV that is “…identified for informational purposes only. Not supported. Future compatibility is not … Continue reading →

Posted in Uncategorized | Tagged , , , | 4 Comments

How long before that backup completes?

Posted on November 23, 2011 by thomasrushton

An early start this morning, as I need to back up a big reporting database before the guys at work start running some heavy optimisation process to rationalise and compress the data.  However, I don’t necessarily know how long the … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 2 Comments