In TrueSight, monitoring profiles are profiles to which the monitor types (application classes) you want to enable are associated. Each KM contains multiple monitoring profiles and help to reduce unnecessary monitoring. Each monitoring profile is associated with a group of monitor types. The monitor types that belong to a profile are pre-determined. You cannot add or remove monitor types from a profile.
The Microsoft SQL Server monitor profile contains the following monitor types. By default, these monitor types are also included for monitoring when you configure the Microsoft SQL Server for monitoring.
| |
|---|
| |
- MS SQL Server Agent Health
- MS SQL Server Agent Statistics
- MS SQL Server Always-On Availability Database
- MS SQL Server Always-On Availability Databases
- MS SQL Server Always-On Availability Group
- MS SQL Server Always-On Availability Groups
- MS SQL Server Always-On Availability Listener
- MS SQL Server Always-On Availability Listeners
- MS SQL Server Always-On Availability Replica
- MS SQL Server Always-On Availability Replicas
- MS SQL Server Always-On High Availability
- MS SQL Server Custom SQL queries
- MS SQL Server Custom SQL query
- MS SQL Server Database
- MS SQL Server Database Log Shipping
- MS SQL Server Database Mirroring
- MS SQL Server Databases
- MS SQL Server Database Space
- MS SQL Server Database Space File
- MS SQL Server Database Space Files Group
- MS SQL Server Environment
- MS SQL Server Global Variables
- MS SQL Server Health
- MS SQL Server Host
- MS SQL Server Instance
- MS SQL Server Instances
- MS SQL Server Perfmon Access Methods
- MS SQL Server Perfmon Availability Replica
- MS SQL Server Perfmon Backup Device
- MS SQL Server Perfmon Batch Resp Statistics
- MS SQL Server Perfmon Broker Activation
- MS SQL Server Perfmon Broker DBM Transport
- MS SQL Server Perfmon Broker Statistics
- MS SQL Server Perfmon Broker To Statistics
- MS SQL Server Perfmon Buffer Manager
- MS SQL Server Perfmon Buffer Node
- MS SQL Server Perfmon Buffer Partition
- MS SQL Server Perfmon Catalog Metadata
- MS SQL Server Perfmon CLR
- MS SQL Server Perfmon Columnstore
- MS SQL Server Perfmon Cursor Manager By Type
- MS SQL Server Perfmon Cursor Manager Total
- MS SQL Server Perfmon Database Mirroring
- MS SQL Server Perfmon Database Replica
- MS SQL Server Perfmon Databases
- MS SQL Server Perfmon Deprecated Features
- MS SQL Server Perfmon Exec Statistics
- MS SQL Server Perfmon File Table
- MS SQL Server Perfmon General Statistics
- MS SQL Server Perfmon HTTP Storage
- MS SQL Server Perfmon Instances
- MS SQL Server Perfmon Latches
- MS SQL Server Perfmon Locks
- MS SQL Server Perfmon Logpool Freepool
- MS SQL Server Perfmon Memory Broker Clerks
- MS SQL Server Perfmon Memory Manager
- MS SQL Server Perfmon Memory Node
- MS SQL Server Perfmon Objects
- MS SQL Server Perfmon Plan Cache
- MS SQL Server Perfmon Query Execution
- MS SQL Server Perfmon Query Store
- MS SQL Server Perfmon Replication Agents
- MS SQL Server Perfmon Replication Dist
- MS SQL Server Perfmon Replication Logreader
- MS SQL Server Perfmon Replication Merge
- MS SQL Server Perfmon Replication Snapshot
- MS SQL Server Perfmon Resource Pool Stats
- MS SQL Server Perfmon SQL Errors
- MS SQL Server Perfmon SQL Statistics
- MS SQL Server Perfmon Transactions
- MS SQL Server Perfmon User Settable
- MS SQL Server Perfmon Wait Statistics
- MS SQL Server Perfmon Workload Group Stats
- MS SQL Server Perfmon Xtp Cursors
- MS SQL Server Perfmon Xtp Garbage Collection
- MS SQL Server Perfmon Xtp IO Governor
- MS SQL Server Perfmon Xtp Phantom Processor
- MS SQL Server Perfmon Xtp Storage
- MS SQL Server Perfmon Xtp Transaction Log
- MS SQL Server Perfmon Xtp Transactions
- MS SQL Server Publishers
- MS SQL Server Replication
- MS SQL Server Replication Publisher
- MS SQL Server Replication Subscriber
- MS SQL Server Statistics
- MS SQL Server Subscribers
- MS SQL Server System Databases
| No. You can directly start monitoring of the services when you configure the Microsoft SQL Server monitor type. |