Skip to main content

Introduction

This document has as main objective the description of the massive monitoring of performance counters in Windows environments with an integrated SQL service.

To extract the information, it uses performance counters of the Windows system, as well as queries through the sqlcmd command (invoke-sqlcmd in powershell):

• Powershell 2.0 Console (installed by default in Windows Server 2008 R2, and Windows 7. Available from Windows XP SP2 forward)
• An “open” interface (Pandora's as extension of the administration section) to specify free SQL queries.
• The system counts with a Pandora Windows agent installed and has the capacity to distribute file collections, so it is possible to distribute the plugin and the configuration file using Policies.
• SQLPS.exe, this is, the SQL Server administration console for Powershell.
• Install invoke-sqlcmd command in Powershell
• With the agent installation is distributed some commands as grep, gawk …, if pandora_agent system path is not included in the system path, these executables will be added into any system path.

It is important to say that the plugin of Performance Counters monitoring could be used to collect information of numerical kind (to do performance management)