SQL High CPU troubleshooting checklist

Hello all, In this blog, I am covering the scenario of an approach to troubleshoot “SQL Server consuming High CPU” and few checklist points which will help in isolating/troubleshooting. Below screenshot summarizes an approach to isolate SQL high CPU issues: CHECKLIST POINTS: 1. From Windows task manager check the overall CPU utilization. Collect the details of…

0

Troubleshoot SQL Query Performance Issues Using QUERY STORE

Hello all, Query Store is a very powerful SQL engine feature available in SQL 2016 designed to deliver insight into query performance (query text, query plan, runtime stats) by keeping track of different plans and execution statistics for the queries executed on the server. This blog covers the steps to troubleshoot/monitor the SQL Server queries using…

0

SQL Connectivity troubleshooting checklist

Hello all, During daily operations with SQL Instances, DBA/Application teams frequently encounter SQL Connectivity issues while connecting from the applications. In this  blog, I am covering few checklist steps to troubleshoot SQL Connectivity issues. When a client connects to SQL Server, it goes through authentication and authorization stages. If the connectivity issue is because of…

0