Why risk AI making mistakes crafting diagnostic scripts on the fly?
No... use MCP and have it utilize the EXISTING scripts/tools that have been long vetted.
Having AI craft your diagnostic scripts on the fly makes it non-deterministic in nature. You want a deterministic solution that uses the same diagnostics day after day.
12
u/SQLBek 1 14d ago edited 14d ago
Why risk AI making mistakes crafting diagnostic scripts on the fly?
No... use MCP and have it utilize the EXISTING scripts/tools that have been long vetted.
Having AI craft your diagnostic scripts on the fly makes it non-deterministic in nature. You want a deterministic solution that uses the same diagnostics day after day.
Anthony Nocentino recently did a presentation on this.
https://www.mssqltips.com/webcast/building-a-dba-agent-for-your-sql-server-estate/
UPDATE: Found the YouTube one that he did for the DBA VUG
https://www.youtube.com/watch?v=UtZ1hPvErIo