# New Feature request for Toad-SS Results ( Advanced Results) **URL:** \ **Category:** Toad for SQL Server\ **Created:** [June 15, 2011, 1:43pm UTC](https://forums.toadworld.com/t/new-feature-request-for-toad-ss-results-advanced-results/14497 "2011-06-15T13:43:24Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![hfreeman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hfreeman/32/54_2.png) [@hfreeman](https://forums.toadworld.com/u/hfreeman)\ **Post date:** [June 15, 2011, 1:43pm UTC](https://forums.toadworld.com/t/new-feature-request-for-toad-ss-results-advanced-results/14497/1 "2011-06-15T13:43:24Z")
New feature request for Toad-SS and it also may be useful in TDA. Please add an option to results for advanced results which would give a process/sessionid execution time in hrs., mins., secs., cpu\_time, read, writes, Logical\_reads. Please use the below script as a starting point for getting that information… I find it useful in debugging scripts… select r.session\_id , substring (qt.text,r.statement\_start\_offset / 2 , ( case when r.statement\_end\_offset = - 1 then len ( convert (nvarchar( max ), qt.text)) \* 2 else r.statement\_end\_offset end - r.statement\_start\_offset) / 2 ) as query\_text — this is the statement executing right now ,((r.total\_elapsed\_time / 1000 ) / 60 ) / 60 as ‘Hrs’ ,(r.total\_elapsed\_time / 1000 ) / 60 - (((r.total\_elapsed\_time / 1000 ) / 60 ) / 60 ) \* 60 as ‘Mins’ , r.total\_elapsed\_time / 1000 - ((r.total\_elapsed\_time / 1000 ) / 60 ) \* 60 as ‘Secs’ ,r.status ,wait\_type ,r.blocking\_session\_id as blocked\_by ,r.cpu\_time ,r.reads ,r.writes ,r.logical\_reads ,r.scheduler\_id from sys.dm\_exec\_requests r cross apply sys. dm\_exec\_sql\_text (sql\_handle) as qt where r.session\_id \> 50 –and status=‘suspended’ order by total\_elapsed\_time desc , r.cpu\_time desc Hank Freeman Senior SQL Server DBA/Data & Systems Architect [hfreeman@msn.com](mailto:hfreeman@msn.com) 678-414-0090 my cell Primary hank.freeman50 via Skype ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/cabfc34883d789b38492750ba5b372633206ba50.jpeg) ![image001.gif](https://global.discourse-cdn.com/quest/original/1X/c419a4884cb60937895dfef6b4b6862a4a679db6.gif) ![image002.jpeg](https://global.discourse-cdn.com/quest/original/1X/ca60ef1b55129d126c1774d4371b31a0a5bd7429.jpeg) ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/e05939412b32656cff5bcfc7d2adf2a2a20a6d25.jpeg)