No problem. Just did a quick search - look at Q274750 as a good starting place.
------------------------------------------------------ Roger D. Seielstad - MCSE Sr. Systems Administrator Inovis - Formerly Harbinger and Extricity Atlanta, GA > -----Original Message----- > From: Allen Lin [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 12:27 PM > To: NT 2000 Discussions > Subject: RE: Optimizing the page file on a 4GB Server System > > > Thanks for the tips. > > We are running Windows 2000 Advanced Server and SQL Server 2000 SP2. > > Thanks > Allen > > > -----Original Message----- > From: Roger Seielstad [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 9:02 AM > To: NT 2000 Discussions > Subject: RE: Optimizing the page file on a 4GB Server System > > > Which version of SQL Server and which version of Win2k > (Server or Advanced > Server)? > > The tuning switches you're interested in are either /3GT or > /PAE. IIRC, /PAE > is one you're going to want to look at, IF you're running AS, > rather than > just Server. In either case - search Technet for the info on > it. I haven't > done it enough to know off the top of my head how exactly they work. > > As far as page file optimization, spread it out across > multiple spindles, > preferably either non-RAID sets, or only onto RAID1 / RAID10 > partitions. > Keep them away from RAID5, as the parity calculations during > swaps drag the > swap time out quite a bit. > > > > > Roger > ------------------------------------------------------ > Roger D. Seielstad - MCSE > Sr. Systems Administrator > Inovis - Formerly Harbinger and Extricity > Atlanta, GA > > > > -----Original Message----- > > From: Allen Lin [mailto:[EMAIL PROTECTED]] > > Sent: Friday, October 04, 2002 2:52 PM > > To: NT 2000 Discussions > > Subject: Optimizing the page file on a 4GB Server System > > > > > > Hi, > > > > We are looking to upgrade our SQL Server from 1GB to 4GB to > > increase the > > performance. I've been informed that there are ways to > > optimize the page > > file since a 4GB swap file would be too big. Can anyone > > direct me to the > > location where I can find this information? Also, there is a > > setting to turn > > on the 4GB ram tuning switch in Windows 2000. Anyone have any > > knowledge > > about this? > > > > I have always read the discussions on this list and found > > postings that had > > the same problems as I did. It has been a big help. > > > > Thank you > > Allen > > -------------------- > > We've Moved! > > Please note our new address: > > 801 Sentous Street > > City of Industry, CA 91748 > > > > ------ > > 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%% > -------------------- > We've Moved! > Please note our new address: > 801 Sentous Street > City of Industry, CA 91748 > > ------ > 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]
