THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

Query Performance and Parallelism Seminars in Boston and Chicago

You're a DBA or database developer working on a big (or even big-ish -- doesn't have to be huge) database. Your end-users are doing all sorts of data analysis, and even though you have a pretty beefy server, your queries just don't seem to run as fast as they should.

The reason (I bet)? Your queries aren't taking full advantage of the CPU power available in today's servers. SQL Server has powerful parallel processing capabilities, but left to its own devices (and defaults) you're never going to see the full potential. Luckily, this can be fixed. You can make your queries much faster. (Often an order of magnitude or more!) And I can show you how.

Join me in Boston or in Chicago, the Friday before the upcoming SQL Saturday events in those cities, and we'll go deep into parallel processing. You'll learn about Windows server and how it deals with processes and threads, about SQLOS and its thread scheduling internals, how the SQL Server query processor works, and how you can use all of this knowledge to make your queries run faster and your server behave more consistently, even under load.

These full-day seminars cost only $150 and include lunch, coffee, and a printed course book -- plus a full day of intense content.

Full information, including an outline and registration details, is available at the links below:

Hope to see you there!

Published Thursday, January 30, 2014 1:03 PM by Adam Machanic

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 RSS

Comments

 

Israr Haq said:

Adam, not in that area so will miss the excellent opportunity to attend. However, we have not seen any updates to the whoisactive? Any plans on working on it with new versions out? THanks

February 5, 2014 11:37 AM
 

Adam Machanic said:

@Israr

Working on it :-)

February 6, 2014 10:03 AM
 

Jason said:

Hi Adam, just got field-promoted to DBA and looking to get some quick training, (more extensive DBA fundamentals will have to wait), mostly around performance tuning.

Seems to me this course _could_ be helpful, however not having a background I'm not sure if it would apply to my environment. Production running SQL Server 2008 on Win2008 R2 w/ SP1, dual Xeon processors w/ 64GB memory. Am I really going to get a lot out of parallelism? Does SQL Server 2008 even support it?

Thanks,

J

February 26, 2014 3:30 PM
 

Adam Machanic said:

Hi Jason,

The content applies all the way back to SQL Server 2000 in some cases, 2005 in most cases, and 100% to 2008 and above. So no worries there.

More important is the question of what KIND of workload you're supporting. Is it more of a transaction processing or decision support (reporting) workload? In other words: Is the workload characterized by lots and lots of very small reads and writes? Or are there queries that read thousands of rows (or more) in one pass? Or are there both? (That's called a hybrid workload.) If you're in either of the second two groups the course is likely to offer you some insight (although you should be ready with coffee -- it may be a bit advanced for where you are at the moment). If you're in the transaction processing group, there's also some information for you, but that's not really the core target audience.

Hope that helps -- let me know!

--Adam

February 26, 2014 7:24 PM
 

Jason said:

Thanks for getting back to me, we have a hybrid environment where there's a ton of transactional processing going on, but there's also some big reports that are run on that data.. we're just beginning a fairly substantial BI project, so it sounds like this could be of some benefit.

If I can arrange it, I'll be there! (with coffee as advised ;))

J

February 27, 2014 9:50 AM
 

Farhan said:

Hi Adam,

What is the capacity of the class? How much it is filled?

Thanks

March 6, 2014 11:27 AM
 

Adam Machanic said:

@Farhan

Capacity for each is around 40 (slightly larger for Boston). Both still have some seats available at the moment.

--Adam

March 6, 2014 3:44 PM
 

Seshi said:

Hi Adam,

Can you please offer some online training and I would like to attend the same. I love your sessions and saw some in SQL pass recording sessions.

Thanks

Seshi

April 11, 2014 12:04 PM
 

Adam Machanic said:

@Seshi

Thanks for getting in touch. I will certainly keep your request in mind as I plan future offerings!

--Adam

April 11, 2014 2:13 PM

Leave a Comment

(required) 
(required) 
Submit

About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. 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 "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement