Elapsed time for few SQL queries is 0 in sys.dm_exec_query_stats table?

[karthick n]

Hi,

I get the elapsed time from sys.dm_exec_que ry_stats table for each SQL query that I run in MSSQL. I see that the elapsed time for some of the SQL queries are shown as 0 while oracle performance statistics data show some time for the same query.

I believe MSSQL can't take 0 microseconds to execute a query. Should I need to force MSSQL to monitor the lesser time taking queries?

I also used "SET STATISTICS TIME ON", I get 0 elapsed time from this too for those queries which had 0 elapsed time from sys.dm_exec_que ry_stats.

Any help will be helpful

[ck9663]

Which elapsed time? Are you running a batch?

~~ CK