www.sqlpass.org    Professional Association for SQL Server

Welcome to the Performance Virtual Chapter

Source: http://www.flickr.com/photos/adamkr/4595762893/We focus on Performance Tuning with regards to SQL Server, attached storage area networks, database design, and IP network. 

The Performance Virtual Chapter Mission Statement: Empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

If you would like to contribute, comment, or volunteer please use the Performance VC Feedback section on the right of the page.

 September Presentation

Introduction to SQL Server Statistics

September 7, 2010 12:00 PM EDT

Speaker Photo: Andy WarrenSpeaker: Andy Warren

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know.

About Andy:

Andy Warren is a SQL trainer focusing on basic administration and performance tuning, he runs the free SQLShare.com training site, is currently a SQL Server MVP, blogs daily at SQLAndy.com, started the SQLSaturday franchise, is co-President of the Orlando SQL Server Users Group, serves as a member of the Board of Directors of PASS, and was a founding partner in SQLServerCentral.com. In his remaining free time he’s working on a book for first time managers.

Attend via LiveMeeting

 October Presentation

Using Storage to Increase Database Performance

October 5, 2010 12:00 PM EDT

Denny CherrySpeaker: Denny Cherry

In this session we'll look at some ways that your storage solution can be configured to increase database performance.

We'll look at some of the things to lok at when selecting the correct RAID level to use, as well as how to setup the cache in your storage array or DAS.

We'll then look at some of the newer technologies like FLASH Cache to improve even more the caching abilities of the storage arrays.  We'll finish up with looking at some of the differences between iSCSI and Fibre Channel and the use of Tiered storage from both a performance and finance perspective.

About Denny:

Denny Cherry has over a decade of experience managing SQL Server, including MySpace.com’s over 175 million user installation, one of the largest in the world. Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting. Denny uses these skills on a regular basis in his current role as a Sr. Database Administrator and Architect at Awareness Technologies. Denny currently holds several Microsoft Certifications related to SQL Server as well as being a Microsoft MVP.  Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management.

 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Useful Links
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 Performance VC Feedback




Send