6.1. Collectors
Collectors are data collection threads that pull metrics from monitoring interfaces of Operating Systems and Databases Mangement Systems. Each one is configured through at least one - but not limited to one - policy, whether it is enabled and how often it is scheduled to select metrics. The default collection interval is 60 seconds which is good at first but can lead to a high amount of data for those collectors pulling more than one row per interval. We recommend to adjust to a lower interval (like 15min) for collectors that can collect a lot of data (see collector list and the "many data" tag - data amount depends on number of objects). The configuration is done via Web Frontend: menu → configuration → Policies
Speedgain for Databases has the following build-in collectors:
6.1.1. Db2
Name |
GA Version |
comment |
clusterhoststate |
1.4.0 |
purescale |
envcfsysresouces |
1.4.0 |
purescale |
envgetsystemresources |
1.3.0 |
|
envinstinfo |
1.4.0 |
|
getinstanceinfo |
1.4.0 |
purescale |
lockeventmonitor |
1.2.0 |
|
mongetactivity |
1.0.0 |
|
mongetbufferpool |
1.0.0 |
|
mongetcf |
1.4.0 |
purescale |
mongetconnection |
1.0.0 |
many data |
mongetcontainer |
1.0.0 |
many data |
mongetdatabase |
1.0.0 |
mandatory |
mongetextendedlatchwait |
1.0.0 |
|
mongethadr |
1.2.0 |
|
mongetindex |
1.0.0 |
many data |
mongetlatch |
1.3.0 |
|
mongetmemorypool |
1.0.0 |
|
mongetpageaccessinfo |
1.5.0 |
purescale |
mongetpkgcachestmt |
1.0.0 |
many data |
mongetroutine |
1.0.0 |
|
mongetservicesubclass |
1.2.0 |
|
mongetservicesuperclass |
1.2.0 |
|
mongettable |
1.0.0 |
many data |
mongettablespace |
1.0.0 |
|
mongettransactionlog |
1.0.0 |
|
mongetutility |
1.2.0 |
|
mongetworkload |
1.2.0 |
|
monlockwaits |
1.0.0 |
6.1.2. PostgreSQL
Name |
GA Version |
comment |
pglswaldir |
1.0.0 |
|
pgmonlockwaits |
1.0.0 |
|
pgsettings |
1.0.0 |
|
pgstatactivity |
1.0.0 |
|
pgstatdatabase |
1.0.0 |
mandatory |
pgstatreplication |
1.0.0 |
|
pgstatstatements |
1.0.0 |
many data |
pgtablespace |
1.0.0 |
6.1.3. SQL Server
Name |
GA Version |
comment |
configurations |
1.3.0 |
|
databases |
1.3.0 |
|
dmdbfilespaceusage |
1.3.0 |
|
dmiovirtualfilestats |
1.3.0 |
|
dmosperformancecounters |
1.3.0 |
mandatory |
dmoswaitstats |
1.3.0 |
|
ringbufferschedulermonitor |
1.3.0 |
CPU-metric |
backupset |
1.3.5 |
|
dmdbindexoperationalstats |
1.3.5 |
|
dmdbindexphysicalstats |
1.3.5 |
long runtime in large databases |
dmdbindexusagestats |
1.3.5 |
|
dmdbmissingindexdetails |
1.3.5 |
|
dmexecquerystats |
1.3.5 |
many data |
dmexecsessions |
1.3.5 |
live data |
dmexecsessionwaitstats |
1.3.5 |
6.1.4. Azure SQL Database
Name |
GA Version |
comment |
azdatabasescopedconfigurations |
1.5.0 |
|
azdmdbfilespaceusage |
1.5.0 |
|
azdmdbindexoperationalstats |
1.5.0 |
|
azdmdbindexphysicalstats |
1.5.0 |
long runtime in large databases |
azdmdbindexusagestats |
1.5.0 |
|
azdmdbmissingindexdetails |
1.5.0 |
|
azdmdbresourcestats |
1.5.0 |
mandatory |
dmexecquerystats |
1.5.0 |
many data |
azdmexecrequests |
1.5.0 |
Live Board; everything except blocking information is deleted after 7 days |
azdemexecsessions |
1.5.0 |
Long term collector of aggregated session information |
azdmexecsessionwaitstats |
1.5.0 |
|
azdmosperformancecounters |
1.5.0 |
|
azdmoswaitstats |
1.5.0 |
|
azdmuserdbresourcegovernance |
1.5.0 |
mandatory |
azindexcolumns |
1.5.0 |
generates many iops in large databases; be careful before activating this collector with parameter "include_index_columns=true" |
6.1.5. Oracle
Name |
GA Version |
comment |
database |
1.5.0 |
mandatory |
datafileusage |
1.5.0 |
|
dbawaiters |
1.5.0 |
|
instance |
1.5.0 |
mandatory |
osstat |
1.5.0 |
|
pdbs |
1.5.0 |
|
pgastat |
1.5.0 |
mandatory |
session |
1.5.0 |
mandatory |
sesstat |
1.5.0 |
|
sesstimemodel |
1.5.0 |
|
sga |
1.5.0 |
|
sgainfo |
1.5.0 |
mandatory |
sqlstats |
1.5.0 |
|
systemevent |
1.5.0 |
|
systemwaitclass |
1.5.0 |
|
systimemodel |
1.5.0 |
6.1.6. Linux
Name |
GA Version |
comment |
linuxdiskfree |
1.5.0 |
|
linuxprocdiskstats |
1.0.0 |
|
linuxprocloadavg |
1.0.0 |
|
linuxprocmeminfo |
1.0.0 |
|
linuxprocstat |
1.0.0 |
mandatory |