Tag Archives: Performance

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 & Deadlocks 2 – Tweaks

Posted on September 26, 2019 by thomasrushton

Following on from the earlier post CPU Load Graphs and Deadlocks Bug fix Oops. Of course, I wasn’t expecting this system to have multiple deadlocks in the same minute, but, if you do have that situation and you use the … 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

Filtering sp_who

Posted on August 27, 2019 by thomasrushton

sp_who – useful – up to a point. Particularly when the server is busy, and you’re looking for something specific (eg to see if certain processes are out of a database before running an update) If the server is busy … Continue reading →

Posted in Uncategorized | Tagged , , , , | 2 Comments

A Problem with Boolean Logic

Posted on March 4, 2018 by thomasrushton

Your requirement: to find the things where either A or B is true and C is true. Your first draft might be this: (field, table, function, logic all anonymised to protect the perpetrator) What’s the problem? Operator Precedence, that’s the … Continue reading →

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

What A Difference An Index Makes

Posted on June 18, 2017 by thomasrushton

M’colleagues over the way were having problems with an upgrade / feature installation of McAfee EPO UDLP (no, I have no idea what that means). Looking at what was happening on the SQL Server that’s at the back of that … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

Notes on Instant File Initialization and Running Scripts on Multiple Servers

Posted on November 2, 2015 by thomasrushton

Instant File Initialization (IFI) IFI can be a useful performance booster if you’re in an environment where your database files grow regularly, although there’s an argument that if that happens regularly, you should grow them massively up front in a … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

45 Database Performance Tips for Developers

Posted on November 13, 2013 by thomasrushton

Just a quick post to point out that Red Gate has just put out an e-book of 45 Database Performance Tips for Developers. It’s free. And to sweeten the deal, they’re bundling it with a 14 day free trial licence … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , | 1 Comment