June 8, 2009 at 2:27 pm
Can someone please provide advice on some "basic" sp_configure settings a good DBA should have set for SQL Server in order to achieve a high performance dataserver
Thanks.
June 8, 2009 at 4:15 pm
What works for one server, my not work well for another. You really need to accomplish this more on a server by server basis. Every application will be different, even the same application in different companies may need different setting for optimum performance.
June 8, 2009 at 4:22 pm
yes, it is case to case basis but few suggestions
1.Dont alter max worker threads, priority boost and lightweight pooling unless you have come to conclusion that it will improve your performance of sqlserver
2. Only thing which you need to check
32bit system
Enable AWE if you have more than 4 GB memory and would like to use them
Max server memory - cap it to some fixed value and leave atleast 2-4 GB for kernal and other app if it is a exclusive sql server and only one instance in the box
64 bit
Cap max server memory
June 8, 2009 at 5:38 pm
Thank you very much!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply