Databases Reference
In-Depth Information
This script can be scheduled to run regularly — say, every fifteen minutes — from the inventory server
to collect the performance data of a SQL Server host or a group of SQL Server hosts by running multiple
Collect-HostPerfmonData.ps1
commands.
Summary
This chapter illustrated how to collect SQL Server-related performance data on different SQL Server
instances, and host-related performance data from the host, and import them into the inventory
server database. This chapter should have given you a general idea of how to use dynamic management
views, Windows PowerShell, and stored procedures to get performance-related data. It is hoped that
the information provided here enables you to develop your own code or modify these codes to fit your
needs.
Search WWH ::
Custom Search