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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy