My journey finally ends at the SQLPASS 2012 Summit


Yesterday SQLPASS revealed the sessions that were selected for the upcoming SQLPASS

summit in Seattle from November 6 – 9. I'm very happy to announce that I'm presenting

2 regular sessions and a precon about SQL Server Performance Troubleshooting! I'm

really happy to have a chance to present a precon, because this was one of my biggest

dreams when I first presented about SQL Service Broker back in 2006 in Seattle. I

have presented at every summit since then (expect 2008 for some personal reasons),

and I have taken one step after one step to finally reach that ultimate goal.

I have already presented last year a session about Advanced SQL Server Troubleshooting

(which I'm doing this year again!), and it was a real blast: it was the largest session

with more than 900 attendees. I never thought about that back in 2006, when I presented

about a very niche technology like Service Broker in front of a few people. So I have

really enjoyed my SQLPASS journey through the last years, and I'm really happy to

finally ending up with my own precon about one of my favourite topics – SQL Server

Performance Troubleshooting:

Practical SQL Server Performance Troubleshooting

Learn how to configure the Windows OS, SQL Server, and your database for optimal

performance. In this pre-conference workshop, we'll start by taking a default installation

of SQL Server and running an OLTP workload with several hundred users to generate

our initial baseline for performance tuning and troubleshooting. Throughout the day,

we'll work with various areas of SQL Server to implement different performance optimizations

and then see how those changes impact the throughput of our initial test workload.

At the end of the day, we'll have a well-performing SQL Server that can handle a much

larger workload than the initial (default) installation.

Topics for the day include:

• Windows OS settings

• Storage configuration

• SQL Server instance settings

• Database settings

• Index and statistics maintenance

• Locking, blocking, and deadlocking

• Memory management

Besides the precon I'm also presenting two regular conference sessions:

ColumnStore Indexes: The Turbobooster

inside SQL Server 2012

Can you improve your data warehouse query performance by 100 times just by adding

one additional index? With SQL Server 2012's new columnstore index, the paradigm for

DW queries has changed completely. In this session, we will look at the details of

the columnstore index, when it does and doesn't make sense, and current restrictions.

We will explore row store vs. column store and how to change data in tables that

have a columnstore index defined. We will also discuss segment elimination, batch

mode execution, query memory grants, and how you can ensure that SQL Server will use

your columnstore index as effectively as possible. Then, you will see a real-world

example of how fast the columnstore index works on a table with more than 2 billion

records – on commodity hardware.

Advanced SQL Server Troubleshooting

It's Friday, 5:00pm, and you just received an email alert that your SQL Server

has enormous performance problems! What can you do? How can you identify the problem

and resolve it fast? Which tools does SQL Server give you for this task?

In this session, we will look at the key resources that SQL Server uses – storage,

CPU, memory – and how you can effectively troubleshoot them. You will learn how to

identify performance bottlenecks and how to resolve them.

I'm looking forward to see you all very soon in Seattle, and thanks for attending

all of my sessions in the past 6 years!