Recently we have got problems with performance in SQL Server 2008 Enterprise.
One idea to solve it is to scale up, i.e. improve hardware of the server.
SQL Server 2008 has 2 instances that are running under 64-bit Windows Server 2008 Enterprise.
The configuration of the server is the following:
- CPU: Quad-code AMD Opteron™ Processor 2356, 2.51 GHz (2 Processors). CPU is normally 20-35% in use if not under stress, and 80-90% if under stress.
- RAM: 30 G, 24,6 G for both instances of SQL Server.
How do you think the configuration of the server is weak enough to be improved?
I wanted to have a sensation which configurations are in use by other companies, and if you know yours you might also post it. Thank you.
Well even thought your processors aren't massively old (2007/2008 vintage) I do think you'd see some very clear processing efficiency gains as well as significant memory latency benefits if you moved to a newer system. You don't mention your disk config but there could be improvements to be had their too. Ideally I'd look for a two-socket box with dual six-core or better 56xx-series xeons, 6 x 8GB memory and whatever volume you need of 6Gbps SAS 15/10krpm disks and/or some pro-quality SSDs. There's lots of manufacturers selling that kind of spec server (IBM/HP/Dell etc.) and other than the disk shouldn't be too expensive either, it's the spec of the boxes we're buying right now for MSSQL and Oracle and we're happy.