Options
Feature Request - Long-running query to show databasename
oderks
Posts: 67 Bronze 2
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.
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.
Comments
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
Project Manager
Red Gate Software