bibarius
asked on
Know query time performance in "Query Analyzer"
Hello!
How can i see query time performance in Query Analyzer(in miliseconds).
In Execution Plan may be it's a "Cost" or "Subtreecost"
or somthing else.
Somebody can explane me?
Thank you!
How can i see query time performance in Query Analyzer(in miliseconds).
In Execution Plan may be it's a "Cost" or "Subtreecost"
or somthing else.
Somebody can explane me?
Thank you!
ASKER
Yes but it not exect time.
I need it in Execution Plan , in miliseconds
I need it in Execution Plan , in miliseconds
i'm afraid you can not get this information. Execution plan gives you the estimate cost of each step in percentage of the exection plan. This is just a planed cost, but not the actual one. It may take more or less of the total execution plan. The goal of the execition plan is to show how the query will be splitted into pieces and what resources will be needed for each step (indexes, etc.).
If you use percentage together with total execution plan you may come to some rough time of the exection plan for the step.
If you use percentage together with total execution plan you may come to some rough time of the exection plan for the step.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
bibarius,
to see the query time in milliseconds, in Query analyzer go to Query/Current Connection Options, General Tab, check "Show stats time". This will result that in the output area you will see such messages:
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 1 ms.
Each block corresponds a step in the execution plan.
Cheers.
to see the query time in milliseconds, in Query analyzer go to Query/Current Connection Options, General Tab, check "Show stats time". This will result that in the output area you will see such messages:
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 1 ms.
Each block corresponds a step in the execution plan.
Cheers.
ASKER
george74,
In Query/Current Connection Options i have`t "Show stats time", i have "Connection Properties" tab and there not "Show stats time"
In Query/Current Connection Options i have`t "Show stats time", i have "Connection Properties" tab and there not "Show stats time"
bibarius,
sorry than, but what version of mssql are you using? my previous comment should apply on mssql7.
cheers,
george
sorry than, but what version of mssql are you using? my previous comment should apply on mssql7.
cheers,
george
ASKER
ok. i`am using MS SQL2000
well even simplier,
( Ctlr + Shift + T )
run query
and check the trace.
make sure query to output to tabular format. ( Ctrl + D ) before running a query.
...personally, I would prefer the text based command, no need to use mouse, all those clicks...
did you try to execute
SET STATISTICS TIME ON
and then run some queries?
( Ctlr + Shift + T )
run query
and check the trace.
make sure query to output to tabular format. ( Ctrl + D ) before running a query.
...personally, I would prefer the text based command, no need to use mouse, all those clicks...
did you try to execute
SET STATISTICS TIME ON
and then run some queries?
bibarius:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept miron's answer
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Arbert
EE Cleanup Volunteer
when you execute the query on the botom (status bar) you can see how much time it runed.