Skip to Content
0
Former Member
Jul 14, 2008 at 12:09 AM

Sizing SQL Memory

280 Views

We have a landscape with 6 systems.

We are planning on a three tier architecture.

An "Active-Active" cluster will be used to host the databases on SQL2005 64bit/Ent. Three systems will reside on each node under business as usual conditions.

Does increasing the amount of memory on the database servers have a significant impact on performance? Or if sized correctly, would little gain be achieved from increasing the amount of memory beyond the sizing results?

Regards,

Andrew