Feature Request - Long-running query to show databasename

oderks

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.

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

oderks

Thank you. Looking forward to it.