Don’t Trust Task Manager

Gail Shaw warns against using Task Manager to figure out how much memory SQL Server is using:

Err, what? SQL Server’s not even using 100MB? I’ve just read 30GB of data and SQL Server’s not even using 1% of it’s allowed memory!!!

Or is it?

Spoilers:  it is.  Read the whole thing.

Related Posts

Separating Data And Log Files

Brent Ozar looks at an old chestnut: So it’s time for a quiz: If you put all of a SQL Server’s data files & logs on a single volume, how many failures will that server experience per year? Bonus question: what kinds of data loss and downtime will each of those failure(s) have? If you […]

Read More

47 Incorrect Deployment Assumptions

Brent Ozar has a list of 47 assumptions regarding database deployments that turn out not always to be true: 30. The deployment person wouldn’t dream of only highlighting some of it and running it. 31. The staff who were supposed to work with you during the deployment will be available. 32. The staff, if available at […]

Read More


January 2016
« Dec Feb »