Can anyone tell me
1.ÃÂ how the sql server allocates its cache (sql 2000, 2005, 2008)ÃÂ 2. Is there any way to access this value(Cache)
3. Is there any way(Query,Formula) which tells how much percent of cache allocated will be used as a ÃÂ ÃÂ ÃÂ procedure cache?
View Complete Post