topic Re: BL870c in BladeSystem - General

BL870c

subashbl870 — Tue, 19 Jan 2010 12:42:46 GMT

We have Blade server 870c it has 16GB RAM. it's working fine . i have doubt about memory usage .
our Database SQL server 2005. our database working time ram usage is very very big like 15.7GB renaming 300mb is only free . is it normal or can i upgrade memory

Re: BL870c

Michal Kapalka (mikap) — Tue, 19 Jan 2010 13:13:15 GMT

hi,

database server will always use the maximum resources that are available or set for him,
most of DB servers using also CPU, so before you start to upgrade memory, you should monitor, CPU / mem / IO (disk) operation to identify, what is the major reason why your system is slowing down or have some bootleneck, but in my opinion if you don't extremly paging to the disk, the amount of the memory could be stay.

mikap

Re: BL870c

subashbl870 — Tue, 19 Jan 2010 14:40:31 GMT

thanks for replay me .
our Cup usage very low like 30% only but memory usage 98% .i had verified Task manager
physical memory usage 98% . process
SQL server.exe 98% . what can i do . and also now we are doing DR replication both side can i updrade anythings .

Re: BL870c

Michal Kapalka (mikap) — Tue, 19 Jan 2010 14:49:53 GMT

ok,

but you should consider, if your system is memmory deend or CPU power because its depend on the spped of memmory and memory module organization.

check this as reference :

http://h18000.www1.hp.com/products/servers/options/tool/hp_memtool.html

but if you like to be sure that if you upgrade the memory the performance of the memory will not go down and of cource CPU poer, them you should contact some HP technical presales, because its different to have 4x8 GB module instead of 12x2GB or 6x4GB ....

mikap

Re: BL870c

Igor Karasik — Tue, 19 Jan 2010 19:08:59 GMT

Hi,
As Mikap said SQL use all available memory, therefore on SQL servers I usually limit SQL to 80 % of available RAM (i.e. if we have 16 GB RAM I limit SQL to 12.8 GB)
http://support.microsoft.com/kb/321363

>>is it normal or can i upgrade memory
If you don't see performance problem - don't upgrade RAM. Even if you will upgrade to 32 GB - SQL will use all 32 GB if you not define "max server memory" option

Re: BL870c

rick jones — Wed, 20 Jan 2010 00:25:11 GMT

So long as the low CPU utilization percentage is not a symptom of paging/swapping, or waiting for database I/O that might otherwise have been cached, you should be OK.