Clever Geek Handbook

Query for Labor Dependent SQL Queries in SQL Server

How can we get information about badly performing sqls (too long to execute)

Does MS SQL Server support tables / views (similar to v $ sql in Oracle) for storing SQL queries.

0


source to share


2 answers


I use SQL Profiler to collect statistics, which I can then use to nail down where some work needs to be done, set up indexes, etc.



Here are some tips for monitoring with Profiler: http://www.developer.com/db/article.php/3490086 http://vyaskn.tripod.com/analyzing_profiler_output.htm

+5


source


take a look at sys.dm_exec_query_stats and this page . SQL Server 2005+ only.



+1


source






More articles:


All Articles