One of the coolest features is the Anonymize button so you can share with others without compromising confidential information. This article shows you how I have used SQL Sentry Plan Explorer to view Estimated and Actual Execution Plans. But it’s still an interesting exercise to study what each operator does. It does take less than 1 second on my laptop, so it’s not so bad. Now, I have nicely organised and visualised rich information in SQL Sentry Plan Explorer to help with my investigation on optimising this query further. (With the Actual Execution Plan), SQL Server can tell you exactly how many reads were performed, how many rows were read, and what joins were performed. This is expected because – to quote Jes’ article,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |