Skip to content

Events

CONTENTS

  • Sat
    13
    Jan
    2018
    Middle Tennessee State University (MTSU), 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132

    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.

    Check out the other sessions at the event to see what you can learn SQLSaturday #698 Nashville.

  • 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.

  • Tue
    27
    Nov
    2018
    Greensboro, NC

    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.