Presenting 2 sessions @ SQLSaturday (Silicon Valley)

, 2017-04-19

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





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.


1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...


1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.


360 reads