Posted inSQL Server
SQL Server Memory Usage – Buffer
What is the SQL Server Buffer Pool? I am purposely keeping this post short because I simply want to offer up my script to show the current amount buffered. My…
Posted inSQL Server
Page Life Expectancy
Page Life Expectancy Page Life Expectancy is often quoted as being a key metric to watch out for memory pressure within SQL Server. If you search you will often see 300 listed…
Posted inSQL Server
SQL Server Memory: Max Server Memory or Task Manager is wrong
Issue 1: max server memory <> max server memory Okay so you have run sp_configure and checked SQL and it has stolen more memory than you told it to. Aghh!…