2 Veces que tira a mi servicio de SQL Server

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.

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.
>