Tag Archives: SQL Server

Setting SQL Server Maximum Memory

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

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

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