SQL Server Performance

tuning

Discussion in 'Performance Tuning for DBAs' started by RAJENDRA, Jul 13, 2005.

  1. RAJENDRA New Member

    Hi,Thanks for ur co-operation.

    One query was running yesterday fine and today it is running very slow.

    can u tell me what r the steps to find what is the wrong in that ?

    rajendra
  2. Madhivanan Moderator

    Where are you running that in QA or in Applicatiion?


    Madhivanan

    Failing to plan is Planning to fail
  3. RAJENDRA New Member

    in query analyzer

    rajendra
  4. Madhivanan Moderator

    Did you add records to that table in the mean time?
    Can you post the query you used?


    Madhivanan

    Failing to plan is Planning to fail
  5. surendrakalekar New Member

    Run trace for that query and also check the indexes required for that query.
    Post your query here, so it will be better to understand.


    Surendra Kalekar

  6. satya Moderator

    You can view the estimated execution plan before execution in order to find out the cost of query.
    If it is in a stored procedure then recompile the plan and clear the cache.

    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.
  7. FrankKalis Moderator

    Sounds like you have done massive data modifications in the meantime.
    See if EXEC sp_updatestats will help you.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  8. RAJENDRA New Member

    Sorry man that was an interview question what I`ve faced

    rajendra
  9. FrankKalis Moderator

    An important information that was missing before, don't you think? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br />Anyway, now you have several suggestions how to start tackling this problem.<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  10. satya Moderator

    You can deploy all the suggestions here in order to get optimum performance and if this is for your project study or interview questions then please be specific.

    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.
  11. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by RAJENDRA</i><br /><br />Sorry man that was an interview question what I`ve faced<br /><br />rajendra<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Yes, all your questions seem to be [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  12. FrankKalis Moderator

    Hm, after reading your other threads, it really seems so. <br />Not to sound offending, but may I suggest, that you grab such common information either from BOL, from this site or elsewhere on the net and come back with more specific question? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  13. RAJENDRA New Member

    Am I bothering u all with my unncessary question.

    Please pardon me I`ve an Interview with Infosys today.
    thats why I am posting these questions.

    rajendra
  14. satya Moderator

  15. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by RAJENDRA</i><br /><br />Am I bothering u all with my unncessary question.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />No, but many things you should already know.<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Please pardon me I`ve an Interview with Infosys today.<br />thats why I am posting these questions.<br /><br />rajendra<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Good luck! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  16. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by RAJENDRA</i><br /><br />Am I bothering u all with my unncessary question.<br /><br />Please pardon me I`ve an Interview with Infosys today.<br />thats why I am posting these questions.<br /><br />rajendra<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />No, keep asking questions<br />All the best<br />Let us know if you get selected at Infosys [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Read BOL for more info on all your questions<br /><br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  17. RAJENDRA New Member

    I am trying to learn thats why I am posting my doubts

    rajendra
  18. FrankKalis Moderator

    Learning is absolutely okay, but you didn't tell at first about the interview. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br />Anyway, welcome to the family here. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  19. surendrakalekar New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by RAJENDRA</i><br /><br />I am trying to learn thats why I am posting my doubts<br /><br />rajendra<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Why don't you try to learn how to post your doubts [<img src='/community/emoticons/emotion-4.gif' alt=':p' />][<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br />Good luck to you.<br /><br /><h6>Surendra Kalekar</h6>
  20. RAJENDRA New Member

    Thank U for ur Invitation.

    I am new to this MS Sql Server 2000 Please teach me how administrate

    rajendra
  21. satya Moderator

    I beleive Rajendra will be 'knocked for six' to see immediate response here.[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</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.</i></font id="size1"></font id="teal"></center>
  22. FrankKalis Moderator

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_id_com_admn2.asp

    There is also an article on SQL Server MVP Vyas Kondreddi's site. But I haven't got the link right now. I'm sure Satya will post it.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  23. satya Moderator

  24. ghemant Moderator

    Hi ,<br />here is a link of Article's page of Narayana Vyas Kondreddi , <br /<a target="_blank" href=http://vyaskn.tripod.com/microsoft_sql_server_articles.htm>http://vyaskn.tripod.com/microsoft_sql_server_articles.htm</a><br /><br /><br />[:I][<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />hsGoswami<br />ghemant@gmail.com

Share This Page