TheSQLGuru (3/13/2012)
Remember, max mem setting just controls the sql server BUFFER POOL - there are MANY other buckets of memory sql will use that are NOT constrained by that number.
Don't think I'd use the word 'many' there. Non-buffer memory is usually a lot smaller than the buffer pool, with a lot less in it. (unless using really wacky CLR that it)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability