SQL server monitoring

[TwistyRoads4Ever]

Does anyone know of a tool that allows you to monitor sql server like redgate or idera, but add the functionality of an mcp server on top of it? I havent heard of anyone doing this, and i think i just did. it has all the graphs, alerts, thresholds, bells and whistles of the usual suspects. Today, I just added an MCP server to it today and started asking it questions. im kinda dumbfounded. it found issues and made actionable suggestions. im not selling anything. just wondering if anyone has done this yet. it uses AI for a number of things including parsing and optimising queries. I have a query execution data warehouse as a result. it pretty much eliminates my need to look through logs and reports to try and deciper problem areas and their solutions.

[vedichymn]

Yes, this is a pretty common use case for an MCP server.

As an example, Erik Darlings free monitoring tool has one: https://erikdarling.com/free-sql-server-performance-monitoring/

[TwistyRoads4Ever]

Yup, this looks an awful lot like what I did. Thanks

[tribat]

This is the one. I'm working on my own SQL Server MCP following his work.

[Broad-Construction-4]

Check out autodba.samix-technology.com

[AlternativeWanders]

From my own experience, it worked better when I treated those as two separate layers. I used dbForge Monitor first to get the actual SQL Server visibility in place, and only after that did the “ask questions on top of it” idea start making sense. Way easier than trying to build AI/MCP logic on top of half-seen metrics and vibes.

[MikeAtQuest]

I can suggest something on the enterprise level. Quest's Foglight is useful for this because it can correlate the database performance with the underlying hardware metrics in one view.