SQL SERVER – Tomorrow 2 Sessions on Performance Tuning at TechEd India 2011 – March 25, 2011

Tomorrow is the third day of the TechED India 2011 at Bangalore. I will be speaking on two very interesting sessions. If you are developer, database administrator or just want to learn something new and interesting, I suggest you attend my two sessions tomorrow. Here is the details of the session.

Sessions Date: March 25, 2011

Here is the abstract of the session:

Understanding SQL Server Behavioral Pattern – SQL Server Extended Events
Date and Time: March 25, 2011 12:00 PM to 01:00 PM

History repeats itself! SQL Server 2008 has introduced a very powerful, yet very minimal reoccurring feature called Extended Events. This advanced session will teach experienced administrators’ capabilities that were not possible before. From T-SQL error to CPU bottleneck, error login to deadlocks –Extended Event can detect it for you. Understanding the pattern of events can prevent future mistakes.

SQL Server Waits and Queues – Your Gateway to Perf. Troubleshooting
Date and Time: March 25, 2011 04:15 PM to 05:15 PM

Just like a horoscope, SQL Server Waits and Queues can reveal your past, explain your present and predict your future. SQL Server Performance Tuning uses the Waits and Queues as a proven method to identify the best opportunities to improve performance. A glance at Wait Types can tell where there is a bottleneck. Learn how to identify bottlenecks and potential resolutions in this fast paced, advanced performance tuning session.

Here is the video which my wife shot while I was preparing for the sessions.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Extended Events, SQL Wait Stats
Previous Post
SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID
Next Post
SQLAuthority News – Win Surprise Gift at TechED 2011 Sessions – Wait Types and Extended Events

Related Posts

5 Comments. Leave new

  • HI Dave,
    Whenever i faced problems with sql, ur blog is the first place for to search. But this is the first time I comment. Now I’m doing batch processing for some finance related modules.

    I will be running few store procedures to retrieve , create and update on tables for large volume of data. And I’m not very good at sql and this is my first time doing something like that. So I would like to know what are the things that i need to aware of in terms of performance. Can you please gimmie some advice? Sorry for my poor english. :(
    all i know is use temp tables for sub queries, get some index on tables blah blah. and I only do simple queries before this task. So now I’m looking for real things :D

  • Hi,

    Can you share the presentations please?


  • Hi,

    Can you Send the presentations please?


  • Hi
    It would be of great help if you share the presentation files..

    Tanx in Adbvance

  • adityabadramraju
    December 13, 2011 8:00 pm

    Hi Pinal,

    Hope your doing great. I just downloaded the videos from Teched on Extended events and I m struck at Presentation. The Download presentation is not working. Can you please share the deck. Thanks in anticipation



Leave a ReplyCancel reply

Exit mobile version