Blitz Result: Cursors Found in Slow Queries

Row-by-row processing is a bad idea in SQL Server, but we’re not just about best practices here.  This part of our SQL Server sp_Blitz® script checks the plan cache looking for resource-intensive queries that are using a cursor – these are where you want to start focusing on reducing CPU power requirements.

To Fix the Problem

Consider rewriting the query to do set-based operations instead of a cursor.

Return to sp_Blitz® or Ask Us Questions