Tag Archives: Monitoring

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

Memory Pressure in SQL Server

Posted on March 27, 2016 by thomasrushton

Servers with memory pressure are a nuisance – be they badly specified or misconfigured. Either way, they’re not performing properly. But the question is how often and how long are they affected? How to Identify For Memory Pressure Query from … Continue reading →

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

Using Redgate SQL Monitor with Azure Virtual Machines

Posted on November 9, 2015 by thomasrushton

We have an environment built out of SQL Servers installed on Azure Virtual Machines. We want to use Redgate’s SQL Monitor to monitor this environment; however, as of version 4.x it wasn’t completely supported on the Azure platform. Mainly, I … Continue reading →

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

T-SQL Tuesday #35 – Soylent Inbox

Posted on October 9, 2012 by thomasrushton

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading →

Posted in T-SQL Tuesday | Tagged , , , , | 1 Comment

Querying SQL Server Event Logs to search for DBCC CheckDB output

Posted on September 12, 2012 by thomasrushton

This is a long-winded response to a query raised on AskSSC, about how to report on the running of DBCC. One way suggested was to use Ola Hallengren’s scripts to schedule and report. However, I have another way that I … Continue reading →

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

Housekeeping, News, No SQL content

Posted on May 27, 2011 by thomasrushton

Nothing SQL-related to read here, so if that’s what you’re after, forget it for this month! A couple of things have happened recently that haven’t necessarily warranted their own post, but, seeing as I’ve not done anything else blog-wise this … Continue reading →

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

Agresso Database Servers – Maintenance Checklist

Posted on November 16, 2010 by thomasrushton

This is some information that was not made available to us, the DBA team, on a site I worked at recently.  I suspect that I was not in a unique situation, so I’m providing the DB Server parts of those … Continue reading →

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