Hello,
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!
HK
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.