Browse by Tags

Blog Post: How It Works: sp_server_diagnostics – spinlock backoffs

SQL Server Support Content

There are numerous articles outlining how spinlocks work so I won’t cover the details in this post. Instead, I want to focus on the spinlockbackoffs value recorded in the sp_server_diagnostics output. Component = System <system spinlockBackoffs ...read more

on 12 Dec 2014
Blog Post: A faster CHECKDB – Part III

SQL Server Support Content

Bob Ward introduced Part 1 and Part 2 of ‘A faster CHECKDB’ as highlighted in the following links. Part 1: http://blogs.msdn.com/b/psssql/archive/2011/12/20/a-faster-checkdb-part-i.aspx Part 2: http://blogs.msdn.com/b/psssql/archive/2012/02/23 ...read more

on 10 Nov 2014
Blog Post: SQL Server MAX DOP Beyond 64 – Is That Possible?

SQL Server Support Content

I recently posted a blog outlining how the partitions of a table can be used in the calculation for the achievable max degree of parallelism (MAX DOP). http://blogs.msdn.com/b/psssql/archive/2014/09/04/a-partitioned-table-may-limit-the-runtime-max-dop ...read more

on 30 Oct 2014
Blog Post: A Partitioned Table May Limit the Runtime MAX DOP of Create/Alter Index

SQL Server Support Content

I was working with a 1.3 trillion row table in the Microsoft lab when I learned more about the ins and outs of this behavior. This issue is alluded to in SQL Server Books Online but allow me to expand on the behavior a bit more. ( http://msdn.microsoft ...read more

on 4 Sep 2014
Blog Post: How It Works: XEvent Output and Visualization

SQL Server Support Content

Each and every day I use XEvent more and more as I uncover the powerful feature set. I am finding it helpful to understand some of the input and output capabilities in order to leverage the power of XEvent. Server File Output When setting ...read more

on 25 Jul 2014
Blog Post: Capping CPU using Resource Governor – The Concurrency Mathematics

SQL Server Support Content

Here is what you need to know: A = πr 2 Okay, not really as that is the formula for the area of a circle but it does set the stage for this discussion. I have been working with the CAP_CPU_PERCENT (RESOURCE POOL) setting as it relates to concurrency ...read more

on 21 May 2014
Blog Post: How It Works: Behavior of a 1 Trillion Row Index Build (Gather Streams from SORT)

SQL Server Support Content

I ran into this behavior working on a 1 trillion row, spatial index build but the behavior can apply to any Gather Streams operator, retaining the sort order as rows pass though it. I was just surprised a bit by the behavior until I dug deeper ...read more

on 29 Apr 2014
Blog Post: Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center

SQL Server Support Content

X64 : http://download.microsoft.com/download/0/a/4/0a41538e-2d57-40ff-ae85-ec4459f7cdaa/RMLSetup_AMD64.msi X86 : http://download.microsoft.com/download/4/6/a/46a3217e-f523-4cc6-96e9 ...read more

on 24 Apr 2014
Blog Post: SQL Server 2014: TEMPDB Hidden Performance Gem

SQL Server Support Content

I ran across a change for TEMPDB BULK OPERATIONS (Select into, table valued parameters (TVP), create index with SORT IN TEMPDB, …) that you will benefit from. For example, I have a Create Index … WITH SORT IN TEMPDB that takes ~1 minute in SQL Server ...read more

on 9 Apr 2014
Blog Post: SQL Server 2014’s new cardinality estimator (Part 1)

SQL Server Support Content

One of the performance improvement in SQL Server 2014 is the redesign of cardinality estimation. The component which does cardinality estimation (CE) is called cardinality estimator. It is the essential component of SQL query processor for query plan ...read more

on 1 Apr 2014

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

Blog Post: How It Works: sp_server_diagnostics – spinlock backoffs

Blog Post: A faster CHECKDB – Part III

Blog Post: SQL Server MAX DOP Beyond 64 – Is That Possible?

Blog Post: A Partitioned Table May Limit the Runtime MAX DOP of Create/Alter Index

Blog Post: How It Works: XEvent Output and Visualization

Blog Post: Capping CPU using Resource Governor – The Concurrency Mathematics

Blog Post: How It Works: Behavior of a 1 Trillion Row Index Build (Gather Streams from SORT)

Blog Post: Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center

Blog Post: SQL Server 2014: TEMPDB Hidden Performance Gem

Blog Post: SQL Server 2014’s new cardinality estimator (Part 1)