Tag Archives: Memory

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