Tag: Improve Query Performance
Deadlocks
SQL doctor can be used to identify the cause of deadlocks. A deadlock is when a cyclic dependency occurs between two or more threads, processes, resources, etc. This causes one of the processes to be declared the deadlock victim and killed so that the other process can continue. To identify deadlocks and provide useful information [...]
Posted: October 20th, 2010 under Deadlock, Recommendations, SDR-DL1, SDR-DL2.
Tags: Deadlocks, Improve Query Performance, Query Optimization, Query Tuning, SDR-DL1, SDR-DL2, SQL Server Performance
Comments: none
Implicit Conversion Recommendation
Improve SQL Server performance by avoiding an implicit conversion in a search predicate.
Posted: September 30th, 2010 under Implicit Conversion, Query Optimization, SDR-Q36.
Tags: Analyze Execution Plans, Analyze Queries, Analyze Query Performance, Efficient Queries, Execution Plan, Improve Query Performance, Query Optimization, Query Tuning, SDR-Q36, SQL Server Performance
Comments: 2
Missing Join Predicate Recommendation
The ‘Missing Join Predicate’ recommendation (SDR-Q19) given by SQL doctor for a query that results in the cartesian product of two or more tables will help identify bottlenecks in TSQL to improve query performance.
Posted: September 23rd, 2010 under Missing Join Predicate, Query Optimization.
Tags: Analyze Execution Plans, Analyze Queries, Analyze Query Performance, Efficient Queries, Execution Plan, Improve Query Performance, Query Optimization, Query Tuning, SDR-Q19, SQL Server Performance
Comments: none
