Name: Fine Tuning Production SQL Servers
Start: 2012-01-17T18:30:00-08:00
End: 2012-01-17T21:30:00-08:00
Location: Microsoft

Speaker: Prakash Heda, Advent Software

Production SQL servers require constant proactive monitoring and fine-tuning for optimal performance and high availability. You'll learn how DBAs perform quick health checks and performance tuning on production databases to ensure high uptime.

Prakash will demo various deadlocking/blocking/top queries scenarios and share scripts to automate them.

You'll learn how to:

Perform quick health checks for production db servers Track and capture disk/database usage Track and capture and report deadlocks/blocks Identify the top SQL queries which needs performance tuning Prakash Heda is a Senior Infrastructure DBA at Advent Software. His expertise includes Performance Tuning and troubleshooting, high availability, SAN configuration, and Windows administration. He manages enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA/MCITP, and his background includes development in VB and ASP, SSIS, and data warehousing using SQL Server 2000, 2005, and 2008 R2.

Mark Ginnebaugh

Silicon Valley Azure Data Platform Meetup

Technology

SQL Server

Database Professionals

Database Development

Data Management

Data Analytics

Microsoft Azure

Data Governance

Power BI

Business Intelligence

Data Visualization

PaaS (Platform as a Service)

Fine Tuning Production SQL Servers

Microsoft

Share

Silicon Valley Azure Data Platform Meetup

Fine Tuning Production SQL Servers

Silicon Valley Azure Data Platform Meetup

Details

Members are also interested in