Past Meetup

Consolidated Essential Performance Health Check using PowerShell

This Meetup is past

34 people went

Location image of event venue


A performance health check is the key in responding quickly to production issues. It can cut the initial evaluation phase significantly, whether someone has requested a health check or you run one due to an alert. These essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or jump into in-depth troubleshooting.

Prakash will walk you through a centralized process using PowerShell where the key information is collected, organized and sent via HTML formatted email. The email provides consolidated view of SQL server along with key observations which DBA should verify and share with IT stakeholders for increasing transparency and improved efficiency. This consolidated email can be shared with technical stakeholders to give a snapshot of DBA efforts and it adds transparency to the Health check process.

Prakash will share some key observations about SQL Server performance which can be the key to quick resolution of issues. You can also evaluate a different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance.

This session is good for DBAs and technical folks who want to take a quick look at the SQL Server’s matrix.

You'll learn:

• An essential matrix to evaluate SQL server performance quickly which can rule out or confirm if any further action is required Session

• Consolidated and standardized view of essential performance stats of SQL Server is helpful for DBA to quickly analyze a SQL server and other technical stake holders like Server/Storage team/Client Support/ Application Team

• About a customizable PowerShell script which can be run from central SQL Server or desktop which has Sysadmin access to SQL server and supports SQL 2008 to 2016 SQL servers

Prakash Heda works as Manager (Database Team) at SS&C-Advent Software. His expertise includes Automation, Performance Tuning/Troubleshooting, High Availability, SAN configuration and windows administration. He has 15+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development expertise for using SQL Server 2000 to 2016. He is active blogger and speaks in several local chapters and SQL Saturdays every year.