Need to estimate how much memory need for server.

Question

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.

Thanks :)

Answer 1

Hello,

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

---

Sean Gallardy, MCC | Blog

Answer 2

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