THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Performance » Parallelism   (RSS)
  • Next-Level Parallel Plan Forcing: An Alternative to 8649

    ''Even experts with decades of SQL Server experience and detailed internal knowledge will want to be careful with this trace flag.  I cannot recommend you use it directly in production unless advised by Microsoft, but you might like to use it on a test system as an extreme last resort, perhaps to generate a plan guide or USE PLAN hint for ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 11, 2013
  • Parallel Execution Plans Suck

    Summary: A deep dive into SQL Server parallelism, and a potential performance problem with parallel plans that use TOP. There was an interesting question asked by Mark Storey-Smith on dba.stackexchange.com back in October 2011.  He was looking at the execution plan for a query that counts a million rows from a virtual auxiliary table of ...
    Posted to Page Free Space (Weblog) by Paul White on May 2, 2012
  • SQL Saturday 89 - Atlanta GA - Materials

    Last Saturday, September 17, I was lucky to be able to present two sessions at an excellent SQL Saturday in the Atlanta area. The day drew a large crowd and had a great speaker lineup. All in all, a huge success, and a very well-managed event. Congratulations to the organizers! One of the highlights for me, aside from speaking, was helping out ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on September 24, 2011
  • Performance, Discounts, and an Excuse to Visit New York City

    A couple of weeks ago I announced a two-day advanced performance seminar in New York City, which will be delivered in July. This seminar will cover SQLCLR and parallelism techniques to help you take performance well beyond the levels that typical tuning exercises yield. Check out the links for more details, including a full outline. Thanks to the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 2, 2011
  • Two Days of Advanced Performance Techniques - July 14-15, New York City

    I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15. This seminar focuses on achieving ''next-level'' performance--going beyond that which you can gain via normal tuning methodologies. The vehicles for this performance improvement are two technologies that I've been pushing on this blog and in ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 18, 2011
  • White Paper on Parallel Processing

      I just ran across what I think is a newly published white paper on parallel  processing in SQL Server 2008 R2. The date is October 2010 but this is the first time I have seen it so I am not 100% sure how new it really is. Maybe you have seen it already but if not I recommend taking a look. So far I haven’t had time to read it ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 10, 2010
  • PASS Summit 2010 Post-Conference Seminar on Parallel Processing

    I am honored to have been selected for a second year in a row to present a full-day seminar at the PASS Summit. This year's seminar will be a ''post-con'', and will be delivered on Friday, November 12. The title of the seminar is ''A Day of Doing Many Things at Once: Multitasking, Parallelism, and Process Distribution,'' and the focus is on ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 4, 2010
  • PASS Performance Virtual Chapter: Parallelize Your Queries!

    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 ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 2, 2010
Privacy Statement