A quick note for all – If you are attending my TechEd sessions today here are few notes for you.
Sessions Date: March 25, 2011
Understanding SQL Server Behavioral Pattern – SQL Server Extended Events
Date and Time: March 25, 2011 12:00 PM to 01:00 PM
SQL Server Waits and Queues – Your Gateway to Perf. Troubleshooting
Date and Time: March 25, 2011 04:15 PM to 05:15 PM
If you are attending the session – rest assure – few of you are going to get very interesting surprise gift. A good quality one! To win – you just have to walk in the sessions.
Who Should Attend?
YOU! This session is for everybody who wants to learn something new in the area. It does not matter you work with SQL or not. If you are using application with database as back-end. This session is for you.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Sir, in simple terms and example, could you please tell us/ an article is most desireable about wait and queue.. thanks in adavnce
I am seeing waittypes for a update statement as Cxpacket and SOS-Scheduler_Yied and the it goes for ever , the table is a partitioned table when i remove the partion and run the uodate it takes 3mins however with partioned table it is takeing over 1.5 hours. I have clustered index on the the column which is partioned column.
Kindly advice what could be the issue.