SQL Server Performance

Opinions on speed,possible hardware changes

Discussion in 'SQL Server Clustering' started by jbrochu, Mar 11, 2004.

  1. jbrochu New Member

    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
    4GB DDR-SYNCHRONOUS Memory
    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?
  2. Twan New Member

    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
    Twan
  3. jbrochu New Member

    Hey Twan, thanks for the feedback.
  4. satya Moderator

    Also think about archiving the table data so that keeping down the size of database will also contribute performance addition.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page