Performance Tool Question

I am looking for a tool that will help optimize TSQL and Stored Procedures
in SQL Server 2000. Can anybody recommend a good tool?
I need something that will scan a TSQL, Stored Procedure or View and
recommend optimizations.
Thanks.
Take a look at www.superiorsql.com
This is a tool to build sql statements on the fly, don't know whether this
tool has a performance-optimizer
Within query analyzer you can show the execution plan for each stored
procedure.
Open a new window in query analyzer and type execute myprocedurename ( type
an existing procedure name in the field myprocedurename)
The execution plan will show all scans to be performed and will give hints
to improve (for instance building extra indexes).
Performance-optimizing is the essence of a DBMS so I guess you have to use
the internal algorithms by using the execution plan of MSSQL
"Ed Willis" <ed_willis@.acsi.orgnospam> schreef in bericht
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>
|||Hi Ed,
Quest Software has a ton of tuning and optimization tools built into their
Quest Central for SQL Server product. You can get an older version as
freeware at http://www.quest.com/quest_central/s...ver/freeware/. Check out the
Database Analysis tool in the freeware product. The latest version has a
lot more SQL tuning tools where it will look at your SQL statements and
recommend much better performing queries. I'm not sure if that version is
in trialware or freeware yet.
Hope this helps,
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support the PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>