DPA - Number of Blocked Sessions

alekrist

Hi,

I am trying to extract data from the dpa_repository on number of blocked sessions from my Sybase Instance, i.e. the data that serves the graphical feature in DPA referenced below.

My assumption was that I could do that with a simple query to the repository:

select * from con_metrics_detail_1

where metrics_id = 8

Metrics_ID 8 is "Blocked Sessions" in CON_METRICS_NAME_1.

The problem is that the query returns a value of 128 for every row in the entire series which is puzzling. It works just fine in DPA, i.e. it is showing the number of blocks correctly (note that I took these two screenshots at two different times and are not connected).

Any idea how I can extract the number of blocks with along with the corrensponding timestamp?

Best regards

darichar

Hmmm, the metrics_id value can change per monitored instance, so here is a query that I use. See if this works any differently for you:

Note: replace the NAME = criteria with the instance name as shown in the DPA Home page

DECLARE @DBID varchar(5), @SQL varchar(1000);

select @DBID = ID from ignite.COND where NAME = '<name as on DPA Home page>';

SET @SQL = 'select D as [Timestamp], V as [Value]

from ignite.CON_METRICS_DETAIL_'+@DBID+'; md

inner join ignite.CON_METRICS_NAMES_'+@DBID+'; mn ON mn.ID = md.METRICS_ID

where mn.NAME = ''Blocked Sessions''

and D >= ''2018-Dec-01 00:00''

order by D';

EXEC (@SQL)