Post reply

Problem with sql server 2005 std 32 bit and RAM usage

  • March 18, 2011 at 8:53 am

    #234328

    Hi All,

    i have a sql server 2005 standard (32 bit) installed on windows server 2003 standard (64 bit ), the RAM was 6 GB but now i upgraded it to 14 GB. The issue is SQL Server is not using more than 3.7GB ram.

    Is it possible to enable AWE in my sql server ?what is the memory access limit of sql server 2005 std edition(32 bit)? Plz suggests a possible solution to overcome the memory usage limit of sql server standard 2005 32 bit system in this situation??

    I think the problem is we installed sql server 2005 std (32 bit) ON windows 2003 std (64 bit) instead of sql server 2005 std (64 bit)?. we chose sql server 2005 std 32 bit bcos our System Adimn was against of sql server 2005 std 64 bit(i dont know the reason behind that but heard something like it was unstable at that time.is it true?

    )....

    Thanks In advance,

    Raj.

  • March 18, 2011 at 9:25 am

    #1300595

    hi there....

    there is no issue with 64 bit...your system admin is wrong!

    you say you are using 3.7 gig, did you run dbcc memory status for this ( check here http://support.microsoft.com/kb/907877)

    1.what are using as a measurement?

    2. how big is your DB

    3. how long have you been running since the upgrade/install....sql will not just start out by grabbing all the memory..it is a slow ramp up

    4. you can set AWE as well as max/min memory setting if you have done so already.

  • March 22, 2011 at 4:04 am

    #1301761

    Hi,

    Size of DB is 70GB,AWE is not enabled...

    Query response is very slow...can anyone suggest a solution.

    --

    Raj

  • March 22, 2011 at 4:10 am

    #1301763

    Ah 70 GB is it that much!!..

    Tech Blog

  • March 22, 2011 at 4:24 am

    #1301768

    We could suggest 100 things, but they could all be for nothing on your system. You need to give us a LOT more detail about what is not performing, how you determined it, structures, execution plans, sample data, etc, etc.

    AWE is a start, but by itself it would entirely explain a slow performing system.

  • March 22, 2011 at 6:18 am

    #1301823

    Hi

    Please provide more information about your server as well as sql server memory configuration

    1 )What is memory configuration in boot.ini file (swtich used related to memory usage like /PAE /3gb /userva )

    2)What is memory configuration done at SQL Server AWE, min and max memory

    3) is your system recongized 14 GB of memory

    4) did u observe whether your system utilized more than 3.7 GB of memory before upgrade(6 GB)?

    Regards

    KK

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply