Events

  • Thu
    02
    Nov
    2017
    16:45Washington State Convention Center, Seattle, WA

    Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We will define and cover important metrics and alerts you need to manage a database in an Availability Group.

    You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.

    Check out the conference at http://www.pass.org/summit/2017/Home.aspx.

     

  • Wed
    08
    Nov
    2017
    http://dba.pass.org/

    This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems new features in 2017.

  • Thu
    09
    Nov
    2017
    06:305404 Wisconsin Ave # 700, Chevy Chase, MD 20815

    An important part of being a proactive DBA is knowing how your system is performing at all times so that you can quickly and easily diagnose problems when they occur. In this session, I will review why it is important to have a standard set of metrics to examine when performance goes awry. I will present an open source solution for collecting SQL server performance metrics that works on both Linux and Windows. Finally, we will walk through a real-world example of how this solution was used to correctly identify and resolve a production issue.

  • Tue
    13
    Mar
    2018
    3025 Carrington Mill Blvd, Morrisville, NC

  • Wed
    18
    Jul
    2018
    06:00Info Tec, 100 Constitution Drive, Virginia Beach, VA

    An important part of being a proactive DBA is knowing how your system is performing at all times so that you can quickly and easily diagnose problems when they occur. In this session, I will review why it is important to have a standard set of metrics to examine when performance goes awry. I will present an open source solution for collecting SQL server performance metrics that works on both Linux and Windows. Finally, we will walk through a real-world example of how this solution was used to correctly identify and resolve a production issue.