Archives: February 2010
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
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
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…
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
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
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
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
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
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
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
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
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
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
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
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
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
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 on February 27, 2010 at Metro State College in downtown Denver.
This is a free all-day event,… Read more
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
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
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