SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


BRKR TASK consuming large amount of CPU, but Service Broker is not enabled


BRKR TASK consuming large amount of CPU, but Service Broker is not enabled

Author
Message
shadow66
shadow66
SSC-Addicted
SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)

Group: General Forum Members
Points: 414 Visits: 1311
I’m seeing a spid on one of our boxes that says “BRKR TASK” and is consuming a large amount of CPU time, and is doing no Read or Write activity. However, Service Broker is NOT enabled on the box, and there are no endpoints set up on the box either. I’d like to kill the spid, but do not know enough about this to do so.

The Login Time is 6/26/09 11:23:14 PM, and Last Batch time is the same - 6/26/09 11:23:14 PM. Can I safely kill this or what should I do??

Many thanks!
RBarryYoung
RBarryYoung
SSC Guru
SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)

Group: General Forum Members
Points: 107140 Visits: 9519
How do you know it isn't enabled. Lots of SQL 2005 features use Service Broker under the hood.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
GilaMonster
GilaMonster
SSC Guru
SSC Guru (743K reputation)SSC Guru (743K reputation)SSC Guru (743K reputation)SSC Guru (743K reputation)SSC Guru (743K reputation)SSC Guru (743K reputation)SSC Guru (743K reputation)SSC Guru (743K reputation)

Group: General Forum Members
Points: 743111 Visits: 48477
You can't kill system spids. The BRKR TASK sessions on my SQL box are sessions 10, 15 and 16. All system processes.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


shadow66
shadow66
SSC-Addicted
SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)

Group: General Forum Members
Points: 414 Visits: 1311
Good question - but I assume that since there are no endpoints set up that Service Broker would not work. This is why I am asking this question - I would appreciate any help or insight into this issue.
RBarryYoung
RBarryYoung
SSC Guru
SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)

Group: General Forum Members
Points: 107140 Visits: 9519
Well, DB Mirroring, DB Mail and Event Notifications all use Service Broker, so if you're using any of them, then you've got Service Broker running.

I'll try to lookup how you can check for this later on (heading out the door soon...).

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
EdVassie
EdVassie
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45608 Visits: 3950
When you enable Service Broker you are enabling it for User processes. The End Points you set up are User end points. It is always enabled for System processes and the System end points are not shown to mere humans.

The same concept applies to CLR. Enabling CLR means enabling it for User processes. Many system processes use CLR and the use of CLR for these cannot be turned off or on. (OK, the SQL authors probably have a way of turning service Broker or CLR off for system processes but the rest of us do not.)

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
shadow66
shadow66
SSC-Addicted
SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)

Group: General Forum Members
Points: 414 Visits: 1311
We do have mirroring running. I see the endpoints for mirroring, but just cannot figure out why, all of a sudden, CPU is spiking. A little history - on June 26, we added more memory to our production server and this BRKR TASK is showing as taking a ton of CPU since then. Before that, CPU was averaging 40-50%, and is now consistently 90+%. I'm soooo confused!!!
Steve Jones
Steve Jones
SSC Guru
SSC Guru (456K reputation)SSC Guru (456K reputation)SSC Guru (456K reputation)SSC Guru (456K reputation)SSC Guru (456K reputation)SSC Guru (456K reputation)SSC Guru (456K reputation)SSC Guru (456K reputation)

Group: Administrators
Points: 456534 Visits: 20599
I would bet something else has changed. If you added more memory, you might have people running queries that they didn't run before, or perhaps trying reports that used to time out.

It could be something with mirroring, and I would look there as well. Is your mirror performing the same?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
shadow66
shadow66
SSC-Addicted
SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)

Group: General Forum Members
Points: 414 Visits: 1311
Mirroring is performing the same. The memory upgrade has done wonders for performance actually. The CPU spike is the mystery --- I'm using Spotlight for SQL Server, and just watching CPU hover at 90+. The process using the CPU is this BRKR TASK, with CPU at 5,950,000, logical reads at 206 (has never changed) and zero reads and zero writes. The Last Wait Type is BROKER_TASK_STOP.

Aside from that, nothing else has changed. All of our reporting/queries are done on the mirror with snapshots so nothing but the application touches production.
Sudhakar-339037
Sudhakar-339037
SSC Veteran
SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)

Group: General Forum Members
Points: 218 Visits: 206
We have the same problem. The BRKR task shows up high cpu usage. No changes made to the server. But we do use lot of db mail and database mirroring. they appear to be fine. But CPU continously at 100%.

Any clue? Please help.

/M

thks,
//S
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search