I have a database server where I cannot get plans to cache it seems. This server has a lot of small databases and very little user activity. When I query just the sys.dm_exec_query_stats, plans are staying for less than 10 secs.
What can cause this?Thanx, Adam
View Complete Post