RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

November 2010 Blog Posts

Max Server Memory....OOPS

Max Server Memory is actually Max Buffer Pool Memory. From the knowledge base: Note that the max server memory option only limits the size of the SQL Server buffer pool. The max server memory option does not limit a remaining unreserved memory area that SQL Server leaves for allocations of other components such as extended stored procedures, COM objects, non-shared DLLs, EXEs, and MAPI components. Because of the preceding allocations, it is normal for the SQL Server private bytes to exceed the max server memory configuration. That explains why it's using 30 and change GB when I...

posted @ Monday, November 22, 2010 2:00 PM | Feedback (0) | Filed Under [ KCTechBlog Syndication ]

Powered by:
Powered By Subtext Powered By ASP.NET