Browse by Tags

• Automation
• Batch Size
• Benchmark
• bug
• Data Load
• HT
• hyperthreading
• Multi-threading
• NUMA
• NUMA affinity
• Performance
• port affinity
• Query Processing
• Replication
• Reporting queries
• SqlBulkCopy

• 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 Read More... Posted Saturday, January 28, 2012 1:32 AM by Linchi Shea | 6 Comments Filed under: bug, NUMA, NUMA affinity, parallelism, port affinity

• 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 Read More... Posted Thursday, January 05, 2012 1:36 AM by Linchi Shea | 16 Comments Filed under: Benchmark, HT, hyperthreading, parallelism, Performance, Reporting queries Attachment(s): create_tables_load_data.zip

• 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 Read More... Posted Friday, December 16, 2011 1:24 PM by Linchi Shea | 25 Comments Filed under: parallelism, Performance, Query Processing Attachment(s): Execution_plan_dop_48.zip

• Why is it good to be comfortable with multi-threading?

  If you are an application developer, you should find a new job if you can't do multu-threaded programming. What if you are a DBA? Probably not, not to the same extent anyway. Some in our community clearly realize the importance of being able to do things Read More... Posted Friday, July 08, 2011 1:19 PM by Linchi Shea | 1 Comments Filed under: Automation, Multi-threading, parallelism, Replication

• 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 Read More... Posted Friday, July 01, 2011 12:54 PM by Linchi Shea | 4 Comments Filed under: Batch Size, Data Load, Multi-threading, parallelism, Performance, SqlBulkCopy

• Parallelism beyond T-SQL

  People can do amazing things with T-SQL alone even when it may not be the best language to use. For instance, T-SQL was never designed or intended as a language to manage running multiple queries concurrently or running queries asynchronously. But I have Read More... Posted Monday, August 02, 2010 10:28 AM by Linchi Shea | 12 Comments Filed under: Multi-threading, parallelism, Performance