System Configuration Archives - Page 5 of 6

Attention users running SQL Server 2008 and SQL Server 2008 R2

Aaron Bertrand (@AaronBertrand) of SQL Sentry points out a recent swapping out of cumulative updates for SQL Server 2008 and SQL Server 2008 R2.

Aaron Bertrand ◆ June 17, 2013

7

SQL Server Standard Edition High Availability Futures

Glenn Berry (@GlennAlanBerry) of SQLskills.com discusses all of the recent hoopla about Database Mirroring being deprecated and what that may mean for Standard Edition customers 6-10 years from now.

Glenn Berry ◆ June 11, 2013

2

Troubleshooting SQL Server CPU Performance Issues

Joe Sack (@josephsack) of SQLskills.com outlines his approach to troubleshooting CPU performance issues in SQL Server.

Joe Sack ◆ May 28, 2013

4

Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes

Aaron Bertrand (@AaronBertrand) discusses some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped him isolate and solve the issues.

Aaron Bertrand ◆ April 25, 2013

6

Making the Case for Regular SQL Server Servicing

Glenn Berry (@GlennAlanBerry) of SQLskills.com gives some pretty strong arguments for keeping your SQL Server instances current on both Service Packs and Cumulative Updates.

Glenn Berry ◆ March 28, 2013

7

Performance-related fixes for SQL Server 2012

In an effort to encourage you to keep your SQL Server 2012 instances up to date, I wanted to highlight a slew of performance-related fixes that are mostly available only through Service Pack 1 or various Cumulative Update packages.

Aaron Bertrand ◆ March 19, 2013

1

Break large delete operations into chunks

Aaron Bertrand (@AaronBertrand) discusses ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.

Aaron Bertrand ◆ March 13, 2013

48

Transaction Log Configuration Issues

Paul Randal of SQLskills continues his series on maintaining happy and healthy transaction logs in SQL Server, this time focusing on configuration issues that can lead to less than optimal performance.

Paul Randal ◆ February 22, 2013

8

Potential enhancements to ASPState

Many people have implemented ASPState in their environment. Some people use the in-memory option (InProc), but usually I see the database option being used. There are some potential inefficiencies here that you might not notice on low volume sites but that will start to affect performance as your web volume ramps up.

Aaron Bertrand ◆ January 11, 2013

14

Selecting a Processor for SQL Server 2012

Since Microsoft revamped the licensing model for SQL Server 2012, it is especially important to do some thoughtful analysis before you decide exactly which processor to use for a database server that will be running SQL Server 2012. The move to core-based licensing for SQL Server 2012 Enterprise Edition means that a careless decision about precisely what processor you will be running on can cost both a great deal of money and a great deal of performance and scalability.

Glenn Berry ◆ January 9, 2013

22

Trimming the Transaction Log Fat

In many SQL Server workloads, especially OLTP, the database’s transaction log can be a bottleneck that adds to the time it takes a transaction to complete. Most people assume that the I/O subsystem is the real bottleneck, with it not being able to keep up with the amount of transaction log being generated by the workload.

Paul Randal ◆ December 17, 2012

11