April 16, 2012 at 10:31 pm
We utilize an 8 core Dell R710 (see specs below) as our primary dedicated DB server. We run Windows Server 2008 Standard and SQL Server 2008 Standard. We have only one, mission-critical database that runs our software platform and this database is really our overall application bottleneck.
We have around $45k budgeted overall for a major upgrade for our DB server to ensure that we continue to stay ahead of our increasing server load, as the usage of our web application increases.
Questions: Can anyone help to roughly quantify the potential performance gains on general query execution in going from an 8 core Dell R710 to a 32 core R910?
Our database is around 60GB. Does is make sense to install more than 32GB of RAM on the new server? If so, then we would need to also upgrade to Windows Server 64x 2008 ENTERPRISE (we're currently on Standard)?
Is there any benefit from a query execution standpoint and peak load performance perspective to upgrading to SQL Server 2008 ENTERPRISE (we run STANDARD currently)?
------
CURRENT SERVER: Dell PowerEdge R710 with 2x Quad Core 3.33ghz, 32GB of RAM, 6x146GB 15k Hard Drives, 2 PCI Fiber Cards Connected to SSD SAN, 4xGigabit NIC, DRAC, Microsoft Windows Server 2008 Std. 64bit
Thanks,
B.H.
April 17, 2012 at 1:50 am
What is your current bottleneck? Cpu, I/O ...?
April 17, 2012 at 2:05 am
Find your actual weak point before investing any $, I would reccomend you look at these articals by Gail Shaw and Brent Ozar (they are both a good reads anyway) to get some pointers on how to asses your situation.
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply