Thank this author by sharing:
By Dale Elizabeth Corey,
2006/09/29 (first published: 2004/09/28)
Did you ever wonder what the heck all those property settings meant in SQL Server 2000’s client tool, Enterprise Manager, and whether or not you really needed to tweak them? What are the key points? It never hurts to review.
The first question to answer is, “What is the fastest way to get to the Configuration Properties?”
That’s easy! Just open Enterprise Manager, and from the main menu, click on Tools => “SQL Server Configuration Properties…”. You can also right click the Server Group (i.e., (local) (Windows NT)) and click on Properties. For more advanced configuration properties, you can use stored procedures in Query Analyzer.
The General Tab
So let’s talk about the first tab in Enterprise Manager’s SQL Server Configuration Properties, the General tab, in the Configuration Properties window (see Figures 1, 2, 3, and 4 below).
What are the key points of the General tab?
The Memory Tab
Key points (Figure 5):
Key points (Figure 6):
Key points (Figure 7):
Key points (Figure 8):
However, you are probably better off adding memory and/or clustering and let SQL Server determine the maximum number of user connections.
Server Settings Tab
Key points (Figure 9):
Database Settings Tab
Key Points (Figure 10):
Key Points (Figure 11):
Active Directory Tab
Key Points (Figure 15):
It is nice to have options like the Configuration Properties wrapped up into a nutshell. Sometimes the options can seem “under described” and some of us tend to click before really know whether it’s a good option or not. Hopefully, these Key Points will help you along. Please be aware that there is a stored procedure (sp_configure) in Query Analyzer that will give you access to more advanced options for configuration purposes. Try it out when you get a chance:
exec sp_configure ‘show advanced options’, 1
SQL Server 2000 Administrator's Pocket Consultant: Configuring and Tuning Microsoft SQL Server. (2001, July 19). Retrieved August 25, 2004 from http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c02ppcsq.mspx
Server configuration change-URGENT
A properly configured SQL Server can mean the difference between a sluggish server and one that runs...
Introduction to Query Store covered here.
Now for the second part on “How to Configure?”
SQl server Configuration error