Pinned Loading

1. IO hunger queries, SQLServer IO hunger queries, SQLServer

   1

   /*

   2

   Q. How can i find I/O intensive queries?

   3

   A. You can list such queries by the help of 'sys.dm_exec_query_stats', 'sys.dm_exec_sql_text' and 'sys.dm_exec_query_plan'

   4

   5

   Hint. You can alter @RowSize value to manipulate row count of the result set

2. Cpu intensive queries, SQLServer Cpu intensive queries, SQLServer

   1

   /*

   2

   Q. How can i list Cpu intensive queries?

   3

   A. You can list such queries by the help of 'sys.dm_exec_query_stats', 'sys.dm_exec_sql_text' and 'sys.dm_exec_query_plan'

   4

   5

   Hint. Alter the @RowSize value to change the row count of the result set.

3. Slow queries in terms of Elapsed Tim... Slow queries in terms of Elapsed Time, SQLServer

   1

   /*

   2

   Q. How can i retrieve slow queries in terms of elapsed time in second?

   3

   A. You can list those queries by using 'sys.dm_exec_query_stats' with 'sys.dm_exec_sql_text' and 'sys.dm_exec_text_query_plan'

   4

   5

   Hint. By altering the @RecordCount value you can change the result set's row size

4. Extracting query from it's parent, S... Extracting query from it's parent, SQLServer

   1

   /*

   2

   Q. How can i extract indivual query from it's parent?

   3

   A. You can extract indivual query from it's parent by using offset values.

   4

   When reading the script below, please note that while ISO has a zero-based offset 

   5

   the SUBSTRING function has a one-based offset.

5. Queries are running now, SQLServer Queries are running now, SQLServer

   1

   /*

   2

   Q. How can i retrieve queries running now?

   3

   A. You can list queries running now by using 'sys.dm_exec_requests', 'sys.dm_exec_sessions', 'sys.dm_exec_sql_text' and optionally 'sys.dm_exec_query_plan'

   4

   */

   5

6. Queries have been executed frequentl... Queries have been executed frequently, SQLServer

   1

   /*

   2

   Q. How can i determine the queries have been executed frequently?

   3

   A. You can list such queries by the help of 'sys.dm_exec_query_stats', 'sys.dm_exec_sql_text' and 'sys.dm_exec_query_plan'

   4

   5

   Hint. You can alter @RowSize value to manipulate row count of the result set