What should you do about memory dumps?

A SQL Server monitoring tool is warning you that you’re getting memory dumps, and you’re wondering what that means.

How Much Memory is “Normal” for SQL Servers?

When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.

All the memory

Target Memory

SQL Server Memory

SQL Server Memory in Task Manager - Should I be Worried?

SSC Clinic: Finding the rogue query

When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.

SQL Server Memory Management Explained

Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.