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 PROTECTED]
