Free Webcast: Why is the Same Query Sometimes Slow?

I can smell your parameters from here

You swear nothing has changed, but all of a sudden, out of nowhere, queries that used to be fast are suddenly slow. Even weirder, you take the slow query from the application, run it in SSMS, and it’s totally fast! What’s going on?

You restart SQL Server or update statistics, and the problem seems to go away – but only for a few days or weeks, and then it comes right back. You’re familiar enough with execution plans to realize that you’re getting different plans, but…why? And how do you fix it long term?

In this free Idera Geek Sync session on Wednesday, January 27, you’ll see live demos of the most common culprit: parameter sniffing. You’ll learn how to recognize parameter sniffing when it strikes, understand what causes it, see how to fix it short term with the lowest impact possible, and learn 7 ways to fix it long term.

Register now. See you there!

Previous Post
Statistics Aren’t Guarantees: SQL Server Still Checks.
Next Post
Why Full Text’s CONTAINS Queries Are So Slow

1 Comment. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}