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 |
|
kentzhou
Starting Member
4 Posts |
 Posted - 2009-01-12 : 12:50:23
|
| I have sql server 2000. It's running at 24X7 for application. But sometime it will be frozen and the memory for sql server process is over 1G. At this time no any response from SQL server. I even can't use command line to logon to the database and event can't restart sql server service! The only way is reboot the server box!After rebooting , checking the error log, the error is:Waiting for type 0x4, current count 0xa, current owning EC 0x7027F5B8.WARNING: EC 20ef35b8, 0 waited 600 sec. on latch caf408, class MISC. Not a BUF latch.Waiting for type 0x4, current count 0xa, current owning EC 0x7027F5B8.What's the possible reason and how to solve this issue? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 13:05:41
|
| What Service packs you have for SQL Server? |
 |
|
|
kentzhou
Starting Member
4 Posts |
Posted - 2009-01-12 : 13:06:59
|
quote:
Originally posted by sodeep
What Service packs you have for SQL Server?
SP4 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 13:10:19
|
| See this similar issue:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110661 |
|
|
|
|
|
|
SQL Server 2000 was frozen