Black Holes – Casting shadows on SQL Server Parallelism
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.
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 […]
Share this:
‘The Citrix Administrator’s Guide to Citrix ICA/HDX’ White Paper
‘The Technical Guide to Migrating from Citrix 6.5 to 7.x and Replacing EdgeSight’ White Paper
Complete Guide to Understanding the Citrix Logon Process
‘Securing IGEL OS Endpoints’ White Paper
‘Managing Java Application Performance in a Citrix Environment’ White Paper