Post reply

Dashboard for a specific SP executions status

  • February 12, 2014 at 10:47 pm

    #396262

    I am required to provide a dashboard for recent and ongoing executions of specific stored procedures. Dashboard will show the execution status and will mark the delay in SP completion according to given threshold. Can you suggest any third party monitoring tool that provides such granular functionality with dashboards.

    Thanks & Regards

    DBDigger Microsoft Data Platform Consultancy.

  • February 13, 2014 at 8:05 am

    #1688756

    For just queries... I'd suggest going with Solarwindows (formerly Confio) Ignite. That's one of the best third party tools for just going after query performance. It's not so good with general monitoring.

    You might be better off for such a narrow requirement to build it on your own using extended events.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 14, 2014 at 12:50 am

    #1688986

    Thanks for advice. I will be analyzing these options.

    DBDigger Microsoft Data Platform Consultancy.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply