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 is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to production issues.
Prakash will share some key observations about sql server performance which can be the key to quick resolution of issues. Rest of the email shows different set of stats regarding cpu/disk io/disk space/memory/network/blocking and database performance which could lead to the slowness observed in the application. 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 walk you through a centralized process using PowerShell where the key information collected, organized and sent via html formatted 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 session is good for dbas and technical folks who without having dba knowledge would like to take a quick look at the SQLServer’s performance matrix.
- An essential matrix to evaluate sql server performance quickly which can rule out or confirm if any further action is required
- Consolidated and standardized view of essential performance stats of sql server is helpful for dba to quickly analyze a SQLServer and other technical stake holders like server/storage team/client support/ application team
- A customizable powershell script which can be run from central sql server or desktop which has sysadmin access to SQLServer and supports SQL 2008 to 2016 SQLServers