Opinions on speed,possible hardware changes | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Opinions on speed,possible hardware changes

I have an Active/Passive cluster server environment, purchased from Dell, about $70000. I will try and give you detailed hardware: Hardware—
Dual Xeon 2.8Ghz Processors
PERC QC RAID Controller running RAID 1, for local disks
PERC QC attached to the Dell Powervault Storage System, RAID 10 Software—
Windows 2000 Advanced Server
Microsoft SQL Server 2000 – 8.00.760 Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Microsoft Cluster Service Database details—
24GB in size ( mdf )
2400 sql transactions per minute, peak. Reported by NetIQ’s Monitoring program. Fairly busy database I guess? Size has doubled in last month and a half. The company is
a records storage firm, housing roughly 9.5 million records. What I am looking for is suggestions for increasing performance. Are we using the right hardware? Is this a fairly busy/large database in comparison to large companies? The system can hold up to 32GB of RAM and 4 CPU’s, would increasing either of those help? The database sits on a private LAN behind a SonicWall connecting to a T-1. Port forwarding is in place for 1433, the server gets numerous hits from a website querying the data and entering new data. This website is offsite. There is also onsite users on the same private LAN hitting it pretty hard with a customized software application. Thoughts?
Hi ya, additional CPUs will help if the system is processor bound at times
additional RAM is not likely to help if this is a dedicated SQL cluster.
raid10 could possibly be broken up into multiple raid sets with logs on one, data on another and temp on local or on a third set. each with their own controller. BUT query tuning tends to be a better investment for money spent. Often there are particular queries that do by far the most ‘damage’ to the performance of the system. Hunting these out using Profiler and correcting them (or indexing for them) usually gives large performance gains Cheers
Hey Twan, thanks for the feedback.
Also think about archiving the table data so that keeping down the size of database will also contribute performance addition. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.