Configuring Microsoft SQL Server monitoring

You must configure the Monitoring Agent for Microsoft SQL Server so that the agent can collect data from the application that is being monitored.

Before you begin

Review the hardware and software prerequisites. For the up-to-date system requirement information, see the Software Product Compatibility Reports (SPCR) for the Microsoft SQL Server agent.

You can install and configure the Microsoft SQL Server agent locally by using the command prompt interface. Ensure that the agent is installed on the server that is being monitored.

About this task

The directions here are for the most current release of this agent. For information about how to check the version of an agent in your environment, see Agent version command. For detailed information about the agent version list and what's new for each version, see Change history.

The Microsoft SQL Server agent is a multiple instance agent; you must configure and start each agent instance manually.

  • To configure the agent, complete the following tasks:
    • Create a user and grant the required permissions
    • Select the databases for monitoring
    • Configure the local environment variables
  • To run the agent in a cluster environment, complete the steps that are described in the Running the agent in a cluster environment topic.