Post reply

Database performance issue

  • February 6, 2013 at 10:16 am

    #1585054

    Is the "MS Dynamics Navision ERP" application running on the same box as SQL Server in prod?

    If so, I'd lower the fixed memory for SQL considerably.

    Even if not, I'd still lower it to at least 96G (98304MB); at 128G, Windows itself needs some RAM to manage the other RAM.

    The only non-memoty things that would normally ever slow it that much is:

    1) I/O issues

    2) tempdb issues.

    So I suggest verifying those first before looking at other things.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

  • February 6, 2013 at 11:07 am

    #1585065

    Please note: 3 year old thread

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 16 through 16 (of 16 total)

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