Can SQL Monitor capture stored procedure parameters?

slimshaky

Does SQL Monitor have any built in capabilities to capture stored procedure parameters? This would be particularly useful to do when certain key alerts are triggered, such as a long running stored procedure.

Russell D

Currently I'm afraid not, so this is a feature request which is best placed over on the SQL Monitor Uservoice: https://sqlmonitor.uservoice.com/forums/91743-suggestions/.

The reason we don't do this is due to our agentless architecture. SQL Monitor cannot do this without incurring a significant performance overhead on the monitored entity. Other tools that do this tend to hook into client code or otherwise intercept requests from managed code, which is more invasive and intensive than we want to be.