Database Administration - Category Archive
The following is a list of all entries from the Database Administration category.
How Do You Defragment Your SQL Server Indexes
Database Administration,Database Maintenance,Performance Tuning | August 18, 2010 | 11:05 amI give a lot of presentations based on best practices, and in all of them I stress the importance of regularly rebuilding or reorganizing indexes. Both the REBUILD and the REORGANIZE options have their pros and cons, so I thought it would be interesting to do a poll to see which method(s) was preferred by ...read more
How to Performance Tune a VLDB on your Desktop
Database Administration,Performance Tuning | August 16, 2010 | 3:17 pmRecently, I wrote a review of Red Gate Software’s new SQL Virtual Restore software. SQL Virtual Restore allows you to quickly turn a compressed backup into a live, virtual database, with the advantage that the virtual database is substantially smaller than the original database, while at the same time acting identically to the production database.
Windows OS Power Saving Feature Directly Affects CPU Performance
Database Administration,Hardware,Performance Tuning | July 26, 2010 | 2:50 pmWhile 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: High Performance Balanced Power Saver
Instant File Initialization Speeds SQL Server
Database Administration,Database Maintenance | July 21, 2010 | 9:20 amSometimes, 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.
Free SQL Server DMV Starter Pack
Database Administration,Free Stuff | July 19, 2010 | 2:44 pmThe 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.
Test Cluster Delivered & Ready to Assemble
Database Administration,Hardware | July 13, 2010 | 11:12 amI 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 ...read more
PAL 2.0 Beta Released
Database Administration,Free Stuff,News,Performance Tuning | July 2, 2010 | 4:25 pmBack in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This free tool, available from pal.codeplex.com, has been enhanced, and Version 2.0, Beta 1.1, is currently available for download. I have just downloaded and installed it myself, although I haven’t had much chance to use it ...read more
Database Configuration Checklist
Database Administration | | 4:09 pmThis is number four in a series of checklists that I am putting together for a new book I am writing. Previously, I blogged about my SQL Server Hardware Checklist, my SQL Server Operating System Checklist, and my SQL Server Instance Checklist. The goal of the SQL Server Database Configuration Checklist is to help DBAs ...read more
Twitter
Linked In