Database Administration - Category Archive
The following is a list of all entries from the Database Administration category.
Do You Enable “Lock Pages in Memory”?
Database Administration,Performance Tuning | March 10, 2011 | 5:52 pmLock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out SQL Server memory to disk. By default, this setting is turned off on 64-bit systems, and depending on the circumstances, the following conditions could occur when this setting is not turned on: ...read more
Attending SQLskills Immersion Event on Performance Tuning Next Week
Database Administration | | 4:47 pmAfter attending the SQLskills Immersion Event on Internals and Performance in Dallas two weeks ago, I am fortunate enough to be flying back to Dallas next week to attend the Immersion Event on Performance Tuning. The first week was a whirlwind, and I imagine the second week will be one as well. I just hope ...read more
Interview with DBA Brian Kelley
Database Administration,SQL Server Connections | | 12:03 pmBrian Kelley will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL. Tell us a little about yourself. I’m currently working as a SQL Server DBA and architect for a financial institution. Previously, I’ve been an infrastructure and security architect. I’ve also been writing on SQL Server related topics ...read more
SQLServerCentral Best Practices Clinic
Database Administration,Database Maintenance | March 7, 2011 | 11:51 amI have just begun a new article series at SQLServerCentral.com called the SQLServerCentral.com Best Practices Clinic. What is this series all about? Our goal is to experiment with getting community feedback on different ways that the two node cluster that is running the backend databases for SQLServerCentral.com and Simple-Talk.com can be optimized. If you would ...read more
Poll Reveals DBAs Actively Tune TEMPDB
Database Administration,Performance Tuning | February 3, 2011 | 2:51 pmWhen I manage a SQL Server instance, I always make an extra effort to optimize the performance of TEMPDB, so I decided to do a poll to see if other DBAs did the same. When the results came in, I was a little surprised, as about 91% of those who responded to the poll said ...read more
Get SQL Scripts Manager for Free
Database Administration,Free Stuff | December 23, 2010 | 1:36 pmRed Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes 25 scripts written by many well-known DBAs, such as Ola Hallengren, Louis Davidson, Glenn Berry, Tim Ford, and many more, that can help you to automate common troubleshooting, diagnostic, and maintenance tasks. While SQL Scripts ...read more
Microsoft Codename Atlanta Attempts to Help Out DBAs By Providing Basic Assistance
Database Administration,Database Maintenance | December 8, 2010 | 5:00 pmI have always recommended that DBAs be as proactive as possible, catching potential problems, and actual problems, as soon as possible before they can negatively affect a SQL Server’s performance or availability. In fact, I am working on a new book, tentatively titled, How to Perform a SQL Server Health Check, which will provide a ...read more
SQL Server 2008 R2 Best Practices Analyzer
Database Administration,Free Stuff | November 26, 2010 | 6:25 pmA big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are literally hundreds of different best practices, and as you might expect, not every best practice applies to every SQL Server environment. That means, that as a DBA, you must evaluate the many commonly accepted best ...read more
Twitter
Linked In