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)
Showing page 1 of 2 (12 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
  • 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
  • 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
  • Performance impact: diminishing marginal return on the degree of parallelism

    In commenting on my previous post, Greg Linwood and GrumpyOldDBA raised questions about various implications of parallelism. In this post, I’ll look at the impact of different degrees of parallelism on the query performance. I’ll limit my examination on the same query that uses a Cartesian product temp table, as discussed in the previous two posts ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 16, 2011
  • 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 impact: What is the optimal payload for SqlBulkCopy.WriteToServer()?

    For many years, I have been using a C# program to generate the TPC-C compliant data for testing. The program relies on the SqlBulkCopy class to load the data generated as per the TPC-C specifications into the SQL Server tables. In general, the performance of this C# data loader is satisfactory. Lately however, I found myself in a situation ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 1, 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement