12 December,2013 by Jack Vamvas
With every version of SQL Server , the default values get better. Since SQL Server 2005 – one of things I’ve found impressive is the default values on SQL Server. As with most technology – the default values are great for 99% of the users – but there are always DBAs who want to break the speed limit.
Read more on SQL Server has good default values
When completing a SQL Server health check – one check is to review the types of default values a DBA will attempt – in the ultimate search for the “sweet spot”.
I’m never surprised to see these default values changed : , awe enabled, Database Mail XPs, max server memory, min server memory.
Before making any changes to sp_configure default values – consider the consequences and test thoroughly
Check sys.configurations to review settings