To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

HOME News MS SQL Oracle DB2 Access MySQL PHP Scripts Books Links DBA Talk


Go Back   Database Journal Forums > Database Discussions > MS SQL Server 7/MS SQL Server 2000

MS SQL Server 7/MS SQL Server 2000 Discuss Microsoft SQL Server 2000 and earlier in this forum

Reply Post New Thread
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 07-08-1998, 01:11 PM
Steve Rich
Guest
 
Posts: n/a
Dr.Watson on sqlservr.DBG, exception 0x80000001 address 0053d062

I`m running NT 4.0 SP3 and SQL 6.5 and SP4. Several days ago, my database seemed to be locked up. I was still getting error log entries
error 17832 `Unable to read login packets`, and then the exceeeded maximum number user connections message. I stopped SQL Executive
and SQL Server; however, the `net stop` would not complete, and sqlservr.exe was alternately jumping from 0% to 100% CPU usage. After, waiting
15 minutes, I kill sqlservr.exe. Restarted in single user mode, recovered OK, ran DBCC checkdb`s on master, msdb and my database,
and got clean reports. And restarted in regular production mode.

Ever since then sqlservr.exe frequently Dr. Watson`s (actually sqlservr.DBG) with exception 0x80000001 and address 0053d062. I`ve downgraded
my service pack to SP3, that didn`t work. I`ve reinstalled SQL 6.5, and then reapplied SP3, using the same master.dat file, with no success.
And, I`ve done things like deconfiguring the SQL Mail, stopped SNMP, and always doing DBCC checkdb`s on master, msdb,
and my database; all with no success.

Help! Does anyone have any ideas as to what`s going on and what I can do?

The only quirky thing that I`m seeing is in Setup. With the SQL services down, I run Setup and enter `Set Server Options`. The form always
fills the configured values very slowly. I think these values are only registry entries, yet Setup is always slow to retrieve them. I don`t have the
same problem in regedt32.exe.
Reply With Quote
Reply Post New Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 10:49 PM.


DatabaseJournal Recent Articles


 » Searching and Sorting Strings in Oracle

 » Preparing To Upgrade Access Tables to SQL ...

 » Sun Expands MySQL With Closed Source

 » Microsoft Demos New SQL Server Features at...

 » Wipro and Oracle Launch First Joint Innova...

Search Database Journal:
 





Acceptable Use Policy

JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Web Hosting | Newsletters | Tech Jobs | Shopping | E-mail Offers

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.