Hi.
Is there a way to get list of queries causing recompiles with out running SQL Server Profiler? I searched online but couldn't find anything. We use SQL Sentry tool for performance monitoring. So, if there is something there that we can use to get the list, I can do it.
Thank you.
Sridhar.