DBAs most often face scenarios where they need to capture graphical execution plan of a query currently running on a live production instance because of multiple reasons like: why a particular SPID is causing blocking why is my query running slow why isn’t the index getting used which operator is costing more and why While there are multiple ways to […]