<< SQL - Memory Usage | 2008 Coding Challenge I >>

SQLCLR - Tasks

By at October 12, 2007 07:15
Filed Under:

select  os.task_address,
        os.state,
        os.last_wait_type,
        clr.state,
        clr.forced_yield_count
from    sys.dm_os_workers os
        join sys.dm_clr_tasks clr on os.task_address = clr.sos_task_address
where   clr.type = 'E_TYPE_USER'

Tags:

Comments (7) E-mail Kick it! DZone it! del.icio.us Permalink Post RSS

Comments

2/10/2010 3:20:28 AM #

Would you equal to base a journalist place on my journal?

Regards

kails

pet potty grass | Reply

3/17/2010 4:37:18 PM #

Are you sure this works to clear all the tasks. I have tried this and it did not work. Will give it another shot. Thanks!

Chapel Hill Real Estate | Reply

3/20/2010 11:42:36 PM #

I have tried this and it did not work. Will give it another shot. Thanks!

cheap prom Dresses | Reply

3/27/2010 9:02:36 PM #

Superb post, this is very similar to a site that I have. Please check it out sometime and feel free to leave me a comenet on it and tell me what you think. I'm always looking for feedback.

Karl Oris | Reply

5/11/2010 3:11:57 AM #

I found this amazing post whilst scouting thru search engine. Incredibly amazing, in view that search engine listings can display rather aged outcomes apart from is definately most current! Either way, incredibly illuminating, especially as this is not really a thing many people generally write some thing decent regarding. All the best.

Link Building | Reply

6/4/2010 6:30:56 AM #

Really good site, where did you come up with the information in this summary? Im glad I found it though, ill be checking back soon to see what other articles you have.

Louie Gastelo | Reply

6/7/2010 5:51:03 PM #