SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India

TechEd India 2012 is just around the corner and I will be presenting there on two different session. SQL Server Performance Tuning is a very challenging subject that requires expertise in Database Administration and Database Development. I always have enjoyed talking about SQL Server Performance tuning subject. Just like doctors I like to call my every attempt to improve the performance of SQL Server queries and database server as a practice too. I have been working with SQL Server for more than 8 years and I believe that many of the performance tuning concept I have mastered. However, performance tuning is not a simple subject. However there are occasions when I feel stumped, there are occasional when I am not sure what should be the next step. When I face situation where I cannot figure things out easily, it makes me most happy because I clearly see this as a learning opportunity.

I have been presenting in TechEd India for last three years. This is my fourth time opportunity to present a technical session on SQL Server. Just like every other year, I decided to present something different, something which I have spend years of learning. This time, I am going to present about parallel processes. It is widely believed that more the CPU will improve performance of the server. It is true in many cases. However, there are cases when limiting the CPU usages have improved overall health of the server.

I will be presenting on the subject of Parallel Processes and its effects. I have spent more than a year working on this subject only. After working on various queries on multi-CPU systems I have personally learned few things. In coming TechEd session, I am going to share my experience with parallel processes and performance tuning.

Session Details

Title: Speed Up! – Parallel Processes and Unparalleled Performance (Add to Calendar)

Abstract:
 “More CPU More Performance” – A  very common understanding is that usage of multiple CPUs can improve the performance of the query. To get maximum performance out of any query – one has to master various aspects of the parallel processes. In this deep dive session, we will explore this complex subject with a very simple interactive demo. An attendee will walk away with proper understanding of CX_PACKET wait types, MAXDOP, parallelism threshold and various other concepts.

Date and Time: March 23, 2012, 12:15 to 13:15

Location:
 Hotel Lalit Ashok – Kumara Krupa High Grounds, Bengaluru – 560001, Karnataka, India.

Add to Calendar

Please submit your questions in the comments area and I will be for sure discussing them during my session. If I pick your question to discuss during my session, here is your gift I commit right now – SQL Server Interview Questions and Answers Book.

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

About these ads

7 thoughts on “SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India

  1. Hi Pinal Sir,

    That sounds pretty cool..!!!!
    I studied some thing about Parallel Process’s.This is one of my favorite subject.
    These can cover under this topic.

    How to use stored procedures ‘sp_configure’ to configure parallel processing and how they works on multiple servers…??
    How to do parallelism settings..???
    CPU’s working on 32/64 bit and their classifications
    Light weight pooling(Windows Fibers Concept).

  2. I Want to know more on how to monitor multiple requests on server and how to set queries in a desired queue if it is required.

  3. Pingback: TechEd India 2012: SQL Content Extravaganza | Vinod Kumar (Blog home)

  4. Pingback: SQL SERVER – TechEd India 2012 – Content, Speakers and a Lots of Fun « SQL Server Journey with SQL Authority

  5. I read it as ” degree of parallelism value can be set at server level and also for individual query or index statements”.
    I want to know more about the difference between these two settings. which is the best practice.?
    Suppose we have done both these settings.Which setting will be taken by the server?
    And Also want to know about the importance to have a MAXDOP setting…

    Thanks and Regards
    SIJIN KUMAR

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s