December 2, 2009 at 6:41 am
I am getting this event in SQL server error log and all users are not able to connect to the server
2009-12-02 15:02:11.57 server Stack Signature for the dump is 0x00000000
2009-12-02 15:02:11.57 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:02:11.57 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:03:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:03:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:04:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:04:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:05:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:05:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:06:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:06:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:07:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:07:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:08:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:08:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:09:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:09:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:10:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:10:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:11:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:11:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:12:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:12:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:13:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:13:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:14:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:14:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 15:15:11.58 server Error: 17884, Severity: 1, State: 0
2009-12-02 15:15:11.58 server Potential deadlocks exist on all the schedulers.
2009-12-02 11:20:01.71 server SQL Server could not spawn process_loginread thread.
2009-12-02 11:20:02.71 server SQL Server could not spawn process_loginread thread.
2009-12-02 11:20:03.71 server SQL Server could not spawn process_loginread thread.
2009-12-02 11:20:04.71 server SQL Server could not spawn process_loginread thread.
December 2, 2009 at 12:51 pm
Are there any exclusive locks on the server at the time users cannot connect? Any long-running jobs running at the same time that could be causing access issues?
Joie Andrew
"Since 1982"
December 3, 2009 at 1:00 am
ok i will check that thanks for reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply