Do you have SQL Server problems and don’t where to turn for help? SQL Server Health Check Step 1: Collect Metrics describes how we obtain a comprehensive view of your database environment. This blog series is intended to help you decide if a SQL Server audit is right for your organization.
SQL Server Health Check Step 1: Collect Metrics
Collect Configuration and Performance Metrics
Previously, we explored SQL Server Health Check Benefits. Now that the end results are clear, let’s talk about the process used to achieve these benefits. We begin with the end in mind by interviewing key stakeholders. We want to make certain business and continuity objectives are top of mind.
Once we have a clear understanding of your business goals, we use UpSearch’s proven methodology to collect metrics. We run our proprietary scripts to get configuration and performance metrics on just about anything that touches SQL Server.
We collect information about your server and infrastructure, SQL Server instance and detailed database information. We pay careful consideration to SQL Server performance metrics, including:
- Host Statistics
- Storage Configuration
- SQL Instance Activity and Performance
And when it comes to Queries and Indexes, we pay special attention to long running and expensive queries, top missing indexes and duplicate indexes.
SQL queries can perform poorly for a variety of reasons. Some factors are how they are written, inadequate hardware, or missing indexes to support the workload. We recognize the importance of identifying queries that perform poorly based on:
- Number of Executions
- CPU cost
- Disk Impact (Reads and Writes)
- Duration
In summary, the first step of UpSearch’s SQL Server Health Check process is to provide a comprehensive view of your database environment. This process can include multiple instances of SQL Server.
This blog series continues with Step 2: Analyze Results and webinar invitation. At the conclusion of this series, you will have a better understanding of how your organization will benefit from a SQL Server Health Check.
About UpSearch
UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.
Leave a Reply
Want to join the discussion?Feel free to contribute!