question

Alex.Prusakov avatar image
Alex.Prusakov asked

How to troubleshoot performance of a query that is based on nested views.

I am troubleshooting performance of a query that is based on a few nested views. I am struggling to link that query execution plan with execution plans of all views that the query is based on. Erin Stellato has recommended to create an item in User Voice. Now I am trying to see if that idea worth anything as well as find how other DBAs are troubleshooting performance for a query that is based on a view or on a series of nested views. A vote at https://feedback.azure.com/forums/908035-sql-server/suggestions/34971124-add-or-link-views-execution-plan-to-a-query-execu will help to get new feature in the next SQL Server. I doubt it is just my problem but will appreciate help.

viewsexecution planperfomance
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.