Report for Database Transactions per Second

FormerMember

Hi, I am looking for a min/max/avg type of report for DB transactions/sec. I was able to come up with this for current data, but no amount of digging thru the db can let me find where the history data for this is kept. It must be somewhere, since I can look on a db by db basis and chart it. Any help would be appreciated, thanks!

 

select distinct top 20 a.nodeid,

            a.nodename as NodeName,

            a.componentid,

            b.name as DatabaseName,

            b.id,

            a.statisticdata as TransactionsPerSecond,

            d.Name as Component

  from apm_sqlbbcomponentalertsdata a inner join apm_componentext d on a.ComponentID = d.id

           inner join apm_sqlbbcurrentdatabases b on d.ApplicationItemID = b.id

  where d.name = 'Transactions/Sec'

  order by a.StatisticData desc

zackm

try this to find your historical data:

select * from dbo.APM_StatisticsUsagewhere componentid in  (select componentid  from apm_sqlbbcomponentalertsdata  where componentname like 'Transaction%')

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems