December 2, 2009 at 6:31 am
hello all,
today SQL server user were not able to connect to the server when i have seen log some times it show
2009-12-02 15:15:11.58 server Potential deadlocks exist on all the schedulers.
and sometimes
2009-12-02 11:28:45.73 server SQL Server could not spawn process_loginread thread.
i have seen it happened after log tuncation events.
please help.
December 2, 2009 at 7:57 am
Hi,
Does this generate any kind of memory dump after this. Check out for any errors like
FAILED TO RESERVE VIRTUAL BYTES *******
Regards,
Mani
December 3, 2009 at 12:33 am
no i havent such error in log.
can you please explain what does it states?
December 4, 2009 at 5:31 am
Hi
I don't know much about this, but I googled the error and came up with the following support article from MS
http://support.microsoft.com/kb/319892
Also I might suggest loading SP 4 for SQL 2000.
Hope that provides the answers you were looking for
Cheers
B
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply