25. července 2012 7:23
I have Microsoft Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2).
Dynamics AX 2009 installed.
About 200G of Database.
What are the prerequisties for database of 200G (approximatly - per each extra 1G bytes of disk).
Now there is total : 8 CPUs, and 20G of memory. 3GHrtz.
When I did : exec spl_configure (in sql), I see that the max server memory (MB) about 12G (config value).
On task manager, I see the mostly CPU consumings are :
SQL server (12G).
Dynamics AX client - 1G.
Dynamics AX AOS - 300M.
Total remaining is about 1.5G (I persume, the sql server takes maximum CPU consuming within a day).
There are some problems on that machine due memory consumption, so I mast restart the machine every few days ...
What can you recommand me doing, please.
25. července 2012 20:26Přispěvatel
Have you found what the root cause is? If not, I would suggest that the root cause be found and the actual fix applied.
From your post, the numbers don't quite make sense:
12 GB - SQL Server
1 GB - DAX client
.3 GB - DAX AOS
Total: 13.3 of 20 GB, plus OS.
Is there anything in the event logs, sql server errorlog, etc?
Sean Gallardy, MCC | Blog
5. srpna 2012 6:18
What sort of memory pressure are you experiencing?
1)Are you monitoing the Buffere Cache Hit Ratio?
2)Are query reponse times getting increasingly slower ?
3)Is there any application memory leak in VAS - although less likely on 64bit?
Jack Vamvas sqlserver-dba.com