Re: Performance Tool Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Johan Koopmans (koopmans.johan_at_hccnet.nl)
Date: 11/06/04 

Date: Sat, 6 Nov 2004 20:31:10 +0100

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

Relevant Pages

  • Re: Newbie: Stored Procedures and Or Datasets ?
    ... >the proc is executed for the first time, the execution plan is then cached ... whole lot of advantages over a standard ad-hoc T-SQL ... An Evaluation of Stored Procedures for the .NET Developer ... SQL Server, execution plans are cached for all T-SQL batches, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Confused about proc vs. dynamic SQL vs LINQ
    ... stored procedures are going to be faster than ... performance from dynamic sql (sql that you generate on the client and ... as well as if the queries are the same and a number ... another execution plan would be faster because statistics changed. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Is sql server as good as access 97?
    ... you might recall that the reason you had to use 'stacked' queries was that ... do not confuse 'stacked' queries with functions. ... Transact-SQL is your aim then use functions or call other stored procedures. ... As far as EM v Query Analyzer is concerned, ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored proc recompilation
    ... There are other benefits to using stored procedures than just reusing the ... you have no choice but to generate a new execution plan each ... Jacco Schalkwijk ... "Chuck Urwiler" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Timeout during initial basic insert
    ... have you looked at the execution plan in Query Analyzer to find out ... Is this a problem with SQL server? ...
    (microsoft.public.sqlserver.server)