A escalar este problema:
Error 1229: Process ID %d:%d owns resources that are
blocking processes on scheduler %d.
Me recomendaron este LINK:
http://support.microsoft.com/defaul...cid=kb;en-
us;319892
He leido detenidamente y me comenta algo de un BUG y que
debo insertar en el STARTUP del SQL:
Establish a startup parameter (-T###)
¿Que es lo que pasa?, que me "tira" la operacion del SQL,
afortunadamente desde que instale SP 3.0, solo ha ocurrido
2 veces.
Busque en el mundo del INTERNET y solamente encontre 4
reportes de este error en todo el mundo de la internet.
Anexo algunos registros de mi LOG.
2003-10-26 02:00:01.33 backup Database log truncated:
Database: MA01900.
2003-10-26 02:40:04.25 backup Database backed up:
Database: MA01900, creation date(time): 2002/12/26
(09:59:32), pages dumped: 475505, first LSN: 150231:69:1,
last LSN: 150231:114:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'RESPMA01900'}).
2003-10-26 17:00:05.39 backup Database log truncated:
Database: MA01900.
2003-10-26 17:35:35.21 backup Database backed up:
Database: MA01900, creation date(time): 2002/12/26
(09:59:32), pages dumped: 475531, first LSN: 150248:80:1,
last LSN: 150249:194:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'RESPMA01900'}).
2003-10-26 20:43:00.27 backup Database log truncated:
Database: MA01900.
2003-10-26 20:43:19.00 spid4 Process ID 1411:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:24.08 spid4 Process ID 1411:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:29.10 spid4 Process ID 1419:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:29.11 spid4 Process ID 1421:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:34.16 spid4 Process ID 1421:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:34.17 spid4 Process ID 1735:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:34.19 spid4 Process ID 1419:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:39.22 spid4 Process ID 1419:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:39.25 spid4 Process ID 1421:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:39.27 spid4 Process ID 1735:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:44.28 spid4 Process ID 1419:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:44.28 spid4 Process ID 1431:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:44.32 spid4 Process ID 1421:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:44.32 spid4 Process ID 1431:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:44.33 spid4 Process ID 1735:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:44.33 spid4 Process ID 1431:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:49.38 spid4 Process ID 1439:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:49.39 spid4 Process ID 1735:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:49.39 spid4 Process ID 1439:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:49.39 spid4 Process ID 863:0 owns
resources that are blocking processes on Scheduler 0.
2003-10-26 20:43:49.39 spid4 Process ID 1431:0 owns
resources that are blocking processes on
Cualquier ayuda, MUCHAS GRACIAS COMPAÑEROS.
Leer las respuestas