Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dineshrajan_it
Posting Yak Master
217 Posts |
 Posted - 2009-05-04 : 06:37:55
|
| when i run this procedure and then watch this out in my profiler. CREATE PROCEDURE dbo.spShowRecompileASSET NOCOUNT ONSELECT TOP 100 * FROM DBO.MASTERAUDITTABLEi get sp:cachemiss and sp:cachehit then. what may be the problem. how to avoid cachemiss. thanks in advanceIam a slow walker but i never walk back |
|
|
|
|
|
sp:CacheMiss