SQL Server Performance

Query Tuning

Discussion in 'T-SQL Performance Tuning for Developers' started by sugeshkr, Jun 12, 2007.

  1. sugeshkr New Member

    Thanks for all your replies.
  2. MichaelB Member

    try using an "include" option on your index. this will allow you to store the actual data at the leaf level and keep from having sql go back to the data to pull it (bookmark lookup) . I would run it with "SET STATISTICS XML ON" and look at what it says in the xml are missing indexes. It should recommend and index with the "include" parm.



    Michael
    MCDBA

    "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"
  3. sugeshkr New Member

    Mike,
    Tried SET STATISTICS XML ON and that returned an error. And how to include the include option in index do we have to specify that while creating an index or in the select statement. Your suggestions were useful but dint help to sort my issue. thanks.

    Cheers

    Sugesh kumar R. MCDBA
  4. satya Moderator

    How often the database optimization tasks such as REDINEXING & UPDATE STATS are scheduled on this database?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. sugeshkr New Member

    Unfortunate to say this. I took over the DBA just last week. And saw that they were not scheduled. I have scheduled those jobs to execute every week hence forth. I executed update stats, rebuild index and reorganize index yesterday. And now every thing is up-to-date.

    Cheers

    Sugesh kumar R. MCDBA
  6. satya Moderator

    Good, as you say new to this environment I suggest to run through thishttp://www.sql-server-performance.com/sql_server_performance_audit.asp link for a better understanding of your SQL Server and fix the issues.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  7. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] I meant to say as you are new that working environment, never under estimated your DBA experience. Anyway you are in right place to achieve what you want as a DBA.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  8. sugeshkr New Member

    Satya,

    I dint say that you under estimated my experience i just misundersttod your statement and expressed my view that i had almost 4 years of SQL DBA exp. Unfortunate till today i have been more and more infrastructure oriented DBA than a development DBA. So tuning queries takes time for me to address the right place to get it right.

    Cheers

    Sugesh kumar R. MCDBA
  9. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] No worries getting cleared on doubts, why did you deleted your post [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]... no harm leaving it there.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  10. Madhivanan Moderator

    quote:Originally posted by sugeshkr

    Thanks for all your replies.
    It is not a good practice to delete the question after getting solved
    This prevents others from learning new things

    Again edit your topic and post the question and let your "thanks" reply as new reply

    Madhivanan

    Failing to plan is Planning to fail

Share This Page