Very useful little query to monitor the health of service broker
While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was. So I came up with this little query which is surprisingly effective. select far_service, state_desc, count(*) messages from sys.conversation_endpoints group by state_desc, far_service ORDER BY far_service, state_desc Hopefuly you find this helpful. […]
Very useful little query to monitor the health of service broker
While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was. So I came up with this little query which is surprisingly effective. select far_service, state_desc, count(*) messages from sys.conversation_endpoints group by state_desc, far_service ORDER BY far_service, state_desc Hopefuly you find this helpful. […]
Does your SQL Server database improve SharePoint performance?
This morning I posted by first article up on SearchWinIT.com called “Does your SQL Server database improve SharePoint performance?“. It is all about getting the most out of your SharePoint environment by getting the most out of your SQL Server. Denny
How Healthy is my SQL Server Enterprise webcast has been archived
I’m happy to say that the webcast which I did with Jason Hall on Thursday October 30, 2008 has been archived for after the fact viewing. They say that it is up there for a limited time, so I’m not sure how long it will actually be available for. You can find the webcast over […]