As a Database Administrator, there are certain tasks that you must complete at a fairly regular frequency. Jason Strate has put together a list of 10 things he says a Database Administrator should do each month.
Are you doing what you must to ensure that your SQL Server environment is behaving as you, or your manager, expects that it is? Whether you are veteran, involuntary, or junior DBA, there are common things that we are required to do for our SQL Servers on a regular basis. These tasks may seem like they are relatively low level items, but they are in fact critical in maintaining the health and security of our SQL Server instances.
- Update Windows Server
- Update SQL Server
- Validate Backups
- Validate Recovery Strategy
- Verify SQL Server and Windows Configuration
- Check server performance and health
- Check database performance and health
- Review and adjust baselines
- Validate capacity plan
- Submit status report
Take a look at the article for full details and see if you have any recommendations for additional items.
Technology News and Information by SeniorDBA 
Ultimately DBAs should do these activities. DBAs who are administering large productions databases encounter a problems and issues dealing with database performance. Large production database administrators use GUI based tools to manage the performance problems. These tools help administrators to identify the root cause. Enteros Upbeat High Load Capture provides these analysis. Information about Enteros High Load Capture can be found on http://www.enteros.com
LikeLike
Certainly these are tasks that a DBA must do to avoid performance issues. Besides these tasks there are a variety of tools that are gaining reputation in today’s world for managing performance of database. These tools help the DBA to identify and remediate database performance problem. Enteros is one of the companies that is providing tools to proactively respond to the performance problems in productions database. More details can be found on http://www.enteros.com
LikeLike