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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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