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

Archives: February 2010

Rocky Mountain Tech Trifecta Impressions

I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack did a great job of organizing the free event, which had nearly 700 registrations. There were a lot of sponsors, so there was plenty of food (including breakfast, lunch and… Read more

1 comments, 629 reads

Posted in Glenn Berry's SQL Server Performance on 28 February 2010

Weekly Electrical Usage from Google PowerMeter

Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about the environment, I installed a TED 5000 and connected it to Google PowerMeter about six weeks ago. Every week, Google sends out an email that summarizes your power usage… Read more

2 comments, 628 reads

Posted in Glenn Berry's SQL Server Performance on 28 February 2010

Dr. DMV Script for Rocky Mountain Tech Trifecta

Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky Mountain Tech Trifecta on February 27.

-- SQL Server 2008 and R2 Diagnostic Information Queries
-- Glenn Berry 
-- February 26, 2010
-- http://glennberrysqlperformance.spaces.live.com/
-- Twitter: GlennAlanBerry

-- Instance level…

Read more

2 comments, 1,232 reads

Posted in Glenn Berry's SQL Server Performance on 26 February 2010

Upcoming Speaking Event Schedule

I have a fairly busy schedule of upcoming speaking events (especially for someone with a full-time day job).

I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads presentation at the Rocky Mountain Tech Trifecta event… Read more

0 comments, 332 reads

Posted in Glenn Berry's SQL Server Performance on 24 February 2010

Power Plans and Windows Server 2008 R2

After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL Server 2008 running on x64 Windows Server 2008 when using the default “Balanced” power plan compared to the “High performance” power plan (in Windows), I decided to do some investigation… Read more

0 comments, 1,921 reads

Posted in Glenn Berry's SQL Server Performance on 22 February 2010

Experiments with Data Compression in SQL Server 2008

Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use either Page or Row compression on the clustered index or any non-clustered indexes on a table. Data compression lets SQL Server trade off disk space and I/O pressure for some… Read more

5 comments, 1,121 reads

Posted in Glenn Berry's SQL Server Performance on 22 February 2010

New iSCSI Performance Benchmark from Microsoft and Intel

The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware and Microsoft Windows Server 2008 R2 software in January of 2010. Running on server hardware equipped with an Intel Xeon 5580 CPU and an Intel 82599 10GbE network interface card… Read more

0 comments, 424 reads

Posted in Glenn Berry's SQL Server Performance on 21 February 2010

Testing New Features in SQL Azure Service Update 1

It seems to be SQL Azure night for me tonight…  I thought I would try out some of the new features in SQL Azure Service Update 1. First I tried ALTER DATABASE to switch between the Web Edition and Business Edition size for a SQL Azure database. I discovered… Read more

0 comments, 281 reads

Posted in Glenn Berry's SQL Server Performance on 19 February 2010

Playing With SQL Azure Data Synch

Microsoft has provided a free tool that allows you to easily create a SQL Azure database, and then synchronize the data periodically (on a table by table basis) with an on-premises SQL Server database. You could use this to do an initial data load to SQL Azure, or to keep… Read more

5 comments, 703 reads

Posted in Glenn Berry's SQL Server Performance on 19 February 2010

SQL Azure Database Service Update 1 Released on February 17

Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL Azure. This update has four main changes:

First, they have enabled  six Dynamic Management Views (DMVs), which will allow you to have a little more insight into what is going… Read more

0 comments, 244 reads

Posted in Glenn Berry's SQL Server Performance on 19 February 2010

Cumulative Update Package 8 for SQL Server 2005 Service Pack 3

Microsoft has released CU8 for SQL Server 2005 SP3, which you can get here. This is Build 4285. This CU has five listed fixes, including two for database mirroring. Interestingly, there does not seem to be a “matching” CU for SQL Server 2005 SP2 (which is fine with… Read more

3 comments, 233 reads

Posted in Glenn Berry's SQL Server Performance on 18 February 2010

Mirroring a Large Number of Databases in a Single SQL Server Instance

Microsoft SQLCAT team members Sanjay Mishra and Prem Mehra have published a new Technical Note called Mirroring a Large Number of Databases in a Single SQL Server Instance on the SQLCAT web site. This paper explores what happens to performance as you mirror more and more user databases on a… Read more

2 comments, 433 reads

Posted in Glenn Berry's SQL Server Performance on 17 February 2010

MVP Summit Impressions From Day 1

Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side sessions” with content that I cannot discuss (not because anything secret was discussed), but because Microsoft is really cracking down on possible NDA violations, so the guidance is not to… Read more

2 comments, 241 reads

Posted in Glenn Berry's SQL Server Performance on 17 February 2010

Presenting in Colorado Springs on May 19, 2010

I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be doing my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads presentation, using SQL Server 2008 R2, which should be… Read more

1 comments, 304 reads

Posted in Glenn Berry's SQL Server Performance on 16 February 2010

SQL Server 2005/2008 Servicing Plans

Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is a good blog to subscribe to in your favorite RSS reader) regarding Microsoft’s plans for releasing both SQL Server 2005 SP4 and SQL Server 2008 SP2 during CY2010.

SQL Server… Read more

1 comments, 261 reads

Posted in Glenn Berry's SQL Server Performance on 13 February 2010

Round Two of Insert Benchmark Tests

After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw some hardware” at the problem, and cheat by using SQL Server data compression. I increased the physical RAM from 6GB to 8GB (which is as high as I can go… Read more

1 comments, 223 reads

Posted in Glenn Berry's SQL Server Performance on 9 February 2010

Some Initial Insert Test Benchmarks on SQL Server 2008 R2

They say that imitation is the sincerest form of flattery. I have been following along as Paul Randal has been doing a series of blogs illustrating some benchmarks on a collection of actual server hardware he has at his house. Unfortunately, I don’t have any server class hardware to play… Read more

0 comments, 1,416 reads

Posted in Glenn Berry's SQL Server Performance on 7 February 2010

Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008

I had a little bit of excitement with one of my production servers couple of days ago, that I thought I would document (especially since it turned out well in the end).  I have a little VB.NET WinForms application that calls a series of DMV stored procedures on the production… Read more

1 comments, 1,363 reads

Posted in Glenn Berry's SQL Server Performance on 4 February 2010

Three Engine Improvements in SQL Server 2008 R2

The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area to support the upcoming releases of Office 2010 and SharePoint 2010. This left precious little development resources to devote to improvements to the basic relational database engine in… Read more

1 comments, 413 reads

Posted in Glenn Berry's SQL Server Performance on 2 February 2010

Older posts