New In-depth SQL Server Health Check

Published On: 2013-04-05By:

Denny Cherry & Associates Consulting is now offering a second SQL Server Health Check option.  This new In-depth SQL Server Health Check is much more comprehensive then the older health check offering (now called the High Level SQL Server Heath Check).  While the High Level SQL Server Health Check checks settings and basic configuration options for the SQL Server instance to insure that the instance is configured per industry standard best practice, the In-depth Health Check goes much further than this by starting with the same configuration checks and best practices as the High Level SQL Server Health Check but then moves into a much more in depth review of the SQL Server instance.  The database sizes and possible schema problems are identified, indexes are reviewed looking for missing indexes, duplicate indexes and unused indexes.  From there we move to reviewing the wait stats which the instance is reporting as well as reviewing the SQL Queries which are being run against the SQL Server instance that are showing as problem queries.

For more information please review the SQL Server Health Check page or contact us for more information and to get your SQL Server Health Check scheduled.

Denny


Contact the Author | Contact DCAC

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via