Find Most Expensive View (By Execution Count)
'An important step in optimizing a system is to take a holistic approach and look at View that are called very often. These procedures can often be the backbone of a system. Sometimes optimizing these procedures can have a dramatic effect on relieving the physical bottlenecks of the system and improving end-user experience.
The following DMV query shows the execution count of each View, sorted by the most executed View first.'...
http://www.sqlservercentral.com/scripts/Performance/166762/?utm_source=SSC&utm_medium=pubemail
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt