SBS 2003 Performance Options

goliveuk used Ask the Experts™

I have a SBS 2003 running on HP Proliant ML310 G5 with 3GB of memory. I have a company software using SQL server. I am wondering about that:

In advanced performance options there two options for memory usage:

Adjust for performance of:
Programs or System cache.

The default is Programs. If I change it to System Cache will that improve the SQL server performanace ?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Own Company
To increase the Performance of the SQL Server youc can change the Cache Size for the SQL Server.

Best Regards

Go to:

You can read the whole article, but what you want is under the section Configure sufficient memory for full-text search

Hope this helps...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial