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

SQL Server Health Check Step 1: Collect Metrics by UpSearch

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

SQL Server Health Check Step 1: Collect Metrics

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.

SQL Server Health Check Series

This blog series will help you decide if UpSearch’s SQL Server Health Check is right for your organization. Follow the links below to learn how you can use our assessment to identify and resolve SQL Server problems.

  1. SQL Server Health Check Introduction
  2. SQL Server Health Check Benefits
  3. SQL Server Health Check Process – Step 1
  4. SQL Server Health Check Process – Step 2
  5. SQL Server Health Check Process – Step 3

About UpSearch

up-social-round

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.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *