embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 2.00 out of 5)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

SQL Server Performance Monitoring & Optimization

Speaker:

Anil Desai

Abstract:

Developers can dramatically improve performance by understanding how their queries are executing in the ‘real world’. This session will cover ways in which attendees can monitor performance at various levels, and how they can use this information to optimize queries and improve overall application performance. We’ll start with a discussion of developing a performance optimization strategy and how various tools can help. Then, we’ll walk through the process of using SQL Profiler to collect data in a real-world case: Generating a ‘hit list’ of worst-performing queries based on execution times and frequency.

Next we’ll look at using the Database Tuning Advisor to make suggestions related to physical database structures such as indexes and partitions. Also included will be ways in which built-in reports and dynamic management views can be used to monitor performance of production systems. Time permitting, the presentation will include methods for reducing deadlocks and managing long-running transactions. Finally, the presentation will include an overview of analyzing query plans. The overall emphasis will be on solving practical, real-world database performance problems.

Bio:

Anil Desai is an independent consultant based in Austin, TX. He specializes in evaluating, implementing, and managing IT solutions. He has worked extensively with IT management, development, and database technology. Anil holds many certifications and has received the Microsoft MVP Award for seven years (most recently, Windows Server – Virtualization). Anil is the author of over 20 technical books focusing on the Windows Server platform, virtualization, databases, and IT management best practices. He is also a frequent contributor to IT publications and conferences. For more information, please see http://AnilDesai.net, or e-mail Anil@AnilDesai.net.

Recorded At:

Austin CodeCamp

No Responses to “SQL Server Performance Monitoring & Optimization”

Trackbacks/Pingbacks

  1. SQL Server Presentation Recordings by UserGroup.tv « AnilDesai.net - [...] Recording: SQL Server Performance Monitoring and Optimization [...]

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>