virtual memory--should we care

Hello:

For an XP workstation, Microsoft recommends setting the virtual memory to 
1.5 times the amount of RAM.  

But, should this also be done on a Windows Server 2003 with SQL Server 2005 
with only one hard drive with 3.50 GB of RAM?

And, if so, should both the Minimum and Maximum settings both be set with 
this amount of virtual memory?

This is a 32-bit server.

SQL Programmer (it's just a name)
0
Utf
1/22/2010 7:02:09 PM
sqlserver.server 1327 articles. 0 followers. Follow

5 Replies
760 Views

Similar Articles

[PageSpeed] 46

You're running SQL Server on a single disk system?

As to the RAM, 32-bit servers max at  2GB, unless you do one of the mods 
(like AWE). So, as long as nothing else is running, you should never page.

"SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message 
news:60BC3CCE-9A59-49E5-8FC2-B97B21BB9E82@microsoft.com...
> Hello:
>
> For an XP workstation, Microsoft recommends setting the virtual memory to
> 1.5 times the amount of RAM.
>
> But, should this also be done on a Windows Server 2003 with SQL Server 
> 2005
> with only one hard drive with 3.50 GB of RAM?
>
> And, if so, should both the Minimum and Maximum settings both be set with
> this amount of virtual memory?
>
> This is a 32-bit server.
>
> SQL Programmer (it's just a name) 


0
Jay
1/22/2010 8:30:36 PM
Hi Jay:

It's a dual processor on a single hard drive (C drive).

So, the virtual memory business should be ignored?

SQL Programmer (it's just a name)

"Jay" wrote:

> You're running SQL Server on a single disk system?
> 
> As to the RAM, 32-bit servers max at  2GB, unless you do one of the mods 
> (like AWE). So, as long as nothing else is running, you should never page.
> 
> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message 
> news:60BC3CCE-9A59-49E5-8FC2-B97B21BB9E82@microsoft.com...
> > Hello:
> >
> > For an XP workstation, Microsoft recommends setting the virtual memory to
> > 1.5 times the amount of RAM.
> >
> > But, should this also be done on a Windows Server 2003 with SQL Server 
> > 2005
> > with only one hard drive with 3.50 GB of RAM?
> >
> > And, if so, should both the Minimum and Maximum settings both be set with
> > this amount of virtual memory?
> >
> > This is a 32-bit server.
> >
> > SQL Programmer (it's just a name) 
> 
> 
> .
> 
0
Utf
1/23/2010 1:06:11 AM
Well, probably, yes. However, nothing and I mean nothing, replaces a DBA 
monitoring the system.

It's just that your original question was just bizarre. A question about 
using paging space implies a concern for performance, but a single physical 
disk can have some serious performance repercussions and frankly, the 2GB 
RAM default in the 32-bit server can be a bit like wearing jeans a size, or 
two, too small. Also, you've been vague about anything else using the 
system, which can also have major performance repercussions.

I would also be concerned that the database is not going to be configured 
correctly and/or that the transaction logs will not be maintained properly.

All in all, you guys may not know what you're getting into.

"SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message 
news:3670DFF6-784A-4C77-BBD5-F339A3B24786@microsoft.com...
> Hi Jay:
>
> It's a dual processor on a single hard drive (C drive).
>
> So, the virtual memory business should be ignored?
>
> SQL Programmer (it's just a name)
>
> "Jay" wrote:
>
>> You're running SQL Server on a single disk system?
>>
>> As to the RAM, 32-bit servers max at  2GB, unless you do one of the mods
>> (like AWE). So, as long as nothing else is running, you should never 
>> page.
>>
>> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in 
>> message
>> news:60BC3CCE-9A59-49E5-8FC2-B97B21BB9E82@microsoft.com...
>> > Hello:
>> >
>> > For an XP workstation, Microsoft recommends setting the virtual memory 
>> > to
>> > 1.5 times the amount of RAM.
>> >
>> > But, should this also be done on a Windows Server 2003 with SQL Server
>> > 2005
>> > with only one hard drive with 3.50 GB of RAM?
>> >
>> > And, if so, should both the Minimum and Maximum settings both be set 
>> > with
>> > this amount of virtual memory?
>> >
>> > This is a 32-bit server.
>> >
>> > SQL Programmer (it's just a name)
>>
>>
>> .
>> 


0
Jay
1/23/2010 4:32:54 AM
Thanks, Jay!

SQL Programmer (it's just a name)

"Jay" wrote:

> Well, probably, yes. However, nothing and I mean nothing, replaces a DBA 
> monitoring the system.
> 
> It's just that your original question was just bizarre. A question about 
> using paging space implies a concern for performance, but a single physical 
> disk can have some serious performance repercussions and frankly, the 2GB 
> RAM default in the 32-bit server can be a bit like wearing jeans a size, or 
> two, too small. Also, you've been vague about anything else using the 
> system, which can also have major performance repercussions.
> 
> I would also be concerned that the database is not going to be configured 
> correctly and/or that the transaction logs will not be maintained properly.
> 
> All in all, you guys may not know what you're getting into.
> 
> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message 
> news:3670DFF6-784A-4C77-BBD5-F339A3B24786@microsoft.com...
> > Hi Jay:
> >
> > It's a dual processor on a single hard drive (C drive).
> >
> > So, the virtual memory business should be ignored?
> >
> > SQL Programmer (it's just a name)
> >
> > "Jay" wrote:
> >
> >> You're running SQL Server on a single disk system?
> >>
> >> As to the RAM, 32-bit servers max at  2GB, unless you do one of the mods
> >> (like AWE). So, as long as nothing else is running, you should never 
> >> page.
> >>
> >> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in 
> >> message
> >> news:60BC3CCE-9A59-49E5-8FC2-B97B21BB9E82@microsoft.com...
> >> > Hello:
> >> >
> >> > For an XP workstation, Microsoft recommends setting the virtual memory 
> >> > to
> >> > 1.5 times the amount of RAM.
> >> >
> >> > But, should this also be done on a Windows Server 2003 with SQL Server
> >> > 2005
> >> > with only one hard drive with 3.50 GB of RAM?
> >> >
> >> > And, if so, should both the Minimum and Maximum settings both be set 
> >> > with
> >> > this amount of virtual memory?
> >> >
> >> > This is a 32-bit server.
> >> >
> >> > SQL Programmer (it's just a name)
> >>
> >>
> >> .
> >> 
> 
> 
> .
> 
0
Utf
1/23/2010 5:05:01 PM
Dude, you scare me.

"SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message 
news:314ED5E7-03B7-4286-BDE2-1756ECE10593@microsoft.com...
> Thanks, Jay!
>
> SQL Programmer (it's just a name)
>
> "Jay" wrote:
>
>> Well, probably, yes. However, nothing and I mean nothing, replaces a DBA
>> monitoring the system.
>>
>> It's just that your original question was just bizarre. A question about
>> using paging space implies a concern for performance, but a single 
>> physical
>> disk can have some serious performance repercussions and frankly, the 2GB
>> RAM default in the 32-bit server can be a bit like wearing jeans a size, 
>> or
>> two, too small. Also, you've been vague about anything else using the
>> system, which can also have major performance repercussions.
>>
>> I would also be concerned that the database is not going to be configured
>> correctly and/or that the transaction logs will not be maintained 
>> properly.
>>
>> All in all, you guys may not know what you're getting into.
>>
>> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in 
>> message
>> news:3670DFF6-784A-4C77-BBD5-F339A3B24786@microsoft.com...
>> > Hi Jay:
>> >
>> > It's a dual processor on a single hard drive (C drive).
>> >
>> > So, the virtual memory business should be ignored?
>> >
>> > SQL Programmer (it's just a name)
>> >
>> > "Jay" wrote:
>> >
>> >> You're running SQL Server on a single disk system?
>> >>
>> >> As to the RAM, 32-bit servers max at  2GB, unless you do one of the 
>> >> mods
>> >> (like AWE). So, as long as nothing else is running, you should never
>> >> page.
>> >>
>> >> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in
>> >> message
>> >> news:60BC3CCE-9A59-49E5-8FC2-B97B21BB9E82@microsoft.com...
>> >> > Hello:
>> >> >
>> >> > For an XP workstation, Microsoft recommends setting the virtual 
>> >> > memory
>> >> > to
>> >> > 1.5 times the amount of RAM.
>> >> >
>> >> > But, should this also be done on a Windows Server 2003 with SQL 
>> >> > Server
>> >> > 2005
>> >> > with only one hard drive with 3.50 GB of RAM?
>> >> >
>> >> > And, if so, should both the Minimum and Maximum settings both be set
>> >> > with
>> >> > this amount of virtual memory?
>> >> >
>> >> > This is a 32-bit server.
>> >> >
>> >> > SQL Programmer (it's just a name)
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>> 


0
Jay
1/23/2010 6:09:03 PM
Reply:

Similar Artilces:

virtual destructor
Hello, I have 2 classes; Class A and Class B. Class B is derived from Class A. I placed traced statements in both Class A and Class B destructor's. I received the same results regardless if Class B was declared virtual or not. Class B's destructor was invoked first then Class A's destructor. Are these results correct? If so, what's the purpose of declaring Class B's destructor virtual? TIA, -jacques Jacques Cooper wrote: > Hello, > > I have 2 classes; Class A and Class B. Class B is derived > from Class A. I placed traced statements in both Class A and &...

Virtualization
Just curious if any of you run/have run SQL Server in a virtual environment and what your opinion is on doing so? On Tue, 20 Jul 2010 08:44:25 -0500, Matthew wrote: > Just curious if any of you run/have run SQL Server in a virtual > environment and what your opinion is on doing so? Had SQL Server 2008 on Windows Server 2008 with Hyper-V. The only thing that stood in the way was Hyper-V limitation on 4 CPUs per virtual machine. Everything else was OK. You can check out this link for more info: http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b...

report timeout in CRM 1.2 on virtual pc (notebook)
Hi, I prepared images of mscrm 1.2 for virtual pc. On two desktop machines with 1 gig of memory, everything works fine. On a -besides this very performant- notebook with same memory specs, I get timeouts in crystal report viewer (nothing is shown and after a long while, an error message shows in the "html page" where the report should be). I increased timeout value on the "microsoft crm" II server app virtual directory to ..1800 or more: No chance. Did anyone see this happen? Any hint to resolve this? It seems to me like the disk access spped, which is much slower than on...

SW RAID-1 On Storage Virtual MiniPort
Hi, I want to develop a SW RAID-1 using Storage Virtual MiniPort driver, I hope this driver can choose two disks from system by using SCSI command, then reports a RAID-1 disk to system, is this idea could be accomplished by Storage Virtual MiniPort driver? If this idea is ok, what type of certification it need to pass from Microsoft? Regards, Perer, Hi all, I need the suggestion urgently, please give me a help, thanks. Regrads, Peter, "Peter" <peter_hsu@vasstek.com.tw> �b�l�� news:u8N5usgtKHA.3360@TK2MSFTNGP06.phx.gbl �����g... > Hi,...

Virtual Accounts?
Hi all, I would love to be able to create some 'virtual accounts' but I am not sure of firstly if it can be done and secondly how to do it. Basically I put away amounts each month for certain expenses but dont want t o have a bank account for each expenditure in order to see how much is curre ntly available for that category. I would prefer just to have one account a nd lump all the items together and then using Money have it break the curren tly levels of each down for me. e.g I put aside 100 per month for car tags. Since the car tags are only due once a year, I want to be able...

How to free memory when I use class CString?
Hi: Please look at the function: void CCstringDlg::OnButton1() { CString str; char sz[8192]; file://memory will add 8K for(int i=0;i<8192;i++){ sz[i] = 'a'; } str = sz; file://memory will add 8K str.ReleaseBuffer(); } But when the function completed,memory can't free 16K.It only free 8K.Why the memory CString used can't be free? How to free? Thanks! "Z.Smith" <zhchyg@163.com> wrote in message news:OTXcEkFqFHA.208@TK2MSFTNGP10.phx.gb...

Memory Config
I'm having a real head ache with my main Exchange server. Configuration: Windows 2003 Ent Server (upgraded from 2000 std) Exchange Server 2003 (upgraded from 2000 std) The server has 2GB RAM. In my boot.ini I have: multi(0)disk(0)rdisk(0)partition(2)\WINNT="Windows Server 2003, Enterprise" /fastdetect /3GB /USERVA=3030 I have set the HeapDeCommitFreeBlockThreshold to: 0x00040000 My SystemPages is set to 0x00031000. (I've tried 30000 as well) Yet at boot I still get the 9665 error saying that my memory setting are not optimal for Exchange. And every two or th...

How to release memory used by MSHTML? Please help.
Every time I call QueryInterface, memory increase by 4KB. I hope the release will release the memory but it doesn't. If I put the following code into an infinitive loop, then it will run out of virtual memory. Please help how to release memory used by MSHTML functions. Thanks. void ChtmlView::OnDocumentComplete(LPCTSTR lpszURL) { IDispatch* pDocDisp = this->GetHtmlDocument(); if (pDocDisp != NULL) { HRESULT hr; IHTMLDocument2* pDoc; hr = pDocDisp->QueryInterface(IID_IHTMLDocument2, (void**)&pDoc); if (hr == S_OK) { pDoc->Release(); } pDocDisp->...

MFC says I have a memory leak...
I see the following in my output tab when I exit my MFC dialog based app: strcore.cpp(118) : {122} normal block at 0x02E781F0, 26 bytes long. Data: < 10.1> 01 00 00 00 09 00 00 00 09 00 00 00 31 30 2E 31 strcore.cpp(118) : {121} normal block at 0x02E78190, 26 bytes long. Data: < 10.1> 01 00 00 00 09 00 00 00 09 00 00 00 31 30 2E 31 Background: --- I have a thread (let's call it FtpThread) which is passed in an IP address contained in a u_long taken directly from sockaddr_in.sin_addr.S_un.S_addr which comes from recvfrom() in another thread (let's ca...

Virtual PC attributes for Mac running intel.
I have subscribed to a business newspaper that only produces graphs using activeX. With my macbook running intel I cannot view the graphs or take advantage of other features. Is there a product or a feature that will allow me to emulate a PC? I am using Office 2004 Student Teacher edition. Thanks in advance for your help. Dan In article <1181949056.659823.159420@o61g2000hsh.googlegroups.com>, "Dan@roseconsulting.biz" <Dan@roseconsulting.biz> wrote: > I have subscribed to a business newspaper that only produces graphs > using activeX. With my macbook runnin...

Memory stick
How do I disable write-protect on a removable disk? I've got two of these little thumb drives (if that's what you mean). One actually has a physical toggle on it that I use to lock/unlock the drive. And the second has some software that came with it to lock the drive. (Actually, the first one may have its own software, too.) thomasville wrote: > > How do I disable write-protect on a removable disk? -- Dave Peterson On Sat, 20 Nov 2004 11:51:04 -0800, "thomasville" <thomasville@discussions.microsoft.com> uttered: >How do I disable write-protect on a r...

Inadequate Memory Problem
I was trying to cut and paste a few images into Word Perfect, and experienced a failure saying 'inadequate memory'. I have 2GB DDR in four 512MB segments. I wonder what the problem might be? Thanks Duke jw@eldorado.com wrote: > I was trying to cut and paste a few images into Word Perfect, and > experienced a failure saying 'inadequate memory'. I have 2GB DDR > in four 512MB segments. I wonder what the problem might be? The exact wording was "inadequate memory"? Yes - the exact wording is important here. The title of the window that ...

Considering Virtualization
Hello Newgroup, We need to upgrade our 4 year old SBS box. I am totally new to virtualization and wondering if these circumstances warrant making the jump. We've got approx 30 users, and approx 75 mailboxes. We don't run anything extra. We're nonprofit, which means that MS licensing costs are negligable, but it also means that our IT budget is tiny - I'm here approx 10 hours a week for general support, higher level needs get outsourced. I had been considering the following path: > Get a new server, without a tape drive (old server's tape drive recen...

Minimizing the memory requirements
Hello All This messag is a off - technology query. I have a strange problem where in I receive a large strings of 10KB each. Right now there can b 8 such strings and in future the number may rise. The string is containing of 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, ., @ This way each string contains 10,000 bytes representing above characters in "RANDOM" sequence. Is there anyway that I can reduce the number of bytes required? One way is replace . with 10 and @ with 11 and then consider only last 4 bits of every byte. This way I can reduce the memory requirement by half. But is there any...

Question about Virtual SMTP Server Logging.
I would like to enable logging on my SMTPVS. I am wondering how long these logs are kept and what performance issues this may cause..if any? Thanks Tony MCSE The performance issue would likely be negligible. However, the SMTP logs will be kept indefinitely - you'll want to delete them once in a while. -Josh "Tony" wrote: > I would like to enable logging on my SMTPVS. I am wondering how long these > logs are kept and what performance issues this may cause..if any? > > Thanks > Tony > MCSE ...

virtual listview
how can i create a virtual listview to use with large data from database do i need to create 1st the listclòtrl in the dialog or i have to create evry thing in other mode http://msdn.microsoft.com/library/en-us/vcsample98/html/vcsmpvlistvw.asp?frame=true -- Regards Sheng Jiang Microsoft Most Valuable Professional in Visual C++ http://www.jiangsheng.net http://blog.joycode.com/jiangsheng/ "mido1971" <mido1971@discussions.microsoft.com> д���ʼ� news:C708C64B-D503-4562-B0CF-1A162B5230EC@microsoft.com... > how can i create a virtual listview to use with large data f...

VIRTUALIZATION
Has anybody implement a virtualization with RMS? -- Akim Nasir TRCEPOS ...

Why is powershell eating memory and not releasing it ?
Powershell 2.0 on XP sp3. I am NOT running a script, but i ran the commands interactively which export some items to a external file. I repeat each time and memory is not released when each time the commands run in less than one minute. How can i look "purge memory" on the fly ? Eg get-qadcomputer -searchroot 'OU=abc,DC=mc,DC=com' -sizelimit -includedproperties use rAccountControl | where {$_.useraccountcontrol -ne 4098} | foreach {$_.name} | out-file -filepath c:\results.txt -append I changed the OU each time and run the commands interactively , but...

DMF 3.0 not working under Virtual PC or Virtual Server ?
Hi everyone, does somebody know if the DMF 3.0 won't work under Virtual PC or Virtual Server? I tried to import flatfiles (txt or csv) into MSCRM via DMF and it doesn't work at all. The CDF Staging DB has all the data from the flatfiles but the Migration doesn't work. No errors in logfile.. Maybe it's because of VPC? Any ideas? Greets from Germany, Romantischik I haven't tried it so I'm not sure, but it sounds unlikely to me that it wouldn't work on a VPC or Virtual Server. I know there are some language issues with DMF, but I'm no expert on that so ...

Memory Leak in PostThreadMessage
This problem was found on WinCE.net. I spend a whole afternoon on debugging and found ��������������WinCE.net�Ϸ����ˣ�������һ�����磬���� ����Ƕ��ʽ���е����⡣�����������ģ� ���������д�����һ���̣߳�Ȼ�����һ����ʱ������ʱ(200ms) ���̷߳�����Ϣ����Ϣ��LPARAM��һ���ڶ��Ϸ�����ڴ�ĵ�ַ�� �̵߳�PreTranslate��������Ӧ��Ϣ������ɾ��������ڴ档 ���ǣ���Ӧ��Ϣ��ʱ���������200ms,����1000ms���ͻ���� �ڴ�й©�����˵������������ģ� �����̣� CString* pStr = new CString; pStr->Format(_T("2222")); PostThreadMessage(m_iThreadID,WM_USER+1000,0,(LPARAM)pStr); �̵߳���Ϣ��Ӧ�� if(pMsg->message == WM_USER+1000) { CString* pStr = (CS...

Anyone doing SBS 2008 virtualization with Xenserver?
Hi folks, Getting ready to do SBS 2003 -> SBS 2008 swing migration where SBS 2008 will be virtualized. A friend who is currently using Xenserver for virtualization tells me it is really simple to use, and he likes it. He is doing Server 2008, not SBS. When I go to the Xenserver site, it doesn't list SBS 2008 as a supported OS, is anyone using it for SBS 2008, and did you have any trouble setting it up? Should I not consider it? I'm OK with using Hyper-V, but my friend really likes Xenserver, so I'm looking for advice. Thanks, Mike I would want both ...

CRM virtual
somwone know if there is virtual CRM in french? There isn't a localized Virtual PC demonstration. -- Michael Web: http://www.stunnware.com/crm2 Feed: http://www.stunnware.com/crm2/atom.aspx ---------------------------------------------------------- "aidah" <aidah@discussions.microsoft.com> schrieb im Newsbeitrag news:D8796BFD-A8F6-49CB-AE9B-D883BF82C446@microsoft.com... > somwone know if there is virtual CRM in french? ...

lack of memory
Where do I go to fix the lack of memory. Can you explain it better? If you are getting that error in WinMail, its likely due to a corrupt database. Try repairing it (www.oehelp.com/WMUtil/) and also check point 3 here: www.oehelp.com/OETips.aspx#3 steve "LIP" <LIP@discussions.microsoft.com> wrote in message news:CE6B91C4-7ADD-4CBF-92FB-0FF9E3AC2AB9@microsoft.com... > Where do I go to fix the lack of memory. Can you explain it better? Perhaps some of the current drugs on the market or some brain exercises would help. -- -- "LIP" &l...

Publisher virtually stops my system
I seem to have a problem with Publisher. For the last few weeks if i try to work with a document my system will get very slow. it starts out fine, but then when i create a text box of image box the system will seem to freeze for a long time. this problem first started in Publisher, now it is beginning to do the same thing in Outlook, when i open an email (no images associated), and sometimes Word. it is as if all the system resources were being used, but when i check that it shows to be ok. I have run detect and repair on all these apps, and have all the latest updates and servic...

Virtual pc not supported ( Could not post this under Virtual PC Product
Operating System: Mac OS X 10.3 (Panther) Processor: Power PC When trying to open Virtual PC 6.1, The message Virtual PC does not support the CPU in this MAC. CPU Power PC G5 (3.0) please can anyone tell me if i can use this programme on my computer !!!! ???? In article <ee97f0d.-1@webcrossing.caR9absDaxw>, ArtHoar@officeformac.com wrote: > Operating System: Mac OS X 10.3 (Panther) > Processor: Power PC > > When trying to open Virtual PC 6.1, > > The message Virtual PC does not support the CPU in this MAC. > > CPU Power PC G5 (3.0) > > please can ...