SQLTeam.com | Weblogs | Forums

SQL Server Performance Report to Preemptively Identify Table Scans, Inappropriate Row Updates, etc




Does anyone know of a tool, script or utility out there that could create a preemptive report of table scans, index scans and/or other performance issues before they happen? I guess it would be something like a mass execution plan analyzer.

Thanks in advance for any information!



That would be a lot of overhead, particularly on a large server, very likely beyond the value of what it would be worth to do. You can use query governor to prevent "too heavy" a query from running. Otherwise, it's normal tuning where you follow up on bad performance after the query has run.