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 » parallelism   (RSS)
Showing page 2 of 2 (18 total posts)
  • SQL Sentry Plan Explorer : Version 1.1!

    Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4.  This week, it's SQL Sentry's turn to play Santa Claus: several new features and fixes have been packaged up into SQL Sentry Plan Explorer 1.1 (build 6.0.67.0). So, what's new?  Several wish list items have been fulfilled (hey, it is Christmas, after ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 22, 2010
  • 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
  • Myth: SQL Server Caches a Serial Plan with every Parallel Plan

    Many people believe that whenever SQL Server creates an execution plan that uses parallelism, an alternative serial plan is also cached.  The idea seems to be that the execution engine then decides between the parallel and serial alternatives at runtime. I’ve seen this on forums, in blogs, and even in books.  In fairness, a lot of the ...
    Posted to Page Free Space (Weblog) by Paul White on November 4, 2010
  • So when is Parallel SQL arriving? Denali?

    For some time, Intel C/C++ compilers addons had the ability to automaticly generate parallel code (as in the coder does not have to do it). I also recall hearing some thing about Parallel LINQ, but thats outside the scope of my narrow view of the world. I was just browsing a Sybase script (for the TPC-H benchmark) and notice the following, which ...
    Posted to Joe Chang (Weblog) by jchang on October 4, 2010
  • SQL University: Parallelism Week - Part 3, Settings and Options

    Congratulations! You've made it back for the the third and final installment of Parallelism Week here at SQL University. So far we've covered the fundamentals of multitasking vs. parallel processing and delved into how parallel query plans actually work. Today we'll take a look at the settings and options that influence intra-query parallelism ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 28, 2010
  • SQL University: Parallelism Week - Part 2, Query Processing

    Welcome back for the second part of Parallelism Week here at SQL University. Get your pencils ready, and make sure to raise your hand if you have a question. Last time we covered the necessary background material to help you understand how the SQL Server Operating System schedules its many active threads, and the differences between its ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 26, 2010
  • SQL University: Parallelism Week - Introduction

    Welcome to Parallelism Week at SQL University. My name is Adam Machanic, and I'm your professor. Imagine having 8 brains, or 16, or 32. Imagine being able to break up complex thoughts and distribute them across your many brains, so that you could solve problems faster. Now quit imagining that, because you're human and you're stuck with only one ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 24, 2010
  • Six reasons you should be nervous about parallelism

    Don't get me wrong; parallel processing is great.  And with SQL Server in particular, there are many benefits to taking advantage of the power of multiple CPUs.  However, we have all had cases where what looked like parallelism was actually hurting us (you remember turning off hyperthreading on SQL Server boxes, right?), and cases ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 21, 2009
Privacy Statement