Avaya VoIP Monitoring Manager Reference Release 3.1 Manual de usuario descargar pdf (Pagina 85)

Avaya VoIP Monitoring Manager Reference

/ * * Dr op t he QOS t abl e i f i t al r eady exi st s. */

I F EXI STS ( SELECT * FROM sysobj ect s WHERE NAME LI KE ' QOS' )

DROP TABLE QOS

/ * * Cr eat e t he QOS t abl e. * /

CREATE TABLE QOS

(

Par t i ci pant I D uni quei dent i f i er not nul l , / * Par t i ci pant I D t hat t hi s

QoS dat a appl i es t o. * /

Ti meOf f set i nt not nul l , / * Ti me of t he QoS ent r y f r om sessi on

st ar t . * /

RTT i nt , / * Round t r i p t i me. */

Ji t t er i nt , / * Ji t t er . * /

Recei vedPacket s i nt , / * Count of RTP packet s r ecei ved si nce

t he l ast t i me an RTCP packet was r ecei ved. * /

Lost Packet s i nt , / * A count of RTP packet s si nce t he l ast

t i me an RTCP packet was r ecei ved. * /

RSVPSt at us t i nyi nt , / * The RSVP st at us met r i c. * /

Number Of Oct et s i nt , / * The Recei ved RTP Oct et s met r i c. * /

Lar gest SequenceJump t i nyi nt , / * The Lar gest sequence j ump met r i c. * /

SequenceJumpI nst ances i nt , / * The number of sequence j ump i nst ances

met r i c. */

Lar gest SequenceFal l t i nyi nt , / * The Lar gest Sequence Fal l met r i c. * /

SequenceFal l I nst ances i nt , / * The number of sequence f al l i nst ances

met r i c. */

TTL t i nyi nt , / * The Ti me To Li ve met r i c. * /

Maxi mumJi t t er i nt , / * The Maxi mum Ji t t er met r i c. * /

Ji t t er Buf f er Over r un t i nyi nt , / * The number of j i t t er buf f er over - r uns

met r i c. */

Ji t t er Buf f er Under r un t i nyi nt , / * The number of j i t t er buf f er under -

r uns met r i c. * /

Ji t t er Buf f er Del ay smal l i nt / * The Ji t t er Buf f er Del ay met r i c. * /

)

/ * * Cr eat e t he QOS t abl e i ndexes. */

CREATE CLUSTERED I NDEX Par t i ci pant I D ON QOS ( Par t i ci pant I D, Ti meOf f set )

/ * * Dr op t he Tr aceRout e t abl e i f i t al r eady exi st s. */

I F EXI STS ( SELECT * FROM sysobj ect s WHERE NAME LI KE ' Tr aceRout e' )

DROP TABLE Tr aceRout e

/ * * Cr eat e t he Tr aceRout e t abl e. * /

CREATE TABLE Tr aceRout e

(

1 2 ... 80 81 82 83 84 85 86 87 88 89 90 ... 113 114

Sin comentarios

Avaya VoIP Monitoring Manager Reference Release 3.1 Manual de usuario Pagina 85