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 3  2530 
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
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" <tl*****@gmail. comwrote in message
news:11******** *************@8 0g2000cwy.googl egroups.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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jon Davis |
last post by:
I'm reposting this because I really need some advice.
I have a web app that makes many queries to the database on every page. In
order to save development effort, I've consolidated all database querying to
methods in a single static class, so whenever I need data, I pass a SQL
string to a method and I am passed a datareader or else individual values
(string, integer, etc).
There is a horrible memory leak in this application. Just one...
|
by: Peter Olcott |
last post by:
It looks like System::Collections::Generic.List throws and OUT_OF_MEMORY
exception whenever memory allocated exceeds 256 MB. I have 1024 MB on my system
so I am not even out of physical RAM, much less virtual memory.
Are other people experiencing this same problem?
|
by: narpet |
last post by:
Hello all...
I'm having a problem moving my swap file to a drive other than my primary drive. Right now I have a 3+ gig pagefile.sys that resides on my C drive. When I try to reconfigure (through the advanced options) it doesn't change.
Here's the weird part... it shows that it is configured to have the page file on the other hard drive, but the actual file still resides on C and I can't delete it (all of this is after a reboot). I even...
|
by: chrispy102 |
last post by:
Hi all,
I have developed a .Net app in MDI format. The problem that I have is that every time I change screens (New Child), the PC CPU PageFile usage increments a little. This happens until out of memory and I get a System.OutOfMemoryException.
Is there something subtle Im missing when opening/closing MDIChild forms?
I have written a sub to check that only 1 child is open at 1 time and close all child forms, before opening another:
...
|
by: George2 |
last post by:
Hello everyone,
Should I delete memory pointed by pointer a if there is bad_alloc when
allocating memory in memory pointed by pointer b? I am not sure
whether there will be memory leak if I do not delete a.
try {
a = new int ;
| | |
by: mansi sharma |
last post by:
I m Using the Foll. method to Read the Contents of a File. If i m reading the doc,txt prog is working file. I m using the File "D:\pagefile.sys", ERROR is there,The process cannot access the file 'D:\pagefile.sys' because it is being used by another process.
how To Read Contents of "D:\pagefile.sys".
Need UR Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Imports System.io
Module Module1
Sub Main()
Dim fs As FileStream
fs = New...
|
by: Bryan Parkoff |
last post by:
I want to know how much static memory is limited before execution
program starts. I would write a large array. The large array has 65,536
elements. The data size is double word. The static memory would allocate
256K. The 256K is a fixed memory size. After the compiler has completed
compiling header and source code, the execution program might fail to run or
crash. The operating system might do not display error message saying,...
|
by: Why Tea |
last post by:
typedef struct some_struct
{
int i;
short k,
int m;
char s;
} some_struct_t;
Assuming 16 bit or 32-bit alignment, can I assume that
s always gets 4 or 8 bytes of allocation due to padding
|
by: mitch12 |
last post by:
hi i have turned my page file off and deleted the pagfile.sys from my c drive so now i have no page file at all will this harm the performance in gaming at all i have 3gig ram installed thanks.
one more thing as i have no page file i think that the kernal must be in ram but in task manger it says this kernal memory
total 614000
paged 45000
none paged 15000
from them could you tell me if the kernal is runniing in the ram
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
