Video: Don't Let SQL Server Overestimates Slow Your Queries
- select the contributor at the end of the page -
When creating an execution plan for a query, SQL Server can sometimes over or under estimate the amount of memory required which can greatly affect the performance of concurrently running queries. In this video excerpt from Joe Sack's new course SQL Server: Troubleshooting Query Plan Quality Issues you'll see how to catch SQL Server in the act of overestimating memory usage and how that can starve other queries. In the full course Joe covers other key query plan issues such as resolving NO RECOMPUTE issues, hidden column correlation, and complex predicates.
[youtube http://www.youtube.com/watch?v=QJoA5R4KjFg?feature=player_detailpage]
Joe Sack is a Principal Consultant, author and trainer with SQLskills.com. He is a SQL Server MVP and SQL Server Microsoft Certified Master. Prior to joining SQLskills, Joe worked at Microsoft as a Premier Field Engineer for large enterprise environments. He was also responsible for the SQL Server MCM Program from 2009 to 2011. He has written multiple books, articles and whitepapers including SQL Server 2008 Transact-SQL Recipes (Apress, 2008) and SQL Server 2005 T-SQL Recipes (Apress, 2005).
You can watch the full HD version of this video along with the other 2 hrs and 20 min of video found in this professional course by subscribing to Pluralsight. Visit SQL Server: Troubleshooting Query Plan Quality Issues to view the full course outline. Pluralsight subscribers also benefit from cool features like mobile apps, full library search, progress tracking, exercise files,assessments, and offline viewing. Happy learning!
[youtube http://www.youtube.com/watch?v=QJoA5R4KjFg?feature=player_detailpage]
Joe Sack is a Principal Consultant, author and trainer with SQLskills.com. He is a SQL Server MVP and SQL Server Microsoft Certified Master. Prior to joining SQLskills, Joe worked at Microsoft as a Premier Field Engineer for large enterprise environments. He was also responsible for the SQL Server MCM Program from 2009 to 2011. He has written multiple books, articles and whitepapers including SQL Server 2008 Transact-SQL Recipes (Apress, 2008) and SQL Server 2005 T-SQL Recipes (Apress, 2005).
You can watch the full HD version of this video along with the other 2 hrs and 20 min of video found in this professional course by subscribing to Pluralsight. Visit SQL Server: Troubleshooting Query Plan Quality Issues to view the full course outline. Pluralsight subscribers also benefit from cool features like mobile apps, full library search, progress tracking, exercise files,assessments, and offline viewing. Happy learning!
