03/06/2018
by Marlon Ribunal
1 Comment
Disclaimer: I’m one of the Technical Reviewers for this book. With the rising demand for cloud computing and wide adaptation of cloud-based analytics platforms such as Data Lake Analytics and the likes, the chasm between the traditional Data Professionals and … Continue reading
02/20/2018
by Marlon Ribunal
Comments Off on Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations where a SPID that is spawned by the Service Broker stays alive even after the queue is stuck in limbo. … Continue reading
02/06/2018
by Marlon Ribunal
Comments Off on Waiting Tasks Reveal Pain Points
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I didn’t have to go beyond identifying the waiting tasks to quickly troubleshoot a production performance issue. I have encountered a … Continue reading