Find single-use, ad-hoc, and prepared queries
dm_exec_cached_plans , dm_exec_sql_text
Performance
Get top average elapsed time queries
dm_exec_query_plan, dm_exec_query_stats
Get the most frequently executed queries for this database
dm_exec_query_stats, dm_exec_query_plan
How to read the SQL Server query plan file using TSQL
Here I am trying to read sql server plan (Execution query Plan) file from ssms query.
How to find a backup task by percentage complete
Here I am showing how to check backup task completed by percentage. Other Refrences:
How to find the missing foreign key indexes
Here i am trying to find missing indexes on foreign key relation tables. Other References:
Get top total worker time queries
dm_exec_query_stats, dm_exec_query_plan
How to read Deadlock from system health of SQL server
Here is a sample query to help read deadlock from sys.health extended events.
Page Life Expectancy (PLE) value for each NUMA node
dm_os_performance_counters
Finding a SQL Server running Task with percentage complete using DMVs
How to Tracking query progress with Live Query Statistics In SQL Server Some tasks that are running take a long time to run and it is sometimes difficult to tell whether these tasks are progressing or not. With the help of below script we are able to track the percentage completion of tasks like:- Database …
Finding a SQL Server running Task with percentage complete using DMVs Read More »
