July 12, 2005 at 3:45 pm
I am trying to run a profiler trace to capture sp:cachemiss events, and I am trying to filter by databaseid on the filters tab. I have been using the same trace template in the past and have been able to filter on databaseid (I am certain, but doubt is creeping in because its not working now).
When I filter on databaseid now I get no events, but if I create new trace without filter and event column databaseid I get sp:cachemiss events but they always have databaseid 0.
Has anyone else come across this (am I going insane), how can I filter cache misses if the databaseid it is always 0
Machine running trace
XP SP2
sql server version 8.00.760 SP3 Developer Edition
Server being traced
Windows 2000 server sp4
sql server version 8.00.760 SP3 Enterprise Edition
July 12, 2005 at 5:21 pm
Technically CacheMiss events don't belong to any database, and that's probably the reason why. It's looking in the master database at the syscacheobjects table. Hence it won't actually hit the user database to determine a cache miss.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply