Discover Method Part 2

Lets look at some more Discover Commands . Many of this commands are not documented at BOL .

For previous part of this article
Discover Method Part 1

Provides information for memory usage by each object

SELECT *
FROM SYSTEMRESTRICTSCHEMA (
$SYSTEM.DISCOVER_MEMORYUSAGE)

Provides information for transaction

SELECT *
FROM SYSTEMRESTRICTSCHEMA (
$SYSTEM.DISCOVER_TRANSACTIONS)

Provides performance counter details

SELECT *
FROM SYSTEMRESTRICTSCHEMA (
$SYSTEM.DISCOVER_PERFORMANCE_COUNTERS,
PERF_COUNTER_NAME = ‘\MSAS 2005:Memory\Memory Usage KB’)

Provides information for sessions

SELECT *
FROM SYSTEMRESTRICTSCHEMA (
$SYSTEM.DISCOVER_SESSIONS)

Provides information for selected partition

SELECT *
FROM SYSTEMRESTRICTSCHEMA
(
$SYSTEM.DISCOVER_PARTITION_STAT
,DATABASE_NAME = ‘Adventure Works DW 2008’
, CUBE_NAME=’Adventure Works’
,MEASURE_GROUP_NAME = ‘INTERNET SALES’
,PARTITION_NAME = ‘Internet_Sales_2002’
)

Provides information for dimensions related to partition

SELECT *
FROM SYSTEMRESTRICTSCHEMA
(
$SYSTEM.DISCOVER_PARTITION_DIMENSION_STAT
,DATABASE_NAME = ‘Adventure Works DW 2008’
, CUBE_NAME=’Adventure Works’
,MEASURE_GROUP_NAME = ‘INTERNET SALES’
,PARTITION_NAME = ‘Internet_Sales_2002’
)

Provides information for Dimensions

SELECT *
FROM SYSTEMRESTRICTSCHEMA (
$SYSTEM.DISCOVER_DIMENSION_STAT
, DIMENSION_NAME = ‘Customer’
, DATABASE_NAME=’Adventure Works DW 2008′
)

Provides attribute name and attribute count for the dimension