Avaya VoIP Monitoring Manager Reference Release 3.0 Manual de usuario descargar pdf (Pagina 113)

Troubleshooting

105

/ * * 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)

/ * * 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

(

Par t i ci pant I D uni quei dent i f i er not nul l , - - The par t i ci pant I D f or whi ch t he QOS sampl es

ar e r ecor ded.

Ti meOf f set i nt not nul l , - - Ti me of f set of t he t r ace r out e f r om t he sessi on st ar t .

HopI ndex t i nyi nt , - - Hop count i ndex.

HopAddr ess1 t i nyi nt , - - I P Addr ess f or t he net wor k hop ( Oct ect 1) .

HopAddr ess2 t i nyi nt , - - I P Addr ess f or t he net wor k hop ( Oct ect 2) .

HopAddr ess3 t i nyi nt , - - I P Addr ess f or t he net wor k hop ( Oct ect 3) .

HopAddr ess4 t i nyi nt , - - I P Addr ess f or t he net wor k hop ( Oct ect 4) .

HopTi me smal l i nt - - Round t r i p del ay t o t he hop addr ess i n mi l l i seconds.

)

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

CREATE CLUSTERED I NDEX Par t i ci pant I D ON Tr aceRout e ( Par t i ci pant I D)

/ * * Dr op t he Conf i gur at i on 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 ' Conf i gur at i on' )

DROP TABLE Conf i gur at i on

/ * * Cr eat e t he Conf i gur at i on t abl e. */

CREATE TABLE Conf i gur at i on

(

Dat abaseVer si on i nt not nul l - - Dat abase ver si on number .

)

1 2 ... 108 109 110 111 112 113 114 115 116 117 118 ... 141 142

Sin comentarios

Avaya VoIP Monitoring Manager Reference Release 3.0 Manual de usuario Pagina 113