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.
Title: Speed Up! – Parallel Processes and Unparalleled Performance
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.
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 (https://blog.sqlauthority.com)
Is there a way to join the session online?
same question as “sai”
is this possible to get video?
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).
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.
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