Friday, June 3, 2011

Configuring Server Startup Parameters in SQL Server Denali

In previous versions of SQL Server, whenever a DBA had to change the SQL Server startup options he had to carefully add or modify the entries which were separated using semicolons (;). In the case where you missed adding the entries correctly, the SQL Server service will not start. In the below snippet you can see how this was done for SQL Server 2005 and SQL Server 2008 under the Advanced Tab in SQL Server Configuration Manager.

In the new version of SQL Server “Denali” Microsoft has made configuring the SQL Server startup options an easy and simple process. Let's go through an example which demonstrates how one can configure SQL Server Startup Options.
1. In SQL Server Configuration Manager, click SQL Server Services on the left side pane.
2. In the right side pane, right click the SQL Server (<instance_name>) Service and choose Properties from the drop down menu.

3. In the SQL Server Properties window navigate to the Startup Parameters tab as shown below. 
  • To modify an existing parameter, select it from the "Existing parameters" list, make the change and click Updateto save. 
  • To add a new parameter, like a trace flag, type the new parameter and click on Add to save the change.
  • To remove an existing parameter select if from the "Existing parameters" list and click Remove.
4. Note that you still need to restart the SQL Server service for these changes to take effect just like older versions of SQL Server.

No comments:

Post a Comment