Wed18Jul201806: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.