Hi guys,
I am considering upgrading memory in my MS SQL server cluster from 8GB
to 16GB on each cluster node. I was wondering, whether you could suggest
how to measure the overall performance gain after the upgrade.
Basically, I would like to estimate performance/cost ratio in 8GB, 16GB
and possibly 24GB configuration. The cluster consists of 5 Windows 2003
enterprise servers R2 with SQL Server 2005 (the 64 bit edition) on each.
Thanks
I am considering upgrading memory in my MS SQL server cluster from 8GB
to 16GB on each cluster node. I was wondering, whether you could suggest
how to measure the overall performance gain after the upgrade.
Basically, I would like to estimate performance/cost ratio in 8GB, 16GB
and possibly 24GB configuration. The cluster consists of 5 Windows 2003
enterprise servers R2 with SQL Server 2005 (the 64 bit edition) on each.
Thanks