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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment