My fifth guest blog post was published today on SQLPerformance.com: Troubleshooting SQL Server CPU Performance Issues In this post I describe the general framework you can use to perform root cause analysis for high CPU or CPU-related performance issues.
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
SQLPerformance.com “Troubleshooting SQL Server CPU Performance Issues”
Posted on: May 28, 2013 5:15 am
New Course: “SQL Server 2012: Nonclustered Columnstore Indexes”
Posted on: May 9, 2013 8:25 am
Yesterday Pluralsight published my new course, “SQL Server 2012: Nonclustered Columnstore Indexes”. The intent behind this course was to provide a fast ramp-up on the aspects of this feature that you should consider when looking at whether or not this is a viable option for your SQL Server relational data warehouse workloads. The course covers […]
Exploring Columnstore Index Batch Sizes
Posted on: May 5, 2013 4:52 am
In this blog post we’ll explore columnstore index batch execution mode limits. I’m using SQL Server 2012 Developer Edition, version 11.0.3349 (SP1, CU3). To start off with, I’ll create a table that uses six different supported nonclustered columnstore index data types: I’ll populate this table with 1,048,576 rows, all using the same value for each […]
