Chapter 2: Data Items and Statistical Types

Data items and views

A view usually contains a mix of key and result data items. This mixture of keys and results provides flexibility in determining the amount of detail of the data to be returned. The exception is server-wide data, such as transaction or network activity data. For server-wide data, no key data items are specified and only one row of data is returned.

Table 2-1 shows examples of data returned by views.

**Table 2-1: Examples of data returned by views**
View defined with	Returns
SMC_NAME_PAGE_IO	page I/Os for the whole server Row results: Page I/O --------- 145
SMC_NAME_SPID, SMC_NAME_LOGIN_NAME, SMC_NAME_PAGE_IO (where SPID is a key data item)	page I/O per process Row results: SPID Login Name Page I/O --------------------------- 3 sa 45 5 joe 100
SMC_NAME_SPID, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_DB_NAME, SMC_NAME_OBJ_NAME, and SMC_NAME_PAGE_IO (where SMC_NAME_SPID, SMC_NAME_DB_ID, and SMC_NAME_OBJID are key data items)	page I/O per database table per process Row results: SPID DBID ObjID DBName ObjName PageIO ------------------------------------------------ 1 5 208003772 pubs2 titles 10 1 5 336004228 pubs2 blurbs 5 5 5 22003430 pubs2 sales 100

Table 2-1: Examples of data returned by views

View defined with

Returns

SMC_NAME_PAGE_IO

page I/Os for the whole server

Row results:
    Page I/O
    ---------
    145

SMC_NAME_SPID, SMC_NAME_LOGIN_NAME, SMC_NAME_PAGE_IO

(where SPID is a key data item)

page I/O per process

Row results:
SPID          Login Name        Page I/O
---------------------------
3             sa                45
5             joe               100

SMC_NAME_SPID, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_DB_NAME, SMC_NAME_OBJ_NAME, and SMC_NAME_PAGE_IO (where SMC_NAME_SPID, SMC_NAME_DB_ID, and SMC_NAME_OBJID are key data items)

page I/O per database table per process

Row results:
SPID   DBID  ObjID    DBName   ObjName   PageIO
------------------------------------------------
1       5   208003772  pubs2    titles      10
1       5   336004228  pubs2    blurbs      5
5       5   22003430   pubs2    sales       100

Rows with no data versus no rows in views

View this book as PDF