Great blog post about SQL Server memory usage.
Christian Bolton is a name some of you might recognize, but even if you don’t, and as Brent blogged – the guy is good. Here’s a recap that Brent put together that illustrates how SQL Server uses memory and some considerations (high level, but note the reference to his recent book) for memory resource planning.
As Brent mentioned, many DBAs still don’t leverage wait events to tune SQL Server. I have to believe that’s because either they don’t know about them, or because wait events are still really not very well documented anywhere…but if you take a look at Quest’s Foglight Performance Analysis for SQL Server you’ll see how leveraging wait events to tune SQL Server can be both easy and powerful.
