Tag Archives: Monitoring

Wrapping up CPU Load Graphs into a Stored Procedure

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

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

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

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

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

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

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