Tag Archives: SQL Server

Waiting for a job to complete

Posted on July 21, 2020 by thomasrushton

You know how it is. You need to wait for a job to complete before moving onto the next one… And, just sometimes, you need to do the same with SQL Server. MSDB The msdb system database contains various tables … Continue reading →

Posted in Uncategorized | Tagged , , , | 3 Comments

Departure of a SQL Server Administrator – What to Check?

Posted on January 3, 2020 by thomasrushton

A SQL Server administrator has left. But what does that actually mean? What do we need to check to make sure that things will continue to work after their Active Directory account is disabled? Some things to check are: SQL … Continue reading →

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

SQL Server Error 18456 Severity: 14 State: 73

Posted on May 14, 2018 by thomasrushton

A question asked on one of the forums today wasn’t easily answerable by Googling. Summary of the question “I have error 18456 State 73 – why?” Google seemed remarkably quiet on the subject of that particular state code. Even Aaron … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

Longrunning Query – xp_cmdshell?

Posted on April 25, 2018 by thomasrushton

Flicking through the ol’ Solarwinds activity monitor, I spotted this one day: That four day purple thing on the right? Not good. (The remaining images are from a reconstruction, partly to protect the not-so-innocent, and partly because the first job … Continue reading →

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

Setting SQL Server Maximum Memory

Posted on January 14, 2017 by thomasrushton

One of the dafter defaults in SQL Server is the Maximum Server Memory (MB) – set to a value of 2147483647. Who has a server with 2PB RAM? Give me a call if you do – I want to have … Continue reading →

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

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

SQL Server Performance Monitor counters missing

Posted on October 17, 2015 by thomasrushton

Another day, another batch of servers to build and add to those being monitored in Redgate’s SQL Server monitor. Reminder – these servers are being built in a consistent process, using a brace of PowerShell / azure scripts and a … Continue reading →

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