If you followed the last video, I showed you how to set up windows perfmon for ongoing performance metric collection on all of your critical SQL Server machines. However, having this raw data in a portable format doesn’t mean you have an easy means to access that data. In this training video, I show you a PowerShell script that we released that helps you export this data into a SQL Server database table so that you have access to the raw data to perform ongoing performance analysis with whatever favorite tool you prefer.
Check out this free utility at the GitHub link, github.com/heraflux/BLGtoSQL, and watch this video to learn how to use it. Let me know your thoughts and what questions you have!
The post How to Import Perfmon Data into a SQL Server for Analysis first appeared on Convergence of Data, Cloud, and Infrastructure.