Optimized Performance

[delaap]

I have a W2K Server that is running SQL Server2000 and not a lot else. My question is for optimized performance for the database server should I set the Application Response (Advanced Tab - System Properties) to be Applications or Background Services ?
Thanks in advance

 

[tlbroadbent]

Select Background services to get the best SQL Server performance. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.