Sunday Cycling Path : 17 mi.

• Posted by ehosca on October 21, 2007
• 1 comments

SQLCLR - Tasks

• Posted by ehosca on October 12, 2007
• 0 comments

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'

SQL - Memory Usage

• Posted by ehosca on October 12, 2007
• 0 comments

select type, sum(virtual_memory_reserved_kb) as [VM Reserved], sum(virtual_memory_committed_kb) as [VM Committed], sum(awe_allocated_kb) as [AWE Allocated], sum(shared_memory_reserved_kb) as [SM Reserved], sum(shared_memory_committed_kb) as [SM Committed], sum(mu... [More]

SQLCLR - AppDomain State

• Posted by ehosca on October 12, 2007
• 0 comments

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(... [More]