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.
The post How to Import Perfmon Data into a SQL Server for Analysis first appeared on Convergence of Data, Cloud, and Infrastructure.
The post How to Import Perfmon Data into a SQL Server for Analysis appeared first on SQLServerCentral.