2 Veces que tira a mi servicio de SQL Server

27/10/2003 - 14:47 por Isaías | Informe spam
Hola amigos, todos.

Este mensaje ha aparecido ya en 2 ocasiones y no he
encontrado la forma de indentificar que esta pasando, solo
se que mi base deja de responder y tengo que re-setear mi
servidor de datos, alguna sugerencia???, gracia a todos.

spid4 Process ID 1411:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1411:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1431:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1431:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1431:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1439:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1439:0 owns resources that are blocking
processes on Scheduler 0.
 

Leer las respuestas

#1 Carlos Sacristan
27/10/2003 - 15:01 | Informe spam
Mira a ver si en estos artículos encuentras la solución:

http://support.microsoft.com/defaul...-us;815056
http://support.microsoft.com/defaul...-us;810885



Un saludo

-
"Sólo sé que no sé nada. " (Sócrates)
MVP SQL Server
Por favor, responder únicamente al foro
Se agradece la inclusión de sentencias DDL


"Isaías" escribió en el mensaje
news:079a01c39c90$e0fda9d0$
Hola amigos, todos.

Este mensaje ha aparecido ya en 2 ocasiones y no he
encontrado la forma de indentificar que esta pasando, solo
se que mi base deja de responder y tengo que re-setear mi
servidor de datos, alguna sugerencia???, gracia a todos.

spid4 Process ID 1411:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1411:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1419:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1431:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1421:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1431:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1431:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1439:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1735:0 owns resources that are blocking
processes on Scheduler 0.
spid4 Process ID 1439:0 owns resources that are blocking
processes on Scheduler 0.

Preguntas similares