Home Forums SQL Server 2008 SQL Server 2008 Administration Track queries that caused index scan RE: Track queries that caused index scan
pooyan_pdm
Hall of Fame
Points: 3007
More actions
February 22, 2013 at 4:00 am
#1590276
It takes almost 6 min for sql server to look into the plan catch on our production. What kind of overhead does this search have? I guess it should put some latches on the memory pages containing the plans am I right?
Pooyan