creation_time           last_execution_time     row_no               l1                   total_worker_time                       AvgCPUTime                              LogicalReads         LogicalWrites        execution_count      AggIO                AvgIO                                   query_text                                                                                                                                                                                                                                                       db_name                                                                                                                          object_id
----------------------- ----------------------- -------------------- -------------------- --------------------------------------- --------------------------------------- -------------------- -------------------- -------------------- -------------------- --------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -----------
2008-03-11 12:54:02.190 2008-03-11 12:54:02.200 1                    1                    259.884000                              259.884000000000000000                  0                    0                    1                    0                    0.000000000000000000                    select   	category_id,     /*1*/	category_name,	    /*2*/	type,      	        /*3*/	j.trace_event_id,   /*4*/	name,               /*5*/	j.trace_column_id,  /*6*/	subclass_value,     /*7*/	subclass_name from  /*8*/  ( 	select a.category_id, a.name as catego NULL                                                                                                                             NULL
2008-03-11 13:41:41.290 2008-03-11 13:45:55.837 2                    0                    392.260000                              130.753333333333333333                  49470                0                    3                    49470                16490.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 12:53:19.697 2008-03-11 12:55:15.053 3                    1                    259.390000                              86.463333333333333333                   49718                2                    3                    49720                16573.333333333333333333                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:13:13.633 2008-03-11 13:50:37.290 4                    0                    323.872000                              80.968000000000000000                   66032                0                    4                    66032                16508.000000000000000000                SELECT
	--(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	count(a2.name ) as NumberOftables,
	sum(a1.rows) as row_count,
	sum((a1.reserved + ISNULL(a4.reserved,0))* 8) AS reserved, 
	sum(a1.data * 8) AS data,
	sum( NULL                                                                                                                             NULL
2008-03-11 13:15:38.743 2008-03-11 13:36:48.920 5                    1                    145.430000                              72.715000000000000000                   33052                0                    2                    33052                16526.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:00:26.540 2008-03-11 13:00:26.660 6                    0                    72.471000                               72.471000000000000000                   16562                0                    1                    16562                16562.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:37:05.723 2008-03-11 13:37:05.843 7                    1                    71.816000                               71.816000000000000000                   16490                0                    1                    16490                16490.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 12:52:24.600 2008-03-11 12:52:24.600 8                    0                    53.466000                               53.466000000000000000                   0                    0                    1                    0                    0.000000000000000000                    SELECT
CAST(serverproperty(N'Servername') AS sysname) AS [Server_Name],
'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' AS [Server_Urn],
(@@microsoftversion / 0x1000000) & 0xff AS [VersionMajor],
(@@microsoftversion / NULL                                                                                                                             NULL
2008-03-11 12:52:23.707 2008-03-11 12:52:23.747 9                    1                    41.452000                               41.452000000000000000                   4                    0                    1                    4                    4.000000000000000000                    SELECT
cfg.name AS [Name],
cfg.configuration_id AS [Number],
cfg.minimum AS [Minimum],
cfg.maximum AS [Maximum],
cfg.is_dynamic AS [Dynamic],
cfg.is_advanced AS [Advanced],
cfg.value AS [ConfigValue],
cfg.value_in_use AS [RunValue],
cfg.description AS [Des NULL                                                                                                                             NULL
2008-03-11 12:52:37.147 2008-03-11 12:52:37.267 10                   0                    41.149000                               41.149000000000000000                   52                   0                    1                    52                   52.000000000000000000                   SELECT
dtb.name AS [Database_Name],
'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(dtb.name,'''') + ']' AS [Database_Urn],

case 
    when DATABASEPROPERTY(dtb.name,'IsShutDown') is NULL                                                                                                                             NULL

(10 row(s) affected)