Healthy SQL

Healthy SQL

4.11 - 1251 ratings - Source

Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have a healthy SQL implementation. Healthy SQL is built around the concept of a medical checkup, giving you the tools you need to assess the current health of your database and take action to improve upon that health and maintain good performance to your business. Healthy SQL aids in developing a rigorous routine so that you know how healthy your SQL Server machines are, and how you can keep those same servers healthy and fit for duty. The book is filled with practical advice and a time-tested strategy, helping you put together a regimen that will ensure your servers are healthy, your implementation is fully optimized, your services are redundant and highly available, and you have a plan for business continuity in the event of a disaster. If your current environment doesn't match up with these criteria, then pick up a copy of Healthy SQL today and start your journey on the road to a fit and tight SQL Server deployment. What youa€™ll learn Understand what a SQL Server health check is, and why you should perform one Know the right times and triggers for a comprehensive health check Make a comprehensive probe of your environment using the best tools and techniques Store the data collected for trend analysis and comparison with future checks Slice, dice, and glean insight from the results of your SQL Server health check Know what changes to make to improve performance and future health check results Maintain the performance of your database at the level needed by your business Who this book is for Healthy SQL is written for database administrators and developers responsible for managing and ensuring the performance one or more SQL Server database instances. The book is also helpful for system administrators and others who might assist or have a direct, hands-on role in SQL Server database performance troubleshooting. Table of Contents 1. Understanding the Health Check 2. Creating a Road Map 3. Waits and Queues 4. Indexes 5. Tools of the Trad 6. Expanding the Toolset 7. Creating a Heath Repository 8. Monitoring and Reporting 9. High Availability and Disaster Recovery 10. Surviving the AuditA Comprehensive Guide to Healthy SQL Server Performance Robert Pearl. Note a–i always check with your Microsoft taM regarding software licensing because it is subject to change. ... For example, with log shipping, the secondary database was in standby mode or always restoring and not user accessible for any considerable use. ... Fast-forward to Windows Server 2008 and Windows Server 2008 R2; the MSCS service has been renamed to Windows Server Failover Clusteringanbsp;...

Title:Healthy SQL
Author:Robert Pearl
Publisher:Apress - 2015-05-20


You Must CONTINUE and create a free account to access unlimited downloads & streaming