How can we help you today? How can we help you today?

Feature Request - Long-running query to show databasename

On top row I see: [Medium] Long-running query <hostname>\(local)

Process ID: 73
Process name: 2007 Microsoft Office system
Host: <hostname running query>
User: <username connecting database>
Process login time: 8 Mar 2011 2:07 PM
SQL process fragment
SELECT "dbo"."Log".* FROM "dbo"."Log"

I'm very glad I know <hostname>\(local) and why user <username connecting database> could be query'ing there. For other queries that can be a huge hassle to find out what database that sql process was running against.

Therefore I'd like the databasename stated in the info above. Would save me a lot of time on some (most) occasions.
oderks
0

Comments

2 comments

Sort by
  • priyasinha
    Hi,

    Thanks for your post.

    I am glad to say that this has already been implemented internally for "Long-running query" and "Blocked process" alert. This will release as part of 2.3 release.

    Thanks,
    Priya
    priyasinha
    0
  • oderks
    Thank you. Looking forward to it.
    oderks
    0

Add comment

Please sign in to leave a comment.