BLG Performance Report Generator
One of the best features of Microsoft Windows Servers is the ability to (out of the box) collect resource performance statistics using Windows perfmon “Performance Monitor”. Not only does Perfmon allow you to immediately view the current resources, but it also allows you to automatically collect Key Performance Indicators into a Perfmon BLG file for future reference.
BLG Performance Report Generator for Windows® allows you to quickly graph and process data that has been collected by the Microsoft Windows® Performance Monitor (Perfmon). BLG Performance Report Generator can save you hours of trying to format and graph Windows® Perfmon data into something that can be easily understood by both technical and non-technical users.
This utility is perfect for those performing load/stress tests on servers, those that are troubleshooting server resource issues or those that simply want an easy way to get detailed information related to your servers resource usage. The full product also includes detailed descriptions for each Key Performance Counter graphed as well as what you should look for in comprehending the results.
Features. Why BLG Performance Report Generator was created.
BLG Performance Report Generator will allow you to:
Quickly Generate Graphs from Perfmon BLG files
Ability to Process over 50 Key Performance Indicators
Select Individual Services for Report Generation
Combine the Perfmon BLG files into a Single Report or simply Generate a Report for each perfmon BLG File you add
Provides Disk Performance Stats from each disk or Graph the Total from all Disks
Reports are in Microsoft Word® Format to Allow You to Add Notes and Customize the Reports
Provide Stats for Advanced Services, such as graphing Microsoft® IIS/Webservice Stats and Specific SQL Server Perfmon Counters (15 KPIs for SQL)
Graph and Provide Concurrent User Stats from Data Captured with our “CountConnections” Utility
Full Product Includes the PDF version of the Windows Performance Counters Explained Guide.
Here are 2 sample reports converted to PDF format:
SQL Server – This is an hourly report from a busy SQL Server.
Tableau Data Server – This is from a Stress Test performed on Tableau, this is from the Data Server.
To ensure the BLG Performance Report Generator will work for you system, you can Download and try the Demo version, which is limited to only graphing CPU and Memory statistics.
Additional Information. Common Questions for BLG Performance Report Generator.
Below are the System Requirements to run BLG Performance Report Generator:
Microsoft Windows® Vista or higher
Microsoft® .Net 4 or above
Microsoft Word® 2007 or above
BLG Performance Report Generator can produce graphs from BLG files that are collected from Windows XP/2003 and above systems.
The recommended capture for Perfmon is below, for exact KPIs that are graphed check the next question.
\Memory\* \Network Interface(*)\* \Paging File(*)\* \PhysicalDisk(*)\* \Process(*)\* \Processor(*)\* \Processor Performance(*)\* \Server\* \System\* \SQLServer:Access Methods\* \SQLServer:Buffer Manager\* \SQLServer:Databases(*)\* \SQLServer:General Statistics\* \SQLServer:Latches\* \SQLServer:Locks(*)\* \SQLServer:Memory Manager\* \SQLServer:SQL Statistics\* \Web Service(*)\*
To come up with a list of Performance counters to focus on, we reached out to quite a few “Windows Performance experts” as well as some people internally within Microsoft. Our primary objective was to provide the stats that directly contributed to the computer hardware itself as well as provide some “User Load Stats” for basic IIS/SQL enterprise apps.
The Full Counter List that we graph is below. Detailed descriptions of these KPIs can be found in the Windows Performance Counters Explained guide on this site.
\Processor(*)\% Processor Time \Processor(_total)\% Privileged Time \Processor(_total)\% User Time \Memory\Available Bytes \Memory\Cache Bytes \Memory\Pool Nonpaged Bytes \Process(_Total)\Working Set \Network Interface(*)\Bytes Received/sec \Network Interface(*)\Bytes Sent/sec \PhysicalDisk(*)\Avg. Disk sec/Read \PhysicalDisk(*)\Avg. Disk sec/Write \PhysicalDisk(*)\Split IO/sec \PhysicalDisk(*)\Disk Read Bytes/sec \PhysicalDisk(*)\Disk Write Bytes/sec \PhysicalDisk(*)\Avg. Disk Queue Length \PhysicalDisk(*)\Current Disk Queue Length \System\Processor Queue Length \Memory\Pages/sec \Memory\Page Reads/sec \Memory\Page Writes/sec \Paging File(_total)\% Usage \SQLServer:Access Methods\Page Splits/sec \SQLServer:Buffer Manager\Buffer cache hit ratio \SQLServer:Buffer Manager\Lazy Writes/sec \SQLServer:Databases(_total)\Log Flushes/sec \SQLServer:General Statistics\Processes Blocked \SQLServer:General Statistics\User Connections \SQLServer:Latches\AVerage Latch Wait Time (ms) \SQLServer:Locks(_total)\Average Wait Time (ms) \SQLServer:Locks(_total)\Number of DeadLocks/sec \SQLServer:Memory Manager\SQL Cache Memory (KB) \SQLServer:Memory Manager\Target Server Memory (KB) \SQLServer:Memory Manager\Total Server Memory (KB) \SQLServer:SQL Statistics\Batch Requests/sec \SQLServer:SQL Statistics\SQL Compilations/sec \SQLServer:SQL Statistics\SQL Re-Compilations/sec \Web Service(_Total)\Current Anonymous Users \Web Service(_Total)\Current Connections \Web Service(_Total)\Current NonAnonymous Users \Web Service(_Total)\Get Requests/sec \Web Service(_Total)\Put Requests/sec \Web Service(_Total)\Post Requests/sec