Posted by Russ Rose on 12/20/06 01:59

In my experience with ~5GB Great Plains, 2GB memory is more than enough. I
would recommend against sharing an accounting server with any other
non-accounting applications for security reasons.

In advising on pagefile size we would need your disk layout, RAID level,
etc.

I prefer multiple fixed size, unfragmented, paging files spread across all
disk sets except the ones containing the transaction logs and tempdb. I also
size my server so that the paging file is rarely, if ever, used.

The pagefile is by default sized to do a memory dump if the server fails. I
have never met anyone who has actually used this memory dump for server post
mortem, but I'm sure someone has... However, if space is so short that 3GB
would matter then you likely need to get more and/or bigger disks. I prefer
> 50% free space on all disk sets.






"tlyczko" <tlyczko@gmail.com> wrote in message
news:1166539739.038505.10810@80g2000cwy.googlegroups.com...
> 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.
>
> Thank you for reading this, Tom
>

[Back to original message]