¿Algun MVP que me ayude?

28/10/2003 - 17:00 por Isaías | Informe spam
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

#1 Fernando España
28/10/2003 - 20:56 | Informe spam
http://www.bushcador.com/buscar.php...p;enviar=1



Fernando España
Gerente Informatica
Alta Tecnologia en Informatica S.A.
www.atisa.com.gt
7a. calle 4-34 Zona 10
Guatemala Centro America
PBX: (502) 3620005

Email:

****************************************

"Isaías" escribió en el mensaje
news:015201c39d6c$967dc700$
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.

Preguntas similares