Thu09Nov201706:305404 Wisconsin Ave # 700, Chevy Chase, MD 20815
SQL Server Performance Metrics : How do you collect them and why should you care? - DC 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.