Welcome to the Northwest Ohio SQL PASS Chapter

Next Meeting

Wednesday,

July

09

July 2014

  • In-Person @ 333 N Summit St. Toledo, Ohio, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

 

TOPIC: Top 10 Issues Identified By SQL Health Checks

 

In a complex database environment, keeping tabs on the health and stability of each system is critical to ensure data availability, accessibility, recoverability, and security. Through performing thousands of health checks for clients, Datavail has identified the top 10 issues affecting SQL Server performance.

 

From misconfigured memory settings to missing backups, Datavail has gathered evidence from client health check history that identifies the most common issues DBA managers must correct for optimal database performance. Datavail’s SQL Health Check is used not only as a diagnostic tool but also a road map of the work that needs to be performed. From there, routine health checks have proven to improve database performance. SQL Server Senior DBA for Datavail Andy McDermid will share the top 10 issues, the consequences of not taking action, and why consistent use of a SQL Server Health Check in conjunction with ongoing database management can lead to improved database environments and maximize the investment of time and resources.

 

 

SPEAKER: Andy McDermid, SQL Server Senior DBA, Datavail

 

Andy is a MCITP certified MS SQL DBA who delivers and manages delivery of DBA services to many diverse clients. He enjoys helping his clients by finding and deploying pragmatic and practical solutions for their database issues. He has conducted dozens of health checks on a variety of client databases. Andy is always working to improve and expand his DBA skills and he likes to share the experience via writing. You can read more about his work here http://www.datavail.com/author/andy-mcdermid.



Featured Presentation:

Top 10 Issues Identified By SQL Health Checks

Andy McDermid Datavail

TOPIC: Top 10 Issues Identified By SQL Health Checks In a complex database environment, keeping tabs on the health and stability of each system is critical to ensure data availability, accessibility, recoverability, and security. Through performing thousands of health checks for clients, Datavail has identified the top 10 issues affecting SQL Server performance. From misconfigured memory settings to missing backups, Datavail has gathered evidence from client health check history that identifies the most common issues DBA managers must correct for optimal database performance. Datavail’s SQL Health Check is used not only as a diagnostic tool but also a road map of the work that needs to be performed. From there, routine health checks have proven to improve database performance. SQL Server Senior DBA for Datavail Andy McDermid will share the top 10 issues, the consequences of not taking action, and why consistent use of a SQL Server Health Check in conjunction with ongoing database management can lead to improved database environments and maximize the investment of time and resources.

About Andy:
None

cage-aids
cage-aids
cage-aids
cage-aids