Results 1 to 4 of 4

Thread: Help!!!!!

  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: Help!!!!!

    Hi,

    I'm new to SQL Server. One of our databases is very slow. Need to look into it. Any ideas?


    Thanks!!

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Run some of your frequently used queries though the query analyser and look at the execution plan. This will give you a break down of how much time is being used in each step of the query and should give an indication of where you should start looking to improve performance.

  3. #3
    Join Date
    Sep 2003
    Posts
    39
    Start with the profiler! Check for

    - long running queries
    - locks and the duration thereof
    - scans

    Then you can start using the Query Analyzer. Add (nolock) where appropriate, index your tables and if you have ANY in-line SQL with variable where statements or more than one table then you should immediately move those to stored procedures.

  4. #4
    Join Date
    Oct 2003
    Location
    Buenos Aires, Argentina
    Posts
    20
    As rokslide said.. you can check the Execution Plan.. but.. if you have done it.. first you must create all the indexes and the primary keys in your tables.
    ------------------------------------
    Thanx
    ------------------------------------
    http://www.iespana.es/greatavatar/FIRMA/firma.jpg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •