Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
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).
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Adam Machanic
Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "Expert SQL Server 2005 Development" (Apress, 2007) and "Inside SQL Server 2005: Query Tuning and Optimization" (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.