Execution time

Hi
When I run an sp or a complex query in the query analyzer, it shows a world
spining and an execution time at the bottom while the query is still
working.
Is there a way to get that execution time so I can show it inside a program
code like Delphi?
How does that counter work?
Also for the world pic.
Thanks
It's just a counter. It's not generated by SQL Server, it's purely within
Query Analyzer. It starts ticking when QA submits the query and ends when
the query returns.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Gonzalo Torres" <condormix2001@.yahoo.com.mx> wrote in message
news:uPZomUi4EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> When I run an sp or a complex query in the query analyzer, it shows a
world
> spining and an execution time at the bottom while the query is still
> working.
> Is there a way to get that execution time so I can show it inside a
program
> code like Delphi?
> How does that counter work?
> Also for the world pic.
> Thanks
>
|||Gonzalo Torres wrote:
> Hi
> When I run an sp or a complex query in the query analyzer, it shows a
> world spining and an execution time at the bottom while the query is
> still working.
> Is there a way to get that execution time so I can show it inside a
> program code like Delphi?
> How does that counter work?
> Also for the world pic.
> Thanks
You'll need to run your query asychronously from Delphi and then you can
just update a running counter and show any fancy graphic you need to
keep the user interested.
David Gugick
Imceda Software
www.imceda.com

Execution time

Hi
When I run an sp or a complex query in the query analyzer, it shows a world
spining and an execution time at the bottom while the query is still
working.
Is there a way to get that execution time so I can show it inside a program
code like Delphi?
How does that counter work?
Also for the world pic.
ThanksIt's just a counter. It's not generated by SQL Server, it's purely within
Query Analyzer. It starts ticking when QA submits the query and ends when
the query returns.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Gonzalo Torres" <condormix2001@.yahoo.com.mx> wrote in message
news:uPZomUi4EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> When I run an sp or a complex query in the query analyzer, it shows a
world
> spining and an execution time at the bottom while the query is still
> working.
> Is there a way to get that execution time so I can show it inside a
program
> code like Delphi?
> How does that counter work?
> Also for the world pic.
> Thanks
>|||Gonzalo Torres wrote:
> Hi
> When I run an sp or a complex query in the query analyzer, it shows a
> world spining and an execution time at the bottom while the query is
> still working.
> Is there a way to get that execution time so I can show it inside a
> program code like Delphi?
> How does that counter work?
> Also for the world pic.
> Thanks
You'll need to run your query asychronously from Delphi and then you can
just update a running counter and show any fancy graphic you need to
keep the user interested.
--
David Gugick
Imceda Software
www.imceda.com

Execution Plan Analysis

Hi,

I want to know how to analyze query execution plan for complex queries and what information is useful from that for improving the performance. I have gone through details in some sites like www.like sql-performance.com (http://www.sql-server-performance.com/query_execution_plan_analysis.asp), where it was more generic. I want more info regarding this.

Can any one tell about the resources for this or do you have any white papers or documents, which you can share with me.

Thanks in advance,
sekharYou should check out this book ...

Microsoft SQL Server 2000 Performance Tuning Technical Reference

It has all you could ever want to know.