February 6, 2013 at 10:16 am
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) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
February 6, 2013 at 11:07 am
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
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply