Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-03 : 07:49:27
|
| Isaías writes "Hello allAfter install SP3.0 in my SQL 2000 Enterprise, I have received in twice occasions the following message:Error 1229: Process ID %d:%d owns resources that are blocking processes on scheduler %d.This is my Log records: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 onTo resolve the problem i need STOP an RESTAR my SQL Service (is my dead).In this link, Microsoft said "New Concurrency and Scheduling Diagnostics Added to SQL Server".http://support.microsoft.com/default.aspx?scid=kb;en-us;319892Any ideas, Tks." |
|
|
|
|
|
|
|
Error 1229