Posted by tlyczko on 12/20/06 23:21

Russ Rose wrote:
> 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.

Hello, thank you for replying.

Disk space is not critical per se, I am inquiring about pagefile size
etc., SQL is doing well at managing itself for us, because someone in
another NG suggested I should eliminate or reduce the pagefile, it's
currently 4 GB when the memory has been increased to 4GB.

Thanks, Tom

[Back to original message]