
Analizar resultados DBCC CHECKDB
Publicado por Alvaro (3 intervenciones) el 31/10/2013 13:52:46
Hola a tod@s,
Espero que alguien pueda echarme una mana.
Estoy teniendo problemas de tiempo de espera caducado en una base de datos en produccion.
Estamos bastantes desesperados con este tema.
Hemos ejecutado el comando DBCC CHECKDB y nos ha dado el siguiente resultado
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 2753 rows in 26 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 306 rows in 4 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 326 rows in 8 pages for object "sysallocunits".
[...............]
DBCC results for 'LDOCTMP'.
There are 216 rows in 4 pages for object "LDOCTMP".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'TVD'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Mi pregunta es si alguien podria explicarmes que significan los Service Broker Msg [num]
Muchas gracias a todos
Espero que alguien pueda echarme una mana.
Estoy teniendo problemas de tiempo de espera caducado en una base de datos en produccion.
Estamos bastantes desesperados con este tema.
Hemos ejecutado el comando DBCC CHECKDB y nos ha dado el siguiente resultado
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 2753 rows in 26 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 306 rows in 4 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 326 rows in 8 pages for object "sysallocunits".
[...............]
DBCC results for 'LDOCTMP'.
There are 216 rows in 4 pages for object "LDOCTMP".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'TVD'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Mi pregunta es si alguien podria explicarmes que significan los Service Broker Msg [num]
Muchas gracias a todos
Valora esta pregunta


0