memory Issue

  • 2 cpu -- 2 cores ---so 4

    no cluster

    windows 2003 64 bit sp1 standard edition

    The reading I did last night said awe does not work on 64 bit? same as locking since it is standard and not enterprise

    --its a little messy---

    Ad Hoc Distributed Queries0111

    affinity I/O mask-2147483648214748364700

    affinity mask-2147483648214748364700

    affinity64 I/O mask-2147483648214748364700

    affinity64 mask-2147483648214748364700

    Agent XPs0111

    allow updates0100

    awe enabled0100

    blocked process threshold08640000

    c2 audit mode0100

    clr enabled0111

    cost threshold for parallelism03276755

    cross db ownership chaining0100

    cursor threshold-12147483647-1-1

    Database Mail XPs0111

    default full-text language0214748364710331033

    default language0999900

    default trace enabled0111

    disallow results from triggers0100

    fill factor (%)010000

    ft crawl bandwidth (max)032767100100

    ft crawl bandwidth (min)03276700

    ft notify bandwidth (max)032767100100

    ft notify bandwidth (min)03276700

    index create memory (KB)704214748364700

    in-doubt xact resolution0200

    lightweight pooling0100

    locks5000214748364700

    max degree of parallelism06400

    max full-text crawl range025644

    max server memory (MB)16214748364750005000

    max text repl size (B)021474836476553665536

    max worker threads1283276700

    media retention036500

    min memory per query (KB)512214748364710241024

    min server memory (MB)0214748364700

    nested triggers0111

    network packet size (B)5123276740964096

    Ole Automation Procedures0111

    open objects0214748364700

    PH timeout (s)136006060

    precompute rank0100

    priority boost0111

    query governor cost limit0214748364700

    query wait (s)-12147483647-1-1

    recovery interval (min)03276700

    remote access0111

    remote admin connections0100

    remote login timeout (s)021474836472020

    remote proc trans0100

    remote query timeout (s)02147483647600600

    Replication XPs0100

    scan for startup procs0111

    server trigger recursion0111

    set working set size0100

    show advanced options0111

    SMO and DMO XPs0111

    SQL Mail XPs0111

    transform noise words0100

    two digit year cutoff1753999920492049

    user connections03276700

    user options03276700

    Web Assistant Procedures0100

    xp_cmdshell0100

  • this URL might help you

    http://support.microsoft.com/kb/889654/

    I would advise applying sp2 at a minimum to the Standard edition.

  • good catch....thanks.

    I took this server over a few days ago, had not had a chance to check everything as of yes

  • The reading I did last night said awe does not work on 64 bit?

    That's changed recently. There's a lot of info available now that AWE has an impact on 64-bit. Whether its positive or negative will be for you to judge by testing.

    same as locking since it is standard and not enterprise

    Obviously doesn't apply, but I do agree with upgrading to SP2.

Viewing 4 posts - 16 through 18 (of 18 total)

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