On occasion I have seen Database Administrators enabling the SQL Server “Boost SQL Server priority” option. This option is available on the Server Properties Window under Processors:
Archive for June, 2011
June 12, 2011 by Francois · 3 Comments
Filed under: Administration
Social Tagging: CPU • server properties
Filed under: Administration
Social Tagging: CPU • server properties
June 2, 2011 by Francois · Leave a Comment
Filed under: Administration
Social Tagging: DBCC • memory • server properties
Filed under: Administration
Social Tagging: DBCC • memory • server properties
The default value for SQL Server 2008 Maximum Server Memory setting is 2,147,483,647 MB (or 2.1 petabytes!). Therefore, by default, SQL Server will use all available memory for its own use:
RSS