PASS Performance Virtual Chapter: Parallelize Your Queries!

Adam Machanic — Mon, 02 Aug 2010 15:51:00 GMT

Last month a new PASS Virtual Chapter was introduced, one with a theme that is near and dear to much of what I like to work on: performance. Tomorrow, Tuesday August 3rd at noon Eastern time, the chapter will have its second meeting, and I will be doing the presentation. The topic is Parallelism and Performance. Here's the abstract:

In today's multi-core-driven world, query performance is very much determined by how well you're taking advantage of the processing power at your disposal. Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn the background necessary to take full advantage of parallelism. We'll cover what parallelism is, why it's important, and the basics of how to read parallel query plans. Examples will be shown to illustrate some of the huge performance gains that can be had when we learn to properly control SQL Server's parallel processing capabilities. This session is a small preview of some of the material that will be covered in Adam Machanic's full-day PASS Summit post-con, "A Day of Doing Many Things at Once."

This is a free webcast. Click here for more information and to register.

Looking forward to seeing you there (well, virtually speaking).

Search results matching tags 'PASS', 'performance', and 'query plans'

PASS Performance Virtual Chapter: Parallelize Your Queries!