SQL Server Performance

Lifejacket needed ASAP

Discussion in 'Performance Tuning for Hardware Configurations' started by nak, Mar 26, 2005.

  1. nak New Member

    Greetings all. I have lurked a little here, but this is my first post.

    While I hesitate to use the word 'administer', I am responsible for a SQL database this is currently 62 GB and growing by about 1 GB per month. There are about 2.5 million records added each month, with about that many more records being modified. Up to about 45 GB, the performance was OK (Quad 800MH/2MB Xeons - 2GB ram ). As it has grown above 45 GB, I have started getting performance complaints. I had a disk bottleneck, but that was relieved a couple of months ago by upgrading storage to a fourteen 36Gx15K Ultra 320 in a 7 stripe 1+0.

    Performance still sucks, so I am finally giving in to the complaints from the users... EVERYTHING gets upgraded next week.

    I have new Quad server with 2.5GHz/2MB XEON processors and 12GB Ram being delivered next week.

    I am moving from 2000 server to 2003 Enterprise Edition (first deployment in our company) and upgrading from SQL7 standard to SQL 2000 Enterprise (another first here).

    Right how I am feeling a little intimidated with the Enterprise editions of the OS and SQL. I have spent the last couple of days searching and reading like crazy to try to learn enough just to figure out what I don't know. What one or two books would be recommended for the biggest return on my timeinvestment? Preferably something I can find at a book store, since I plan to start installing by the end of next week.

    Thanks
  2. derrickleggett New Member

    Well, the SQL Server 2000 Performance Tuning Technical Reference by Microsoft Press is good for performance tuning. The SQL Server 2000 Bible will probably give you the information you are looking for more specifically though. It's also a good reference to have around. Make sure you don't forget to use the /3GB and /PAE switches for the boot.ini file in windows. Also, don't forget to set "awe enabled" to 1 in SQL Server. Let us know how you end up setting this up. We might have some additional recommendations for you.

    One other thing, after you get this running be sure to run UPDATE STATISTICS the first couple days every few hours. The performance will be significantly different on this box compared to the old box.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. satya Moderator

  4. joechang New Member

    brute force hardware upgrades alone may or may not solve performance issues. either learn how to use the Microsoft PSSDiag kit, which collects perfmon and profiler data,
    or get Coefficient from Imceda which does the same for profiler,
    or consider SQL Tune from Quest

    or if this is really important, get an expert to do a full week assessment

Share This Page