2008.2

How does the physical database design of your SQL Server database impact performance?  This session will take a step back from T-SQL and logical database design tuning and explore the important performance considerations at play with regard to physical database design. One of the largest bottlenecks, if not the largest, in any DBMS is disk I/O. Understanding the SQL Server I/O footprint will be a focus of this session. Techniques for measuring, monitoring, and streamlining your SQL Server I/O operations will be discussed.  We'll take a closer look at storage design, file/filegroup strategies, file system configuration, tools such as SQLIO(Sim), useful DMVs, and relevant Performance Monitor counters to help benchmark and monitor your systems.  In addition, we'll dive into related areas such as guidelines for managing TEMPDB, optimizing SQL Server memory management, and managing database growth.

Greg Brozovich (MCDBA, MCSE, OCP, MCSD) is a database architect for Confluence, a Microsoft Gold Partner that designs, develops, and hosts mission critical enterprise solutions for the financial services industry. He started out his IT career at Confluence on the systems and infrastructure side of the fence, leading software implementations and ultimately the design, implementation, and ongoing care and feeding for their highly successful ASP offering.   Greg has also served a tour of duty for Wilmington Finance (an AIG company) as a database architect.  He has been working with SQL Server since 1998, largely in the combined roles of database architect, developer, and administrator.  In his free time, Greg likes to spend time with his wife Heather and their two dogs, Daisy and Monkey in their home in Chester Springs, PA.