analyze_table_stats
Retrieve table row counts, size details, and last update statistics for SQL Server databases to monitor and optimize database performance. Supports schema-specific filters and optional connection parameters.
Instructions
Get table row counts, size information, and last update statistics
Input Schema
Name | Required | Description | Default |
---|---|---|---|
connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
connectionString | No | SQL Server connection string (uses default if not provided) | |
schema | No | Schema name (default: dbo) | |
tableName | No | Filter by specific table name |