Category Archives: Service Broker

Tracking down CPU spikes using process explorer and DMVs

What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just … Continue reading

Posted in Service Broker, SQL Server | Tagged , , , | 3 Comments

Service Broker: What does a DBA need to know?

Service Broker is SQL Server’s internal messaging system. It has been designed as an asynchronous, reliable and transactional messaging system for inter or intra database messaging, or even inter SQL instance messaging. It is a powerful tool for decoupling extended … Continue reading

Posted in Database options, Service Broker, SQL Server, T-SQL | 7 Comments

Service Broker

While checking a SQL Server upgrade I came across a corrupt msdb database. Like a good DBA I had backed up all user databases along with msdb, master and model before the upgrade so I quickly restored msdb from the … Continue reading

Posted in Database options, Service Broker, SQL Server, T-SQL | Leave a comment