I get the elapsed time from sys.dm_exec_query_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_query_stats.
Any help will be helpful
View Complete Post