Servercounters table

Description

This table contains the metrics related to the print servers. Values taken in the interval defined by the couple cntTIMESLOT and cntLEVEL.

Schema

Field	Type	Required	Primary key	Description
cntDATE	datetime	*		Meter reading date.
cntTIMESLOT	int	*		Optimization key.
cntLEVEL	tinyint	*		Counter granularity level (0=5 min, 1=1 h and 2= 1 day).
cntSERVER	varchar (64)	*		Server identifier as defined in Watchdoc.
cntSRVMEMORY	bigint	*
cntSRVUPTIME	int	*		Time since the Watchdoc server was started (in seconds).
The dlt (delta) fields contain values relative to the interval defined by the couple cntTIMESLOT and cntLEVEL):
dltSRVSQLQUERIES	int	*		Number of SQL queries performed in the interval defined by the CNT timeslot and cntlevel pair
dltSRVDOCSSPOOLED	int	*		Number of docs arrived and analyzed in the interval.
dltSRVPAGESSPOOLED	int	*		Number of pages arrived and analyzed in the interval.
dltSRVDOCSPRINTED	int	*		Number of documents printed in the interval.
dltSRVPAGESPRINTED	int	*		Number of pages printed in the interval.
dltSRVDOCSDELETED	int	*		Number of documents deleted in the interval.
dltSRVPAGESDELETED	int	*		Number of pages deleted in the interval.
cntSRVSTATIONS	int	*		Average number of workstations depending on the server.
cntSRVSPOOLDISKFREE	bigint	*		Minimum size of free disk space in the spooler.
cntSRVFREEMEMORY	bigint	*		Minimum size of free memory on the server.
cntSRVLOADAVERAGE	int	*		Average CPU load in the interval.
cntSRVQUEUEDJOBS	int	*		Average number of documents in the print queue..
cntMOVED	tinyint	*		System field used in a master architecture and used on Watchdoc servers to specify whether the value of the field has been replicated on the master and can therefore be deleted (if NULL or 0, "local" document, if >= 254, archived document that can be deleted).
cntSRVWDVERSION	VARCHAR(64)	*		Highest Watchdoc version in the interval in case an update has been done in the interval).
cntSRVNUMQUEUES	INT			Number of print queues on the server.
cntSRVNUMFIR	INT			Number of network print queues on the server.
cntSRVNUMFIL	INT			Number of local print queues on the server.
cntSRVNUMWES	INT			Number of WES managed by the server.
cntSRVWDLOADAVERAGE	INT			Average CPU load relative to Watchdoc in the interval.
cntSRVSPLLOADAVERAGE	INT			Average CPU load relative to the MSWindows print spooler in the interval.
cntSRVSQLLOADAVERAGE	INT			Average CPU load for SQL in the interval.
cntSRVLDAPLOADAVERAGE	INT			Average CPU load related to AD in the interval.