Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2007-12-17 : 07:57:09
|
| Hi, i'm running (it takes up to 1 hour to complete) an extensivly long sql query in SQL server Mngmnt studio 2005. Is there any possible way to see what is going on with query whilst executing?i'm using:SET STATISTICS IO ONSET STATISTICS TIME ONSET STATISTICS PROFILE ONBut i can't see anything until query is completed. Is there any back-way to see what is going on?thanky you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-17 : 08:00:53
|
| You can use SQL profiler trace to see how it executes each chunk of sql query by adding appropriate counters. Also use query execution plan once it finishes to get an idea of what all action is performed by SQL query engine. |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-17 : 08:01:37
|
| Is it just a single query or single SP? If it is single query, you can't see execution plan or IO statistics till the query completes. However, you can check estimated execution plan if you want.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
query optimization - execution plan, statistics