I have a Windows 2003 standard edition server with SQL 2000 standard edition running on it.
About 20 workstations with 3-D CAD programs running locally are connected to the server to open and save CAD files.
SQL server is used only to point to the locations of each CAD files that users need to use.
Each workstation has a network drive mapped to the share folder of the server.
All this said, what's the best performance settings for this server?
I am talking about processor scheduling, memory usage, virtual memory etc.
Thank you for your time.