Apr 22nd I will be presenting “Re-Indexing – The quest of ultimate automation” & “Consolidated Essential Performance Health Check using PowerShell” @ SQLSaturday, Silicon Valley, if you are in the area I hope to see you

PASS sqlsaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you’re attending a SQLSaturday or thinking about hosting your own, i think you’ll find it’s a great way to spend a Saturday – or any day.

Session: Re-Indexing – The quest of ultimate automation

You will learn a dynamic index optimization process which…

1. Do selective re-indexing
2. Handles blocking efficiently
3. Avoid system downtime due to log disk full
4. Automatically stop itself beyond a threshold
5. Can be implemented across all sql servers regardless of application type or data size

In this session, Prakash will walk you through design considerations, accompanied with a script demo using Powershell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

This session is good for dbas and technical folks who is looking to improve re-indexing process while keeping application uptime

Session: Consolidated Essential Performance Health Check using PowerShell

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.

You’ll learn:

  1. An essential matrix to evaluate sql server performance quickly which can rule out or confirm if any further action is required
  2. 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
  3. 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