Posted by Robert Klemme on 12/19/06 16:24

On 19.12.2006 15:48, tlyczko wrote:
> Hello, I've been reading about this topic, and I've gotten myself more
> confused, not less.
>
> We have a single-processor license SQL Server Standard 2005 (xeon 2.8
> ghz) with 4 GB RAM in Windows Server 2003 SP1 Standard.
>
> I turned on the /3GB switch in boot.ini but not PAE or AWE, would it be
> good to have either one??
>
>>From what I have seen so far, these are advanced settings for bigger
> servers or databases than we presently have.
>
> The SQL server is for Great Plains accounting, the largest db is around
> 3 GB now, and probably grows a GB per year.
>
> We have Abra Suite running as well, someday this will get changed over
> to a SQL database, it is FoxPro for now.
>
> I know not to have IIS or other apps running on this box, other than a
> couple Access files that are accessed by client apps.
>
> We expect to make more use of this server in the coming years, to
> contain intranet database files and web app files and maybe even
> SharePoint, maybe someday we need a bigger server..
>
> I was advised to remove or reduce the pagefile size, how should I
> determine how big the pagefile should be?? I am thinking 1 GB down from
> 4 GB.

That's not exactly a MS SQL Server question. Generally you should set
max memory *in* SQL Server to be not more than physically available.
Other than that I have no advice to offer.

Regards

robert

[Back to original message]