Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics SL (Solomon) > SL - Installation and Administration
  New Posts New Posts RSS Feed - SQL Server Hang
  FAQ FAQ  Forum Search   Register Register  Login Login


SQL Server Hang

 Post Reply Post Reply
Author
Message
lansishao View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: March 02 2011
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote lansishao Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server Hang
    Posted: March 27 2011 at 7:57pm
May i know what is the below problem?
2011-03-28 09:22:36.89 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.
2011-03-28 09:22:36.89 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.
2011-03-28 09:22:36.91 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.
2011-03-28 09:22:36.91 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.
2011-03-28 09:22:36.92 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.
2011-03-28 09:22:36.92 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.
2011-03-28 09:22:36.94 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.
2011-03-28 09:22:36.94 spid3     Process ID 1579:320 owns resources that are blocking processes on Scheduler 3.

Because of this problem, solomon process very very slow and sometimes it totally cannot use. Anyone any idea of this problem?
Back to Top
Sponsored Links


Back to Top
lansishao View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: March 02 2011
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote lansishao Quote  Post ReplyReply Direct Link To This Post Posted: March 27 2011 at 7:57pm
Our server is using SQL Server 2000 Enterprise SP4
Back to Top
Salim View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: October 28 2009
Location: Mombsasa
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Salim Quote  Post ReplyReply Direct Link To This Post Posted: March 27 2011 at 11:53pm
try reading this link  http://support.microsoft.com/kb/319892 might help you with your issue.
Regards
S.B.Salim
Back to Top
lansishao View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: March 02 2011
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote lansishao Quote  Post ReplyReply Direct Link To This Post Posted: March 29 2011 at 12:09am
Hi salim, thank your link but after i read make me confuse....

Another problem is
2011-03-29 13:41:04.11 spid149   startsubprocess: Limit on 'Max worker threads' reached.
2011-03-29 13:41:04.12 spid1289  startsubprocess: Limit on 'Max worker threads' reached.
2011-03-29 13:41:04.56 spid405   startsubprocess: Limit on 'Max worker threads' reached.
2011-03-29 13:55:22.20 spid1001  startsubprocess: Limit on 'Max worker threads' reached.
2011-03-29 13:55:22.87 spid1026  startsubprocess: Limit on 'Max worker threads' reached.

what is this?
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com