Wednesday, August 31, 2016

Performance related trace-flags for SQL Server 2005 & 2008


I mostly wanted to post this in order to record it for later reference.
If you're interested in these flags, please proceed to the MS Support site using the following link.

https://support.microsoft.com/en-us/kb/920093?sd=rss&spid=16139
 

MS SQL Server Max Memory Size for given Server Physical Memory

Glenn Berry , over at SQL Server Central , has written an excellent and straight-forward guide to initial settings for max memory in SQL Ser...