Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

Better "program name" for jobs in dm_exec_sessions

When reviewing session activity using sys.dmexecsessions, I see items in the program name column like:

SQLAgent - TSQL JobStep (Job 0x452FE49D5B63B84091F613691331151E : Step 6)

Yuck. On a busy system, I am expected to either memorize all these job representations, or write my own query that joins and figures out what job that really is.

If I capture session activity at a point in time, and then have to go re-query to figure out which job that is, I'm wasting potentially valuable time.

0 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
unplanned  ·  AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded  · 

Upvotes: 1

<=-=Jun 6 2007 12:40PM=-=>

Aaron,

Thanks for the report. We’ll investigate to see if a friendlier name makes sense….

-Richard Waymire

<=-=Oct 31 2008 10:21AM=-=>

Hi,

We are considering it for the next release,

Thanks,

Gil

<=-=Jul 27 2009 9:54AM=-=>

Aaron -

Thank you for your feedback; but we won’t be fixing this for our next release.

Thanks,

Amy Lewis

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment

SQL Server: Suggestions

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice