SQL Server tweaking - Tell me how to make it scream.

Posted on 2007-10-19
Last Modified: 2008-01-09
I am not an SQL guru. I need specific instructions to maximize performance on an SQL 2005 installation. I have setup SQL 2000 before and setup the hardware for 2005 in similar fashion. I have a Dell PE2900 Dual Quad Core, 16 GB RAM, Windows Enterprise x64, 3 RAID containers (RAID 1 - Boot, RAID 5 - SQL Database, RAID 1 - TX Logs). I have not moved the TX logs yet because I can't find any documents online that explain it well enough for me to do it. I need someone to give me a link to or provide concise instructions on how move the TX logs and tweak this server to scream. To show my appreciation, I am loosening the purse stings and giving full credit for this question to the person that provides the answer I need.
Question by:rodneythompson
    1 Comment
    LVL 8

    Accepted Solution

    hi rodney,

    please see this page on for performance tuning,

    they have been one of the best sites on sql server performance tuning tips and articles around.

    good luck

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now