<< SMO : Backup All Databases | SQL - Memory Usage >>

SQLCLR - AppDomain State

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

SELECT
  timestamp,
  rec.value('/Record[1]/AppDomain[1]/@address', 'nvarchar(10)') as address,
  rec.value('/Record[1]/AppDomain[1]/@dbId', 'nvarchar(4)') as dbid,
  rec.value('/Record[1]/AppDomain[1]/@ownerId', 'nvarchar(5)') as ownerid,
  rec.value('/Record[1]/AppDomain[1]/@type', 'nvarchar(32)') as type,
  rec.value('/Record[1]/AppDomain[1]/State[1]', 'nvarchar(32)')as state
FROM (
      SELECT timestamp, cast(record as xml) as rec 
      FROM sys.dm_os_ring_buffers 
      WHERE ring_buffer_type = 'RING_BUFFER_CLRAPPDOMAIN'
      ) T(timestamp, rec) 
ORDER BY timestamp DESC

Tags:

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

Comments

1/21/2010 9:48:02 AM #

What is the meaning of this codes pls?

Bowtrol colon | Reply

2/9/2010 3:52:55 AM #

Hmm eery this occupation is totaly moot to the activity ask I entered in google but it was recorded on the premiere page.

Regards
johney

how to cure acne | Reply

2/9/2010 3:57:38 AM #

I similar your diary curently we are superficial for a move term article writer would you be involved?

Regards
stefan

how to cure pimples | Reply

2/9/2010 8:38:08 AM #

Hmm singular this instal is totaly digressive to the look ask I entered in google but it was recorded on the original attender.

Regards
martin

how to get rid of pimples | Reply

3/13/2010 2:44:37 AM #

Hvala vam za dobar post puno hvala

general electric cooktop | Reply

3/17/2010 4:32:34 PM #

This is a really nice article. I am sure a lot of people will benefit from it. Thanks!

Chapel Hill Real Estate | Reply

3/20/2010 11:43:19 PM #

I am sure a lot of people will benefit from it. Thanks!

cheap prom Dresses | Reply

3/21/2010 5:45:34 PM #

I think this is one of the best articles out there. RESPECT!

Lianne Ree | Reply

6/5/2010 6:20:09 AM #

I think this is one of the best sites out there. It has so much information. RESPECT!

Lace Wigs | Reply

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

Thank you for taking the time to write this brilliant article. I'll be sure to share this with my friends. Thank you!

toronto real estate agents | Reply

7/10/2010 1:59:37 AM #

This is the perfect blog for anyone who wants to know about this topic. You know so much its almost hard to argue with you (not that I really would want...HaHa). You definitely put a new spin on a subject thats been written about for years. Great stuff, just great!

remy hair extensions | Reply

7/22/2010 2:57:16 PM #

Were in the Myrtle Beach market and also have definatly been recently impacted because of the market

Myrtle Beach Foreclosures | Reply

8/1/2010 3:36:52 PM #

I don’t agree with most people here; since I found this blog post I couldn't stop until , while it wasn't just what I had been trying to find, was a fantastic read though. I will instantly get your blog feed to stay informed of any updates.

make money on the web | Reply

8/3/2010 12:09:46 AM #

All new to me; I didn’t know the many ripples and depth to the case until I surfed here through Bing! Fantastic job.

male fertility test | Reply

8/3/2010 1:28:34 AM #

I disagree with most guys here; I started reading this blog post I couldn't stop until I was done, even though it wasn't just what I had been trying to find, was still a nice read though. I will instantly take your blog feed to stay in touch of any updates.

enlast review | Reply

8/3/2010 3:17:24 AM #

In point of fact, I’m just starting out in management media and working on to learn how to do it well - resources like this blog post are very helpful. As our website is based in the US, is kind of new to us The case mention is something that I worry too well, how to show your own genuine enthusiasm and contribute to the community.

hgh energizer review | Reply

8/3/2010 6:09:48 AM #

Hi, probably I will be some how off topic here, however I had been reading your blog and it seems outstanding!. I’m creating a web site and attempting to make it appear clean, however everytime I touch it I mess something up. Did you build and style the blogsite by yourself? Can somebody with very little technical knowleadge do it, as well as add updates without messing it up? Anyway, great information on here, extremely helpful.

bowtrol | Reply

8/6/2010 2:23:01 AM #

Great Article - we are hopefully planning to notice far better things happening locally soon

dave | Reply

8/12/2010 6:59:18 AM #

looks great I was planning to subscribe to your blog

tom | Reply

8/14/2010 8:28:10 PM #

with the real estate market hopefully picking up perhaps I will hire a new assistant and have time to maintain with my blog

jason | Reply

8/14/2010 10:14:54 PM #

The marketplace is cynical - hopefully it's going to swing back again our way soon too

mark | Reply

8/15/2010 3:42:11 PM #

Many thanks for making a truthful effort to explain this. I feel very strong about it and would like to read more. If you can, as you find out more in depth knowledge, would you mind posting more posts similar to this one with more information?

infertility test | Reply

8/17/2010 3:42:35 AM #

I disagree with most folks here; I started reading this blog post I couldn't stop until , while it wasn't just what I had been trying to find, was indeed a great read though. I will immediately get your blog feed to stay in touch of future updates.

how to make your breasts bigger | Reply

8/17/2010 5:00:25 AM #

In fact, I’m just getting my feet wet in management media and working on to find out how to do it well - resources like this article are very helpful. As our Site is based in the US, it’s all a bit new to us. The reference mention is something that I worry too well, how to show your own authentic enthusiasm and contribute to the opportunity.

how to get bigger breast naturally | Reply

8/30/2010 10:58:21 AM #

Hey, maybe I am being a little bit off topic here, however I had been checking your website and it seems outstanding!. I’m creating a web site and attempting to make it appear clean, however every single time I touch it I screw something up. Did you design and style the website by yourself? Can a person with very little technical knowleadge do it, as well as add frequent updates without messing it up? Anyway, great information on here, extremely helpful.

how to make your breasts bigger | Reply

8/31/2010 11:44:00 AM #

I disagree with most people here; I started reading this post I couldn't stop until I was done, even though it wasn't just what I had been trying to find, was indeed a great read though. I will instantaneously take your feed to maintain informed of future updates.

internet income | Reply

8/31/2010 7:56:53 PM #

In point of fact, I’m just beginning in marketing media and trying to learn how to do it well - resources like this blog post are incredibly helpful. As our Site is based in the US, is kind of new to us The reference above is something that I worry too well, how to show your own authentic enthusiasm and share to the opportunity.

buy virility ex | Reply

9/1/2010 8:49:25 PM #

Many thanks for making the sincere effort to explain this. I feel very strong about it and would like to read more. If it's OK, as you learn more in depth knowledge, would you mind posting more articles similar to this one with more information?

niche blue print 2.0 reviews | Reply

9/7/2010 4:53:58 PM #