Dec-2010 ~ Gathering and Interpreting Server Metrics ~ Grant Fritchey

Posted by admin

 

Presenter: Grant Fritchey – SQL Server MVP
Topic: Gathering and Interpreting Server Metrics

 

Before you can start tuning SQL queries, it’s vital that you know how your server itself is behaving. You need to know what the memory, IO and CPU on the machine look like while the system is at rest and under load. You need to establish this baseline in order to better interpret the results of your later query tuning efforts.

There are a number of inherent methods built into SQL Server and the Windows operating system that can supply you with this vital information. There are even third party tools that can take a lot of guess work and manual labor out of the process of establishing these vital measures. This session will cover all the tools necessary to generate a baseline measurement for performance of your SQL Server system. The session is a small part of and serves as an introduction to the one day pre-conference seminar on query performance tuning being offered at SQLRally in May.

Biography:

Grant Fritchey has twenty years experience in IT. That time was spent in technical support, development and database administration. For the last seven years he has been working at a major insurance company as a DBA. He writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. He also published two books, ”Dissecting SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” He is one of the founding officers of the this Users Group and currently serving as the president. In April 2009 he was awarded as a Microsoft SQL Server MVP. You can also find him tweeting as @GFritchey and blogging at Home of the Scary DBA.

Aug-2010 ~ What Are You Waiting For? ~ Thomas LaRock

Posted by admin

 

Presenter: Thomas LaRock; Senior DBA, SQL Server MVP, PASS Director
Topic: What Are You Waiting For?

 

It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.

Biography:

Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas has progressed through several roles in his career including programmer, analyst, and DBA. Thomas holds a MS degree in Mathematics from Washington State University and is a member of the Usability Professional’s Association. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).