Thanks. Cheers, Tony
-----Original Message----- From: Shea, Linchi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 2:30 PM To: NT 2000 Discussions Subject: RE: 2000 Standard SQL RAM limits No, SQL 2000 standard edition can only see 2GB regardless of what OS it is on. Linchi > -----Original Message----- > From: Woods, Tony MHR:EX [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 07, 2002 12:54 PM > To: NT 2000 Discussions > Subject: RE: 2000 Standard SQL RAM limits > > > Doh! I need something to drink. I totally forgot about that > simple little > fact of Standard and Advanced server. So let's re-word this. > > With 2000 SQL Standard Edition running in Windows 2000 > Advanced server, is > there a way for SQL to see the 5GB or RAM? > > Cheers, > Tony > > -----Original Message----- > From: Morgan, Joshua [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 07, 2002 9:44 AM > To: NT 2000 Discussions > Subject: RE: 2000 Standard SQL RAM limits > > > From what I can tell from Microsoft.... If you want to use > more than 4 > gigs of RAM then you must use atleast 2000 Advanced server > > This section is from > http://www.microsoft.com/windows2000/server/howtobuy/choosing/ > > Windows 2000 Server Best platform for file and print, Web > server, and group > mail. > Scales from 1 to 4 processors and up to 4 gigabytes. > Reliable and available-components tested through Microsoft's Windows > Hardware Compatibility Labs (WHCL). > > Windows 2000 Advanced Server Best platform for > line-of-business and .com > backend usage. Provides enhanced performance and scalability > through SMP and > extended memory support. > Scales from 1 to 8 processors and up to 8 gigabytes. > Enhanced reliability and availability-provides two-node > clustering; 32-node > network load balancing; components tested through WHCL. > > Windows 2000 Datacenter Server Best platform for large-scale > line-of-business and enterprise .com backend usage. Supports server > consolidation and enhanced scalability. Scales from 1 to 32 processors > and up to 64 gigabytes. Maximum reliability and availability-provides > four-node clustering; 32-node > network load balancing; systems tested through the Datacenter HCL. > > > > > > > > Joshua Morgan > PH: (864) 250-1350 Ext 133 > [EMAIL PROTECTED] > http://www.profit-lab.com > http://ncontrol.info > > > -----Original Message----- > From: Morgan, Joshua [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 07, 2002 12:42 PM > To: NT 2000 Discussions > Subject: RE: 2000 Standard SQL RAM limits > > > What are the memory limitations on 2000 standard server? > > > > > > > Joshua Morgan > PH: (864) 250-1350 Ext 133 > [EMAIL PROTECTED] > http://www.profit-lab.com > http://ncontrol.info > > > -----Original Message----- > From: Woods, Tony MHR:EX [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 07, 2002 12:31 PM > To: NT 2000 Discussions > Subject: OT: 2000 Standard SQL RAM limits > > > Hi all, > > Just a quick one. SQL 2000 Standard edition can only address > 4GB or RAM. Is > there a way around this besides getting Enterprise? If I get > Enterprise, > must it run on 2000 Advance Server? > > Cheers, > Tony > > Tony Woods MCSE, CNA > Ministry of Attorney General > 910 Government Street > Victoria, BC, Canada, Earth > http://www.ag.gov.bc.ca <http://www.ag.gov.bc.ca> > > > ------ > You are subscribed as [EMAIL PROTECTED] > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe send a blank email to %%email.unsub%% > > ------ > You are subscribed as [EMAIL PROTECTED] > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe send a blank email to %%email.unsub%% > > ------ > You are subscribed as [EMAIL PROTECTED] > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe send a blank email to %%email.unsub%% > > ------ > You are subscribed as [EMAIL PROTECTED] > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe send a blank email to %%email.unsub%% > ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
