• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

SQL 2000 - background services on windows 2003

For a windows 2003 server running SQL server 2000, should I have process scheduling and memory usage set to programs or the alternatives (background services / system cache).

No-one logs on directly to the servers and it's main job is the servicing of the SQL databases.
1 Solution
Aneesh RetnakaranDatabase AdministratorCommented:
By default it is not needed ,
SQL 2000 runs as a Background service so it makes sense to set the process scheduling to "Backgound Services" and memory usage to "System Cache". These should be set like that as default on Win Server 2003.
Renato Montenegro RusticiIT SpecialistCommented:
SQL Server Setup do the configuration for you. That's why its not recommended to run another services in a SQL box. SQL makes some changes in the OS in order to increase performance.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now