This blog covers detailed information about the solution we have developed using a variety of software to assist DBA team members to create quick graphical presentations of performance data collected from the performance monitor using following tasks
While handling multiple big projects in the past, during the migration and hardware planning of servers, there were frequent requests as listed below:
While working on such requests, we observed that it was a time-consuming process because each time we were creating a data collector set and processing it manually to get easily understandable graphs, and these challenges motivated us to work on a time-saving and smart solution.
Please refer attached zip folder for solution files at the end of this blog
Step 1: Create and run the data collector set using standard Template
Please do not change the sample interval of data collection as it is already set to 5 minutes. Reducing it may increase the collected data volume, resulting in a more distorted graph if data collection lasts more than 4-5 days or a week.
Please do not change the sequence or edit list of performance counters from the standard templet or Excel sheet, as changing the sequence or count of existing counters may cause Excel to fail to process data correctly.
Currently, “stop at parameter” of data collector set in the templet is set to 1 week. which means data will be collected for 1 week, and the data collector set will be stopped automatically after 1 week. If you want to reduce it in days or hours, please change it as per your requirements.
Step2: Convert Raw Data into csv format from .blg file. Once you’ve collected the performance data, you can use the .blg file to convert it to CSV format. Please use the following steps to convert .blg format data to CSV:
Step 3: How to convert raw data from a .csv file to a final xlsx sheet to generate detailed graphs.
We need to perform the following action.
RESULT FOR SINGLE SERVER -“Sheet: Per_TouchStone_Single_Server.xlsx
For 2 Servers Comparison
Solution Files Attached Solution.zip
This article covers detailed information about the solution we have created to help DBA Team members create quick graphical presentations of performance data collected from the performance monitor. These graphs can be used for multiple purposes, like resource utilization report creation for SQL Server, performance benchmarking for SQL Server, and resource utilization comparison between two servers.
Learn about Rackspace Managed SQL Services.
Learn about Rackspace Database Services.
Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.