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 appsfull library searchprogress trackingexercise files,assessments, and offline viewing. Happy learning!

Get our content first. In your inbox.

Loading form...

If this message remains, it may be due to cookies being disabled or to an ad blocker.

Contributor

Paul Ballard

is a Chief Architect specializing in large scale distributed system development and enterprise software processes. Paul has more than twenty years of development experience including being a former Microsoft MVP, a speaker at technical conferences such as Microsoft Tech-Ed and VSLive, and a published author. Prior to working on the Windows platform, he built software using a vast array of technologies including Java, Unix, C, and even OS/2.