SQL Server Performance

Where to start performance tuning ?

Discussion in 'Performance Tuning for DBAs' started by malik_abid, Jun 22, 2004.

  1. malik_abid New Member

    I am told to create a document for Performance tuning for our Database Servers.
    We have plenty of databases and thousands of tables.

    My question is where to start ?

    what should be the points we need to start work on.

    Can anybody give a simple list or suggestion?

    Thanks
    Malik
    malik_abid, Jun 22, 2004
    #2

  2. Luis Martin Moderator

    You can start using Performance Monitor to see hardware and software and Profiler to find queries with long execution time.

    Also read some articles (in our forum) about Monitor and Profiler.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

    Luis Martin, Jun 22, 2004
    #2

  3. satya Moderator

    http://www.sql-server-performance.com/sql_server_performance_audit.asp is the required article for yoru reference, which will give you base start to measure the performance.

    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.
    satya, Jun 23, 2004
    #2

  4. derrickleggett New Member

    You should also look at:

    1. Best Practices Analyzer. It can be downloaded on the Microsoft SQL Server site for free.
    2. On Profiler, I like to also look at anything that has over 5000 reads. This will give you a good idea on missing indexes, badly written queries, and design issues in your database. You can level it down to the top 50 or so and start tuning away.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
    derrickleggett, Jun 23, 2004
    #2

Share This Page