Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2011

SQL Server Hardware Choices Made Easy

Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a compilation of the month long series I wrote in April 2011, called A SQL Server Hardware Nugget A Day, along with additional content from my SQL Server Hardware Read more

2 comments, 1,264 reads

Posted in Glenn Berry's SQL Server Performance on 29 August 2011

New Dell Precision M4600 Mobile Workstation

After a very long wait, I finally received my new company laptop this past week, which is a very fast Dell Precision M4600. This particular unit has the 2.3GHz Core i7-2820QM quad-core processor, with 8MB of L3 cache. It uses Turbo Boost 2.0 to increase the clock speed to… Read more

1 comments, 815 reads

Posted in Glenn Berry's SQL Server Performance on 28 August 2011

A Couple of Data Compression Tricks in SQL Server 2008

As I have said several times before, I am a big fan of data compression in SQL Server 2008 and above. Data compression is an Enterprise Edition only feature that was added to SQL Server 2008, and enhanced with Unicode compression in SQL Server 2008 R2.

It can be very… Read more

1 comments, 1,381 reads

Posted in Glenn Berry's SQL Server Performance on 23 August 2011

SQL Server 2008 R2 RTM Cumulative Update 9

Microsoft has released Cumulative Update 9 for SQL Server 2008 R2 RTM, which is Build 10.50.1804.0. I count 26 fixes in this Cumulative Update, which is for the RTM branch of SQL Server 2008 R2. Remember, this is completely separate from SQL Server 2008 SP2, which is the previous… Read more

0 comments, 1,121 reads

Posted in Glenn Berry's SQL Server Performance on 19 August 2011

SQL Server 2008 R2 SP1 Cumulative Update 2

Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in the KB for this Cumulative Update. The most interesting one in my opinion is: FIX: Recovery takes longer than expected for a database in a SQL Server 2008 or… Read more

0 comments, 897 reads

Posted in Glenn Berry's SQL Server Performance on 16 August 2011

Gradually Deleting Data in SQL Server

If you have a situation where you have a very large table in SQL Server, where you need to periodically delete tens of millions of rows of data, there are several ways to do it.

If you have a maintenance window (or your database is not required to be available… Read more

1 comments, 809 reads

Posted in Glenn Berry's SQL Server Performance on 13 August 2011

Configuring, Benchmarking and Validating an I/O Subsystem for SQL Server, Part 1

One of the main projects I have been working on lately is designing and implementing a completely new data and storage infrastructure for a high volume, 24×7 online environment. Some of the goals of this effort include improving OLTP performance, improving scalability, reducing the number of SQL Server processor licenses… Read more

1 comments, 942 reads

Posted in Glenn Berry's SQL Server Performance on 12 August 2011

Microsoft SQL Server Denali CTP 3 Product Guide

Microsoft has released a Product Guide for SQL Server Denali CTP3, which has datasheets, white papers, technical presentations, demonstrations, and links to videos that will help you evaluate Microsoft SQL Server Denali. You can get to Books Online for SQL Server Denali CTP3 here. There is also… Read more

0 comments, 717 reads

Posted in Glenn Berry's SQL Server Performance on 12 August 2011

Corsair 16GB Flash Voyager GT USB 3.0 Review

I bought a little Corsair Flash Voyager USB 3.0 16GB USB Flash Drive at Micro Center yesterday, since most of my machines now have USB 3.0 ports. It is also available online from places like New Egg and Amazon

For roughly $25.00 you can hardly go wrong here. One negative… Read more

0 comments, 1,171 reads

Posted in Glenn Berry's SQL Server Performance on 11 August 2011

Two New TPC-E Submissions

Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three recent submissions back on June 15. The TPC-E benchmark is a very useful comparison and sizing tool for OLTP workloads. Assuming you have enough I/O performance to drive the… Read more

0 comments, 533 reads

Posted in Glenn Berry's SQL Server Performance on 5 August 2011

Presenting Hardware 301 at 24 Hours of PASS on September 7

PASS just announced today the next occurrence of 24 Hours of PASS (24HOP), which is called the Summit Preview version. I will be doing a session called Hardware 301: Diving Deeper into Database Hardware at 21:00 (9PM) GMT, which is 5PM Eastern US and 2PM Western US time on… Read more

0 comments, 322 reads

Posted in Glenn Berry's SQL Server Performance on 3 August 2011

August 2011 SQL Server 2008 Instance Level Diagnostic Queries

Since it is August 1, 2011 (which is also my birthday), I thought it would be a good time to unveil a completely new set of Diagnostic queries that focus completely on SQL Server instance level metrics.

My previous DMV Diagnostic Queries are split between a number of instance level… Read more

4 comments, 645 reads

Posted in Glenn Berry's SQL Server Performance on 1 August 2011