SBS 2003 Performance Options

goliveuk
goliveuk used Ask the Experts™
on
Hello,

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 ?

Comment
Watch Question

Do more with

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


Best Regards

Markus
Go to:

http://technet.microsoft.com/en-ca/library/cc917695.aspx

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