#44 ASEMON status is empty after added a new server

[Parry Chen]

Recently we added a new server in monitor list,after added the server status is empty,and not able to show date in report,would you advise what's the problem?

Thanks very much

Parry

[Parry Chen]

Added server status in ASEMON

[Jean-Paul Martin]

Hi Parry,
you have to wait some time before all collectors get info
Do you still have missing data ?
Regards
JP

[Parry Chen]

Hi JP,

Yes,We set up the monitor at Oct-18th 15:00 HKT,but the server status is still empty.Not sure if have any problem

Parry

[Jean-Paul Martin]

Did you check if your asemon connection (on monitored server of archive server) is locked due to a tempdb full or log suspend or any problem for creating archive tables (check output of asemon logger)
Regards
JP

[Parry Chen]

Hi JP,

Didn't find any blocking due to tempdb full or log suspend,I just try to re-add the server ,seems same issue. Attached the output of asemon logger as below:
WaitSPID int not null,
WaitKPID int not null,
WaitTime int not null,
ObjectName varchar(30) null,
HeldUserName varchar(30) null,
HeldApplName varchar(30) null,
HeldTranName varchar(255) null,
HeldLockType varchar(30) null,
HeldCommand varchar(30) null,
WaitUserName varchar(30) null,
WaitLockType varchar(30) null,
WaitTranName varchar(255) null,
WaitCommand varchar( 30) null,
WaitProcDBName varchar( 30) null,
WaitProcedureName varchar( 30) null,
HeldSourceCodeID varchar( 30) null,
WaitSourceCodeID varchar( 30) null,
InstanceID tinyint null,
ObjectID int null,
HeldInstanceID int null,
HeldStmtNumber int null,
HeldNumLocks int null,
WaitProcDBID int null,
WaitProcedureID int null,
WaitBatchID int null,
WaitContextID int null,
WaitLineNumber int null,
WaitStmtNumber int null,
ObjectDBName varchar(255) null,
HeldHostName varchar( 30) null,
HeldClientName varchar( 30) null,
HeldClientHostName varchar( 30) null,
HeldClientApplName varchar( 30) null,
HeldProcDBName varchar( 30) null,
HeldProcedureName varchar( 30) null,
WaitApplName varchar( 30) null,
WaitHostName varchar( 30) null,
WaitClientName varchar( 30) null,
WaitClientHostName varchar( 30) null,
WaitClientApplName varchar( 30) null
) lock datapages
create unique index idx on HPPTS02_DeadLock (DeadlockID, ResolveTime, HeldKPID) with ignore_dup_key
create index idx1 on HPPTS02_DeadLock (Timestamp, Interval, DeadlockID)
create table HPPTS02_CnxWaits (
Timestamp datetime not null,
Interval int not null,
Kpid int not null,
Spid int not null,
WaitEventID smallint not null,
Waits int null,
WaitTime int null
) lock datarows
create index idx on HPPTS02_CnxWaits (Timestamp, Kpid, Spid, WaitEventID, Interval )
create table HPPTS02_DataCache (
Timestamp datetime not null,
Interval int not null,
CacheName varchar(30) null,
CacheSearches int null,
PhysicalReads int null,
LogicalReads int null,
PhysicalWrites int null,
Stalls int null
) lock datapages
create index idx on HPPTS02_DataCache (Timestamp, CacheName, Interval)
create table HPPTS02_CnxActiv (
Timestamp datetime not null,
Interval int not null,
Loggedindatetime datetime not null,
Kpid int null,
Spid int null,
CPUTime int null,
WaitTime int null,
LogicalReads bigint null,
PhysicalReads bigint null,
PagesRead bigint null,
PhysicalWrites bigint null,
PagesWritten bigint null,
ScanPgs int null,
IdxPgs int null,
TmpTbl int null,
UlcBytWrite int null,
UlcFlush int null,
ULCFlushFull int null,
Transactions int null,
Commits int null,
Rollbacks int null,
PacketsSent int null,
PacketsReceived int null,
BytesSent int null,
BytesReceived int null,
LocksHeld int null,
tran_name varchar(30) null,
proc_name varchar(30) null,
linenum int null,
memusage int null,
dbid int null,
tmp_pages int null
) lock datapages
create index idx on HPPTS02_CnxActiv (Timestamp, Loggedindatetime, Kpid, Spid, Interval )
create index idx1 on HPPTS02_CnxActiv (Loggedindatetime, Kpid, Spid, Timestamp )

Parry

[Jean-Paul Martin]

Hi Parry, can you attach the full output of asemon_logger since it started
I don't see any problem with data you sent me
Regards
JP