While I have always known that the Windows operating system Power Plan options affect a server’s performance, I had not realized how much until SQL Server MVP Glenn Berry (Blog | Twitter) suggested I try out my new Dell T610 test servers under the three available power savings plans:
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see the end of this posting for a description), I created a new 50GB database. The database creation process took about 5 minutes and 50 seconds to complete.
The SQL Server DMV Starter Pack is a free eBook (84 pages) that describes 28 different ways that DMVs can be used with SQL Server. Not only is each way described in detail, but sample code is included so you can begin using the DMVs immediately. The book covers these uses of DMVs.
Red Gate Software has recently opened up its SQL Response v2 Early Release Program (EAP), and is inviting anyone who is interested to download the application, test it, and provide feedback. This is your opportunity to help SQL Response’s developers to create a great product that every DBA will want to use.
I finally received all the components of my SQL Server test cluster (pictured left), which includes:
–One PowerVault MD3000 DAS with two, dual-port controllers, and 15 146GB 15K SAS drives.
–Two identical Dell T610 Towers, each with a single, 6-core CPU (Intel Xeon X5670, 2.93 Ghz, 12M Cache, HT, 1333MHz FSB); 32GB 1333MHz RAM; a PERC H700 RAID controller; two 146GB 15K SAS Drives; one HBA (to connect to the DAS); and dual network connections.
In August, I will be presenting at the following events:
DevLINK, August 5-7, 2010
St. Louis SQL Server Users Group, August 11, 2010
Baton Rouge SQL Saturday, August 14, 2010
If you are attending, be sure to stop me and say hello.
Brad M McGehee 