Tomorrow night I will be talking about Execution Plans for the Wisconsin SQL Server User Group. This is a new session for me and I think the group and I will have a great time discussing how important it is to dig deep into plans. Execution plans are without a doubt a point in the tuning process in which we can either make a database server live or land face first on the floor.
The meeting is held in Waukesha, WI.
Address: N19 W24133 Riverwood Dr., Suite 150, Waukesha, WI 53188
To all my Illinois and #ChiSQL friends, the drive is actually short and an easy one. Take I-94 straight up and just west of Milwaukee. Check the construction schedules and detours of course. Milwaukee area like many other areas is in an ever changing battle with those orange cones and roads closing.
I hope to see everyone there! Let’s make the turnout a good one this month.
Session Description
Have you ever had a query take FOREVER to execute? I have and it isn’t a good feeling. Often those queries still end up on Production simply because, “they work”. Let’s go behind the scenes of each query and address one of the largest factors in predicting how queries will perform, and even potentially lower the resource cost on the database server itself: Execution Plans. Beginning with SQL Server 2005 we are provided with a wealth of information about Execution Plans that have been executed. With this information we can finally tune queries based upon the exact process SQL Server takes to execute the commands we requested. This session will go from T-SQL Statement to Execution Plan. We will uncover high cost operations that are common yet easy to fix along with discussing some DMV statements that assist us in tuning queries. Our goals we will achieve together Our goals we will achieve together
4 Comments
Are you going to post your session online later?
Yes. I will post a pdf version of the slides and any scripts used.
So how did it go?
Very well, thanks. 🙂
The group that came was great. Interaction was high and we had a great time on the topic and venturing off a bit on other topics. I enjoy the fact we can all take advantage of the one day a month to pull as much info out of each other as we can in one sitting.
The session as written needs work though. Given one or two more runs I think it will only get better.