Database Logging - Why are there duplicated items with the same time stamp for the same data item in Database Logging?
Background Copied
By default, the database schema shipped with the gateway prevents duplicates because the time stamp is part of the primary key, however as a DBA you can override this in the database schema directly by changing the primary key. If you do then some situations can result in duplicate time stamps for the same data item in the database:
-
You are using a sampler where the update rate is not restricted, most common among these is the API sampler.
-
The time stamps are being generated by the gateway, and as such it is possible because of delays in processing netprobe updates that two updates get written to the database in the same second.
Possible solutions Copied
You can stop point 2 by using the Advanced tab at the top of the Database Logging section of the gateway setup setting in the gateway and ticking the
Log netprobe sample time for data items
which will use the time stamps at the point of sample from the netprobe rather than the gateway.