Determining What Happens When You Force an Execution Plan via the Query Store

Posted by: Simple Talk, on 29 Nov 2016 | View original | Bookmarked: 0 time(s)

When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways of getting feedback, ranging from the built-in reports to using extended events. Enrico explains the details.…The post Determining What Happens When You Force an Execution Plan via the Query Store appeared first on Simple Talk....

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 614 | Hits: 5

Similar Posts

  • Don't be afraid of complex constraints more
  • EDM QueryViews vs Defining Queries (and read-only views) more
  • What you can and can't do with the Messagebox Database server. more
  • CS Dev Guide: Search with APIs more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD