SQL Server 2005 Performance Audit : Operating System Configuration Performance Checklist

Have All Unnecessary Network Protocols Been Turned Off?

Generally, the only network protocol you need is TCP/IP for your server if you are only running SQL Server on it. Removing unnecessary network protocols on your SQL Servers helps by reducing the load on the server and by reducing unnecessary network traffic.

Is Antivirus or Antispyware Software Being Used?

Real-time antivirus and antispyware software creates a big resource hog for SQL Server, and is not recommended on production SQL Servers, especially clusters.

If you are worried about viruses or spyware, you can do remote scanning against your SQL Servers on a daily basis, preferably during off hours.

Now What?

Your goal should be to perform this part of the performance audit, described on this page, for each of your SQL Servers, and then use this information to make appropriate changes, assuming you can.

Once you have completed this part of the performance audit, you are now ready to audit your SQL Server’s configuration.

Pages: 1 2 3


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |