How do i find out whether the query is picking the data and query plan from
the cache.Use in your trace Events - Stored Procedures - SP:CacheInsert, SP:CacheHit,
SP:CacheMiss and SP:CacheRemove. See BOL for more information.
AMB
"Neeraj" wrote:
> How do i find out whether the query is picking the data and query plan fro
m
> the cache.sql
Showing posts with label fromthe. Show all posts
Showing posts with label fromthe. Show all posts
Wednesday, March 21, 2012
Subscribe to:
Posts (Atom)