Property Name |
Component Name |
Task Name |
Sample Value |
|---|---|---|---|
NbrRowsPerSecond |
PrimaryCacheSrvr |
PrimaryQueryStats |
0 |
NbrRowsReturned |
PrimaryCacheSrvr |
PrimaryQueryStats |
|
QueryName |
PrimaryCacheSrvr |
PrimaryQueryStats |
Query4 |
QueryTime |
PrimaryCacheSrvr |
PrimaryQueryStats |
0 |
ServerRunning |
VldbServer |
VldbQueryStats |
false |
ServerRunning |
PrimaryCacheSrvr |
PrimaryQueryStats |
false |
Sql |
PrimaryCacheSrvr |
PrimaryQueryStats |
SELECT st.TRADING_SYMBOL,SUM(TRADE_SIZE) as TRADESIZE FROM STOCK_TRADE st inner join INSTRUMENT ii on ii.INSTRUMENT_ID = st.INSTRUMENT_ID inner join SCND_IDST_CLS sc on ii.SCND_IDST_CLS_ID = sc.SCND_IDST_CLS_ID and sc.SIC_NAME = 'COMPUTERS' WHERE TRADE_TI |
