Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

background services or application for performance

Status
Not open for further replies.
Jun 27, 2001
837
US
On Win2000 server running SQL 2000 Enterprise edition, should the advanced setting on performance options for Win2000 be set for running background services or applications?
 
Background Services. SQL Server runs as a service. You don't want to give a higher priority to a program that someone is running in Windows the server or SQL Server performance could degrade. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top