Home Forums SQL Server 2005 Administering Help!... Memory Use on Windows 2008 R2, SQL Server 2005 x64. The physical is 98% RE: Help!... Memory Use on Windows 2008 R2, SQL Server 2005 x64. The physical is 98%

  • The max memory setting is just for the buffer pool. If SQL Server needs more resources for other things, it will use it.

    Do your databases have any CLR objects in them? Those can eat a lot of RAM if not managed correctly.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon