DBA wants to collect metrics and analysis them and present them to management to get something done by using the data and it is all about data and metric nowadays. How to collect them and show as a presentation. Tools needed: SSRS, Perfmon.msc, Relog.Exe, database engine, power shell & CMD. Configure SSRS Installing SSRS If you have not installed SSRS, install the service first and configure it. Go to the software folder and double click the setup – click installation in the left side –New SQL server standalone or add features on existing installation – Next and next – select “Add features to an existing instance of SQL server Next…