SQL Server Performance

Query Optimizer

Discussion in 'Third Party Tools' started by Akthar, Aug 28, 2005.

  1. Akthar New Member

    Hi,,

    I am looking fo a query optimizer utility. I 've heard of one running on Linux. This is how it works:
    Execute your SQL Query - via the Linux Utility - the query is optimize by the urtility and results rendered to the client, i cant remenber the name of this utility,

    Does someone know about any other utility of the same kind????

    Thanks

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  2. dineshasanka Moderator

  3. FrankKalis Moderator

  4. ghemant Moderator

    Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />I am looking fo a query optimizer utility. I 've heard of one running on Linux. This is how it works:<br />Execute your SQL Query - via the Linux Utility - the query is optimize by the urtility and results rendered to the client, i cant remenber the name of this utility,<br /><br />Does someone know about any other utility of the same kind????<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />AFAIK their's no tool that is used to direct connect to MS SQL from Linux but their are odbc and jdbc drivers are available that can be use to connect with , here are some references :<br /><br /><a href='http://ccm.redhat.com/bboard-archive/webdb/00067l.html' target='_blank' title='http://ccm.redhat.com/bboard-archive/webdb/00067l.html'<a target="_blank" href=http://ccm.redhat.com/bboard-archive/webdb/00067l.html>http://ccm.redhat.com/bboard-archive/webdb/00067l.html</a></a><br /><a href='http://www.faqts.com/knowledge_base/view.phtml/aid/402' target='_blank' title='http://www.faqts.com/knowledge_base/view.phtml/aid/402'<a target="_blank" href=http://www.faqts.com/knowledge_base/view.phtml/aid/402>http://www.faqts.com/knowledge_base/view.phtml/aid/402</a></a><br /><a href='http://www.linuxjournal.com/article/6636' target='_blank' title='http://www.linuxjournal.com/article/6636'<a target="_blank" href=http://www.linuxjournal.com/article/6636>http://www.linuxjournal.com/article/6636</a></a><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards <br /><br /><br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  5. Akthar New Member

    any other tool even on Windows is not a problem , for SQL SERVER

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  6. FrankKalis Moderator

    I don't think you will find a tool that will optimize queries better than the build-in optimizer. What's wrong with Query Analyzer?

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

    hi,

    quote:Originally posted by Akthar

    any other tool even on Windows is not a problem , for SQL SERVER

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS

    i didn't understand y you are not using built in QA [?] ? or you need to format query ?!
    if it is so then search in Third-Party Tool in forum

    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami
  8. Akthar New Member

    hi Frank,

    no problem with SQL Query Analyzer, i have an application already written which i cant modify, just looking for a tool that can give a better performance of existing queries.

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  9. FrankKalis Moderator

    I see. In this case I would probably start with the Index Tuning Wizard. Have a look here:<br /<a target="_blank" href=http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx>http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx</a><br /<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;EN-US;311826>http://support.microsoft.com/default.aspx?scid=kb;EN-US;311826</a><br /<a target="_blank" href=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp</a><br /><br />It should give you ideas how you can improve performance via indexes. However, if the query itself is poor, no index can fix this. To a certain degree SQL Server is able to semantically optimize queries itself, but it cannot make a "good" query out of a "poor". When you have identified such poor performing queries and are in doubt if they are good or not so good, post them 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 />

Share This Page