Database Administration - Category Archive
The following is a list of all entries from the Database Administration category.
Interview with SQL Server MVP Glenn Berry
Database Administration,DBA Career,SQL Server Connections | August 31, 2010 | 11:19 amThis is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections in November 2010. This interview is with SQL Server MVP Glenn Berry (blog | Twitter). Tell us a little about yourself Glenn. After high school, I spent four years in the Marine Corps, serving ...read more
SQL Server Monitoring Checklist
Database Administration | August 27, 2010 | 3:36 pmIt’s been awhile since I have worked on my checklist series of blog posts that will eventually be turned into a book. This time around the checklist focuses on the kinds of things you might want to monitor on your SQL Server instance to ensure that they are working as you expect. Unlike some of ...read more
Checkout SQLServerIO.com for Useful Information on SQL Server Storage Systems
Database Administration,Hardware,Performance Tuning | August 18, 2010 | 4:45 pmAt the recent SQLSaturday #28 in Baton Rouge, LA, I had the opportunity to meet Wes Brown (Blog | Twitter), and attend his session on “Understanding Storage Systems and SQL Server”. I enjoyed his presentation and also discovered that Wes has a blog where he shares his deep knowledge of SQL Server I/O. If you ...read more
How Do You Defragment Your SQL Server Indexes
Database Administration,Database Maintenance,Performance Tuning | | 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.
Twitter
Linked In