Jon Gurgul's Blog

Tag: Memory

  • SQL Server Memory Usage – Buffer

    —

    by

    Jon Gurgul
    in

    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 version is very similar to that found on the main sys.dm_os_buffer_descriptors page, but I prefer MiB rather than pages. This next script will break down the buffer…

  • Page Life Expectancy

    —

    by

    Jon Gurgul
    in

    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 as a low water mark to indicate that you may have a problem, indeed several vendor applications raise warnings at this threshold. The standard definition…

  • SQL Server Memory: Max Server Memory or Task Manager is wrong

    —

    by

    Jon Gurgul
    in

    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! sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO sp_configure ‘max server memory’, 4096; GO RECONFIGURE; GO http://msdn.microsoft.com/en-us/library/ms178067.aspx Why do you fight me SQL Server? Use…