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)
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?
Thanks
Hi,
Can you Send the presentations please?
Thanks
Hi
It would be of great help if you share the presentation files..
Tanx in Adbvance
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
Aditya