Skip to content
  • About
  • Courses
  • Contact

Month: May 2015

Using The Right Tool For Right Job: XPERF Flags and Diagnosing Difficult IO Issues

  • by datatake
  • Posted on May 29, 2015July 9, 2015
  • Uncategorized

At the end of the session I presented at the recent SQL Saturday in Portugal I had a chat with one of the attendees who mentioned that good xperf documentation is sparse and the question was posed: […]

Read More

Under The Hood Of The Batch Engine: NUMA Support Part 2

  • by datatake
  • Posted on May 25, 2015July 9, 2015
  • Uncategorized

In this post I would like to dig deeper into the NUMA awareness of the SQL Server batch engine. Firstly, can we infer anything from the SQL OS method calls with ‘NUMA’ in their name, […]

Read More

Batch Mode Sorted Hash, CPU Last Level Cache Misses and The NUMA Boundary

  • by datatake
  • Posted on May 18, 2015July 9, 2015
  • Uncategorized

In a session I have presented both at SQL Konferenz in Germany and the recent SQL Saturday in Portugal, I cover CPU architectures and memory at level 400. As a ‘Hook’ with which to pique […]

Read More

Under The Hood Of The Batch Engine: NUMA Support Part 1

  • by datatake
  • Posted on May 7, 2015July 9, 2015
  • Uncategorized

There has been some recent discussion around whether the SQL Server batch engine is NUMA aware and does it support large pages, as I have been looking under the covers of this recently, I thought […]

Read More

SQL Server, Hyper-Threading and Batch Mode

  • by datatake
  • Posted on May 7, 2015July 9, 2015
  • Uncategorized

According to general SQL Server ‘Lore’, hyper-threading works well for OLTP workloads and not so well for OLAP style workloads, but does this hold true for the batch engine ?, there is only one way […]

Read More

Archives

  • April 2022
  • March 2022
  • February 2022
  • April 2021
  • March 2021
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • September 2019
  • April 2019
  • February 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • June 2018
  • March 2018
  • January 2018
  • December 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • April 2017
  • July 2016
  • May 2016
  • April 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • October 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • December 2013
  • June 2013

Meta

  • Register
  • Log in
Blog at WordPress.com.
  • Follow Following
    • chrisadkin.io
    • Join 45 other followers
    • Already have a WordPress.com account? Log in now.
    • chrisadkin.io
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...