Fig 1.3
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: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: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: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: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: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 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 13:16:01.277 2008-03-11 13:16:01.417 17 1 12.272000 12.272000000000000000 1384 0 1 1384 1384.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:16:15.917 2008-03-11 13:48:24.110 16 0 25.138000 12.569000000000000000 2756 0 2 2756 1378.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:51.600 2008-03-11 13:15:51.770 15 1 12.589000 12.589000000000000000 1360 0 1 1360 1360.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:34:20.777 2008-03-11 13:36:39.327 19 1 28.477000 9.492333333333333333 2325 0 3 2325 775.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. master 1403152044 (10 row(s) affected)
Fig 1.3