1. Home
  2. Data Center
  3. Black Holes – Casting shadows on SQL Server Parallelism

Black Holes – Casting shadows on SQL Server Parallelism

0
0

For any of you who’ve struggled trying to tweak degrees of parallelism (DoP) and affinity masks in multi-core SQL Servers to chop down query times, I have some good news and some bad news.

The bad news first: your well-intentioned attempts are being defeated by an insidious collection of choke points outside of your control that afflict I/O-intensive workloads, OLTP in particular. The good news: these choke points have recently been isolated.

Seasoned practitioners may be thinking, “nothing novel here, we’ve known storage to be the culprit for years.” And while that’s one sure place to look, that’s not where I’m going with this.

Read the entire article here, Black Holes – Casting shadows on SQL Server Parallelism

Via the fine folks at DataCore Software.

Categories:
DataCore DataCore, the Data Infrastructure Software company, is the leading provider of Software-Defined Storage and Adaptive Parallel I/O Software – harnessing today’s powerful and cost-efficient server platforms with Parallel I/O to overcome the IT industry’s biggest problem, the I/O bottleneck, in order to deliver unsurpassed performance, hyper-consolidation efficiencies and cost savings. The company’s comprehensive and flexible storage virtualization and hyper-converged virtual SAN solutions free users from the pain of labor-intensive storage management and provide true independence from solutions that cannot offer a hardware agnostic architecture. DataCore's Software-Defined and Parallel I/O powered platforms revolutionize data infrastructure and serve as the cornerstone of the next-generation, software-defined data center – delivering greater value, industry-best performance, availability and simplicity.

Featured Resources:

Related Articles:

| LATEST FEATURED RESOURCES

White Papers

‘All You Need to Know About Microsoft Windows Nano Server’ Veeam White Paper

Now updated for Windows Server 2016 GA release! You probably heard about Windows Nano Server already … but what is it exactly, and how do you get started with it? What value will it bring to your environment? Nano Server is a headless, 64-bit only deployment option for Windows Server 2016. Microsoft created this component specifically with […]

Downloads

Download Commvault VM Backup and Recovery: end-to-end VM backup, recovery and cloud management

Commvault’s ability to provide end-to-end VM backup, recovery and cloud management creates a significantly better way to build, protect and optimize VMs throughout their lifecycle. Our best-in-class software for VM backup, recovery and cloud management delivers a number of significant benefits, including: VM recovery with live recovery options; backup to and in the cloud; custom-fit […]

On-Demand Webinars

Architecting for today’s desktop environments – FSLogix On-Demand Webinar

October 19, 2017 Webinar with David Young, Solutions Architect and Product Champion, and Brandon Lee, Solutions Marketer. Video Recording of a live demo of FSLogix and an overview of the latest release of FSLogix Apps featuring Roaming XenApp Email Search and OneDrive App along with Skype for Business Global Address List and Device Based Licensing. […]

Latest Videos

Current State of EUC – E2EVC Video

Session from @E2EVC 2017 Orlando. For event information please visit www.e2evc.com/home. For slides, additional info etc please contact the presenter directly on Twitter. For best video and sound quality do visit the event! This video is from the fine folks at E2EVC Conference

Views All IT News on DABCC.com
Views All IT Videos on DABCC.com
Win a Tesla P100D

Visit Our Sponsors