mssql_monitor_database
Monitor SQL Server database health in real time to identify performance issues, with optional metrics for tables, queries, locks, replication, and configurable alert thresholds.
Instructions
Get real-time monitoring information for a SQL Server database
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "mssql_monitor_database"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema for table metrics (defaults to dbo) | |
| includeLocks | No | ||
| includeTables | No | ||
| includeQueries | No | ||
| alertThresholds | No | Alert thresholds | |
| connectionString | No | SQL Server connection string (optional; requires --allow-tool-connection-string) | |
| includeReplication | No |