Michael Fuller

Show user friendly job_name in top level column program_name instead of job_id in hex

10

Just wondering the possibility of returning the job name in the top level column [program_name] instead of its [job_id] in hex?  At the top level its nice to see...

Change the DMV we get the status from to sys.dm_exec_sessions instead of sys.sysprocesses

2

Change the DMV we get the status from to sys.dm_exec_sessions instead of sys.sysprocesses. This so we can see the sessions running state instead of only runnable. Literally changing one line...

Hey guys, I just ran into this when monitoring an index creation script. The IO appears frozen, but if I look at in sp_who2 results I can see its not....

Request to incorporate the page density (**avg_page_space_used_in_percent**) as a determining factor in deciding whether or not to rebuild the index. Given that we are using modern solid-state drives, fragmentation alone...

When the parameter is passed, the system now reveals the actual job name in the field—replacing hex step identifiers. This improvement makes it significantly easier to identify and understand running...