Wed18Jul201806:00Info Tec, 100 Constitution Drive, Virginia Beach, VA
SQL Server Performance Metrics : How do you collect them and why should you care? - Hampton Roads Local User Group
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.