Error: 17883, Database is not performing well

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Error: 17883, Database is not performing well

Author

Topic

AsimKhaliq
Yak Posting Veteran

94 Posts

Posted - 2005-06-07 : 11:15:08

Hi guys,

My Sql server is giving me this error msg Error: 17883. The Scheduler 2 appears to be hung. I need to restart my server again and again but after some time it appears again.

Can someone tell me in detail why this error occured and how i can fix this problem.

Thanks

Asim

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-06-07 : 16:39:57

I ran across this. SQL Server actually does a mini-dump. Look in the MSSQL\LOG directory for a .dmp file. MSFT PSS can provide more information about this for you by reading the dump. The action they took with my situation was to turn on a trace flag for a full dump (2544, 2546), then wait for it to happen again to collect more information (yuk!). They are now telling me it was a bad query that took up too many locks, but it could also be a bug in SQL Server.

All that said, take your dump file and send it to PSS.

HTH

Jon

Now I know, and knowing is half the battle!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-06-07 : 16:46:47

Read this yet http://support.microsoft.com/default.aspx?kbid=810885 ?

Sean Roussy

AsimKhaliq
Yak Posting Veteran

94 Posts

Posted - 2005-06-07 : 17:16:32

Thanks guys,

I already talk to microsoft techical support and they gave me a hotfix and then they gonna see if error occurs or not. But they dont know abt The Scheduler 2 appears to be hung. they know abt The Scheduler 0 appears to be hung. I really dont get the difference 2 and 0. I fsomeone knows plz reply

Thanks again
Asim

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-06-07 : 17:29:58

If you have a support case open with Microsoft, then don't allow them to close it until they have answered your specific error message. Microsoft is the one who wrote this product, so they'll know the difference between 2 and 0.

Tara

AsimKhaliq
Yak Posting Veteran

94 Posts

Posted - 2005-06-07 : 17:42:21

Hi tara,

In ideal world they should know but you know the customer service thing. He was reading the article with me when I called him but he didn't have any solution other than that hotfix which he was not sure.Good part the case is still open and let see what they gonna say next.

Thanks
Asim

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-06-10 : 10:29:13

I had the same problem and here is the problem and it's workaround:

Please also refer to:
http://support.microsoft.com/kb/815056/

1 SYMPTOMS
You may receive this error message:

Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 53, ECID 1, UMS Context 0x04069D90
when you use any of the following on a high-end disk subsystem:

ALTER DATABASE ADD FILE.
CREATE DATABASE.
AUTOGROW of files (explicit or implicit).

1 RESOLUTION:

Security Patch Information

This fix has been included with the security patch for Microsoft Security Bulletin MS03-031.
For additional information about how to obtain that security patch from the Microsoft Download Center, click the following article number to view the article in the Microsoft Knowledge Base:

815495 MS03-031: Cumulative Security Patch for SQL Server

821277 MS03-031:Security Patch for SQL Server 2000 Service Pack 3

2 SYMPTOMS:

After you install MS03-031: Cumulative Security Patch for SQL Server, when you make changes to a standard SQL Server login by using Enterprise Manager,
you are prompted for a password, even if you did not change the password. If you did not change the password,
you cannot successfully close the dialog box, regardless of the entry that you use.

2 RESOLUTION

With Security Patch from Microsoft Security Bulletin MS03-031 Installed
If you have installed the security patch from Microsoft Security Bulletin MS03-031, download one of the following patches from the Microsoft Download Center:

English: SQL2000Tools-KB826161-8.00.0819-ENU.exe

OR:

Without Security Patch from Microsoft Security Bulletin MS03-031 Installed
If you have not installed the security patch for Microsoft Security Bulletin MS03-031, download one the following patches from the Microsoft Download Center:

English: SQL2000-KB826161-8.00.0819-ENU.exe

Before you install the hotfix installer, Microsoft recommends that you perform a backup of these databases:

master
msdb
model

Cluster Installation:

SQL Server 2000 Cluster Installations

LOG TO SYSTEM WITH SQL-SERVICE

To apply the Hotfix package to a clustered SQL 2000 installation, you must run the hotfix package on the node that owns the SQL Server resource.
Then, the Hotfix installer will take the SQL Server resource offline and update the binaries on all nodes of the cluster.
Finally, the SQL Server Resource is brought online, and the Installer runs any install scripts (.sql) that were shipped as part of the Hotfix.

Hope this help.
Regards

Franco

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources