June 5, 2008 at 2:04 pm
Hi,
I have a strange issue. I saw that in sysprocesses table there were few system SPID that had a high value in the wait time and examining those process i found that those were related to Service Brokers. Immediately i checked the SQL features only to find none of the Service broker was configured and running. Then i started digging out information to find that there were few databases which had is_broker_enabled set to 1 in sys.databases. Now all i need to know is if the wait time parameter reduce if i alter the database to disable broker. because of this there is lot of internal wait in the server and we feel that it affects the performance of the service in some ways. Your inputs, thoughts, views and suggestions are highly appreciated. Thanks.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 5, 2008 at 8:22 pm
what were those processes doing when they were "waiting for Service Broker"? And how did you determine that they were waiting for Service Broker?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 6, 2008 at 9:18 am
Hope i already explined that. Anyways saying again, there was a high value in the waittime column in sysprocesses table for the broker related processes. the broker service is not enabled at server level only in database they are enabled and it looks stange to see it running. your ideas are welcome. 🙂
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply