Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Portland)

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

on oct 22nd 4.45 pm, i will be presenting “consolidated essential performance health check using powershell” @ at sqlsaturday, portland, if you are in the area i hope to see you…

location:
washington state university vancouver
14204 ne salmon creek ave
vancouver, washington, 98686, united states

sqlsaturday-portland 2016

register here

download scripts from github

session evaluation

session detail:
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 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 sql server’s performance 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

• 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

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Sacramento)

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

on july 23rd 9.45 am, i will be presenting “consolidated essential performance health check using powershell” @ at sqlsaturday, sacramento, if you are in the area i hope to see you…

location:
patrick hays learning center
2700 gateway oaks drive, suite 2600
sacramento, ca 95833

sqlsaturday-sacramento 2016

register here

download scripts from github

session evaluation

session detail:
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 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 sql server’s performance 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

• 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

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQL User Group

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

on june 8th 6.30 pm, i will be presenting “consolidated essential performance health check using powershell” @ at san francisco data platform user group, if you are in the area i hope to see you…

location: microsoft reactor, 680 folsom street , san francisco, ca

san francisco data platform user group – june 08 2015

register here

download scripts from github

session evaluation

session detail:
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 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 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

• 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

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing any additional load on system.

on 9th april 10.30 pm pst, i will be speaking on “detect worst performing sql queries during peak hour” @ 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 and sponsors. 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.

sqlsaturday – silicon valley – 09 apr 2016

event schedule

session: detect worst performing sql queries during peak hour

register here

session feedback

scripts repository – github

session detail:

how many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? where do you start tuning? when do you stop tuning? each application is different. with the ever increasing number of systems one production dba has to manage today, it’s very important to use top to bottom approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

while you can find top queries, wouldn’t it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour in current situation without using profiler or causing any additional load on system? now you can focus on those specific queries!

in these 60 minutes, prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on cpu/disk/memory/network. they are all based on his own real-life experience from managing demanding database systems.

you’ll learn how to:

• detect worst performing sql queries which slows down microsoft sql server performance without using profiler

• key dmvs used to detect worst performing queries, along with various type of information available for those queries

• investigation workflow with which you will be able to pin point a specific stored procedure/query that is the cause of the performance problem faced.

SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing any additional load on system.

on 24th oct 02.15 pm pst, i will be speaking on “detect worst performing sql queries during peak hour” @ sqlsaturday, portland!!, 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 and sponsors. 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.

sqlsaturday – portland – 24 oct 2015

event schedule

session: detect worst performing sql queries during peak hour

register here

session feedback

scripts repository – github

session detail:

how many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? where do you start tuning? when do you stop tuning? each application is different. with the ever increasing number of systems one production dba has to manage today, it’s very important to use top to bottom approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

while you can find top queries, wouldn’t it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour in current situation without using profiler or causing any additional load on system? now you can focus on those specific queries!

in these 60 minutes, prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on cpu/disk/memory/network. they are all based on his own real-life experience from managing demanding database systems.

you’ll learn how to:

• detect worst performing sql queries which slows down microsoft sql server performance without using profiler

• key dmvs used to detect worst performing queries, along with various type of information available for those queries

• investigation workflow with which you will be able to pin point a specific stored procedure/query that is the cause of the performance problem faced.

Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing any additional load on system.

on 10th oct 01.30 pm pst, i will be speaking on “detect worst performing sql queries during peak hour” @ sqlsaturday, orlando!!, 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 and sponsors. 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.

sqlsaturday – orlando – 10 oct 2015

event schedule

session: detect worst performing sql queries during peak hour

register here

session feedback

scripts repository – github

session detail:

how many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? where do you start tuning? when do you stop tuning? each application is different. with the ever increasing number of systems one production dba has to manage today, it’s very important to use top to bottom approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

while you can find top queries, wouldn’t it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour in current situation without using profiler or causing any additional load on system? now you can focus on those specific queries!

in these 60 minutes, prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on cpu/disk/memory/network. they are all based on his own real-life experience from managing demanding database systems.

you’ll learn how to:

• detect worst performing sql queries which slows down microsoft sql server performance without using profiler

• key dmvs used to detect worst performing queries, along with various type of information available for those queries

• investigation workflow with which you will be able to pin point a specific stored procedure/query that is the cause of the performance problem faced.

Universal SQL Installations Framework (Script review and Demo)

Prakash Heda will show you how to do multiple versions of SQL Server installations using single scripts with all best practices baked in, This session will first discuss process framework, prerequisites and then followed up with script review and live demo of installing diff version of SQL servers with diff OS using single line command.

on 19th sep 10.00 am pst, i will be speaking on “universal sql installations framework” @ sqlsaturday, san diego!!, 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 and sponsors. 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.

sqlsaturday – san diego – 19 sep 2015

event schedule

universal sql installations – part 1 (10 am to 11 am)
universal sql installations – script review & demo (11:15 am to 12:15 pm)

register here

session feedback

scripts repository – github

session detail:

i will show you how to do multiple versions of sql server installations using single scripts with all best practices baked in, this session will first discuss process framework, prerequisites and then followed up with script review and live demo of installing diff version of sql servers along with diff os using single line command which ensure environment consistency and optimal performance across dev/stage/qa/production.

you’ll take-away script to install different versions of sql server on diff os systems with utmost ease. this script allows anyone in it to install sql systems with best practices baked into it which ensure all sql installation can be streamlined and with a single line command can install any of the below combinations:

• windows 2008r2/2012/2012r2

• sql 2016ctp2.3/2014/2012/2008r2 (enterprise/standard/developer editions)

• any sql service pack/ cumulative updates / hotfix combination

• vmware/hyper-v/azure vm/aws ec2/physical servers

• implement best practices and configuration based on available resources for dedicated sql server environments

you’ll learn how to:

• install different versions of sql server on supported os systems, and readymade scripts to do so

• install sql server systems following best practices and new default which makes more sense

• ensure consistent sql server support environments help improve dba productivity and reduce production issues

• easily add new sql server configurations to support new applications and new versions of sql servers

• identify support situations where different types of applications need dedicated sql servers

• ensure perfect consistency across dev/qa/stage/production env and assure developers of the same

Speaking on Standardized SQL Installations – Script Review & Demo – SQLSaturday (Sacramento)

Prakash Heda will show you how to do multiple versions of SQL Server installations using single scripts with all best practices baked in, This session is mostly demo-focused. I will cover prerequisites for scripts and demonstrate how to Streamline SQL Server implementations.

on 25th july 8.30 am pst, i will be speaking on “standardized sql installations – script review & demo)” @ sqlsaturday, sacramento!!, 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 and sponsors. 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.

sqlsaturday – sacramento – july 2015

event schedule

session details

register here

session detail:

this session is mostly demo-focused. i will cover prerequisites for scripts and show how to do multiple sql server installations using scripts and demonstrate how to streamline sql server implementations. check the presentation above for describing process…

you’ll take-away script to install different versions of sql server on supported os systems. this script allows anyone in it to install sql systems with best practices baked into it which ensure all sql installation can be streamlined.

you’ll see powershell scripts where a single line script can install any of these combinations:

• windows 2008r2/2012/2012r2

• sql 2014/2012/2008r2 (enterprise/standard/developer editions)

• implement best practices and configuration based on available resources for dedicated sql server environments

you’ll learn how to:

• install different versions of sql server on supported os systems, and receive the scripts to do so

• install sql server systems following best practices

• ensure consistent sql server support environments help improve dba productivity and reduce production issues

• easily add new sql server configurations to support new applications and new versions of sql servers

• identify support situations where different types of applications need dedicated sql servers

Script and Presentation DAC- Universal Automated SQL Installations

This script allows you to install SQL server 2014/2012/2008R2 on windows 2012R2/Windows 2012/Windows 2008R2 with Enterprise/Standard/Developer editions….Script also support AZURE/AWS/VMWare/HyperV/Physical servers

the san francisco sql server user group – may 13 2015

session evaluation

uploading presentation dac and scripts for today’s session….


scripts:

to save right click on links and choose “save target as”

please update in comments if you see any issue with script…

universalautomatedsqlinstallations.zip this zip contains all files

May 13th – Standardized SQL Installations – Script Review & Demo

This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

on 13th may 6.30 pm, i will be presenting “standardized sql installations – script review & demo”@ at san francisco sql server user group, if you are in the area i hope to see you…

location: microsoft, 555 california st, san francisco, ca

the san francisco sql server user group – may 13 2015


register here

session detail:
this session is mostly demo-focused. i will cover prerequisites for scripts and show how to do multiple sql server installations using scripts and demonstrate how to streamline sql server implementations. check the presentation above for describing process…

you’ll take-away script to install different versions of sql server on supported os systems. this script allows anyone in it to install sql systems with best practices baked into it which ensure all sql installation can be streamlined.

you’ll see powershell scripts where a single line script can install any of these combinations:
• windows 2008r2/2012/2012r2
• sql 2014/2012/2008r2 (enterprise/standard/developer editions)
• implement best practices and configuration based on available resources for dedicated sql server environments

you’ll learn how to:
• install different versions of sql server on supported os systems, and receive the scripts to do so
• install sql server systems following best practices
• ensure consistent sql server support environments help improve dba productivity and reduce production issues
• easily add new sql server configurations to support new applications and new versions of sql servers
• identify support situations where different types of applications need dedicated sql servers