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 1 of 4 (34 total posts)
  • 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
  • Did You Know? What settings to always change

      A week ago, I taught my SQL Server 2012 Internals class to a great group of very interactive students. Even though a dozen of them were taking the class remotely, there were still lots of really great questions and and lots of discussion. One of the students asked if I could summarize all the settings that I recommended changing from the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 25, 2013
  • More Fun in Atlanta: Parallelism at SQL Saturday 220

    May 18, SQL Saturday returns yet again to the Atlanta area. At this point I've become a bit of a regular at Atlanta's events; this will be my third one in a row. The team that puts them together is amazing, and produces top quality, super fun and educational days every time. Plus: Taco Mac. Friday, May 17, the event is running a few ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 25, 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 Paul White: Page Free Space (Weblog) by Paul White on May 2, 2012
  • SQL Saturday 111: Manhandling Parallelism - Demos

    Another year, another fantastic Atlanta SQL Saturday. Hats off to the team that created the event for delivering a top notch day for the attendees. Thanks to everyone who attended my ''Query Tuning Mastery: The Art and Science of Manhandling Parallelism'' session. Demos are attached. Enjoy, and I'll see you at the next one!
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 15, 2012
  • SQLbits London 2012 - Demos

    Thanks to everyone who attended my sessions last Friday and Saturday at SQLbits! It was great to meet many new people, not to mention spending some time exploring one of my favorite cities, London. Attached are the demos for each of the two talks I delivered: Query Tuning Mastery: The Art of and Science of Manhandling ParallelismAs a database ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 3, 2012
  • Connect Digest : 2012-03-06

    This time around, I've got five wish list items for T-SQL / DDL, and then one bonus - a parallelism bug. My thinking on the former is that, since we are either about to start (or are just finishing) locking down the code for SQL Server 2012, this is the first moment where some of these suggestions can be seriously considered without the ''but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 6, 2012
  • No respect: NUMA affinity meets query parallelism

    What happens when NUMA affinity meets query parallelism? It gets no respect! SQL Server allows you to affinitize a TCP port to a specific NUMA node or a group of NUMA nodes. Books Online has an article on How to: Map TCP/IP ports to NUMA Nodes. And this BOL article discusses various NUMA affinity scenarios. Recently, I have been playing with ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 28, 2012
  • Connect Digest : 2012-01-09

    Hide databases from users who shouldn't be able to see them This is a long-standing request from Erland Sommarskog which I've highlighted in previous digests. But the underlying problem keeps coming up in multiple venues, so I thought it would be good to call attention to the item one more time. Some will argue that the contained database feature ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 9, 2012
  • Performance impact: hyperthreading for reporting queries

    There are a lot of questions on hyperthreading, but not a lot of answers.  There is no shortage of opinions, but very few are based on significant first hand experience or solid test data. We know that the hyperthreading technology in the older generations of the Intel processors was not well received by the SQL Server community. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 5, 2012
1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement