Results 1 to 4 of 4

Thread: memory setting for sql 2005 on win 2003

  1. 08-30-2006, 10:01 AM #1
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261

    memory setting for sql 2005 on win 2003

    I have been given a box setup by a consultant. It is a new Dell with 16 gig of memory running on win2003 server with sql 2005 Enterprise Edition. With 2 users it is running slow. I checked the memory setting and notice the awe setting is not checked? Should this be checked. Task manager perfmon shows only 3 gig being utilized
    Reply With Quote Reply With Quote
  2. 08-30-2006, 01:16 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Is it 32-bit machine? Dedicated sql server? If so for both, you should add /pae in boot.ini file and enable awe.
    Reply With Quote Reply With Quote
  3. 08-30-2006, 03:08 PM #3
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261
    Yes to both, so you still use that setting for windows 2003
    Reply With Quote Reply With Quote
  4. 08-30-2006, 03:54 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Same as on sql2k, only difference is sql2k5 can handle awe dynamicly. That means you don't have to set fixed amount of memory for sql.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules