MS SQL SERVER DBA

1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events. 2. Verify that all scheduled jobs have run successfully. 3. Confirm that backups have been made and successfully saved to a secure location. 4. Monitor disk space to ensure your SQL Servers won’t run out of disk space. 5. Throughout the day, periodically monitor performance using both System Monitor and Profiler. 6. Use Enterprise Manager/Management Studio to monitor and identify blocking issues. 7. Keep a log of any changes you make to servers, including documentation of any performance issues you identify and correct. 8. Create SQL Server alerts to notify you of potential problems, and have them emailed to you. Take actions as needed. 9. Run the SQL Server Best Practices Analyzer on each of your server’s instances on a periodic basis.

             One of the primary responsibilities of the database administrator is the ongoing monitoring of SQL Server performance. Much of this monitoring can be automated, but for the most part, the monitoring results must be interpreted and acted upon in a systematic approach by the DBA. The monitoring job never ends, and it can become quite complex. Knowing what to monitor, when to monitor, and what constitutes acceptable and unacceptable behavior can become a full-time job. Making things worse is the fact that each SQL Server installation is different, making a global recommendation about what indicators identify unacceptable and acceptable performance very difficult.   In this we will learn various tools used to monitor SQL Server and provides guidelines on how to use these tools to identify areas for optimization. Monitoring SQL Server can be a challenging process. SQL Server ...