SQL Server Configuration Performance Checklist

Friday Dec 17th 2004 by DatabaseJournal.com Staff
Share:

This article looks at some of the performance-related SQL Server configuration settings.

[From WebProNews]

Most SQL Server Configuration Settings Should Not Be Changed

In this article, we are going to take a look at some of the performance-related SQL Server configuration settings. These are SQL Server-specific settings that can be modified using either Enterprise Manager or SP_CONFIGURE.

As the title of this article says, in most cases, you should not modify the default SQL Server configuration settings. This is because most of the default settings provided will provide the optimum performance for most SQL Servers. And most of all, if you are not exactly sure of what the implications are of changing a setting, it is possible to hurt your server's performance instead of boosting it.

The article continues at http://www.webpronews.com/it/database/wpn-20-20041217SQLServerConfigurationPerformanceChecklist.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved