How to catch SQL Statement's information quickly
You can fetch all information about SQL Statement with below SQL scirpt. Then you can analyze and improve script to boost performance.
SELECT creation_time,last_execution_time,total_physical_reads,total_logical_reads ,total_logical_writes, execution_count , total_worker_time, total_elapsed_time , total_elapsed_time / execution_count avg_elapsed_time,SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,((CASE statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END
-qs.statement_start_offset)/2) + 1) AS statement_text
FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st ORDER BY total_elapsed_time / execution_count DESC
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15053694/viewspace-441982/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- To import data from excel to DB
- To create user and maintain authorization
- To create new Datatable
- Select all and Unselect all for ListView
- Useful Functions(2)
- To get text when ListView or GridView index changed
- To add header and data for ListView
- check all items
- To create ItemTemplate
- ASPNET's useful function(2)
