question

amdba avatar image
amdba asked

Service broker performance in VMware

Hi, does anyone know of any performance issues with SQL Server Service Broker running on a VMware Virtual Machine? I'm trying to create a dev server in line with a live server we already have that's running service broker in SQL Server 2005. The config for the dev server is similar in terms of hard-drives, memory, etc. to our Live server. I've then restored a backup of the Live database onto the Dev server. However, as soon as I enable Service Broker, the performance of the Dev server grinds to a halt without even sending one record to the queue!! The CPU processing skyrockets and the disk I/O reads slow to a crawl. Once I turn Service Broker off, the server works well. Anyone has any ideas why this might be?
sql-server-2005service-brokersql server 2005sql service broker
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
smooth1x avatar image
smooth1x answered
Check for spinning on latches/spinlocks: http://www.sqlskills.com/blogs/paul/advanced-performance-troubleshooting-waits-latches-spinlocks/ Check wait stats: http://www.brentozar.com/responder/triage-wait-stats-in-sql-server/ Also check - server errorlog - sys.dm_os_schedulers - sys.dm_os_workers - sys.dm_os_threads - sys.dm_os_tasks - sys.dm_os_waiting_tasks - sys.dm_os_ring_buffers You could also try turning on trace flag T8022 to check for nonyield activities: http://www.databaseskill.com/4149436/ Bob Ward did a great talk on SQL Server Internals at SQLBits 2015, check his videos on YouTube!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.