BUG: SQL Server Uses 100% of the CPU When Dump Pending

• Microsoft SQL Server version 4.2 for OS/2

SYMPTOMS

SQL Server goes to 100-percent CPU usage if a client workstation has a dump pending. This can happen when, for example, a client workstation begins a dump to a disk on the server, but there's no disk in the drive on the server. The dump is pending while SQL Server waits for you to insert a disk in the server. While the dump is pending, if you restart the client workstation and then try to log on again, SQL Server goes to 100-percent CPU usage and puts the following messages in the error log:

   fbsspacket: can't mount first diskette
   Start up the console program to continue using the
   dump device.

   Cannot send, host process disconnected: SAF 9569 spid 1
   Error: 1608, severity: 21, State: 2

WORKAROUND

If you can, finish the dump. Otherwise, you must stop and restart SQL Server.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.