From the database: Getting number of eventcache entries in 24 hour period

In a current project, we’ve been having problems with search indexing. By problems, I mean massive hairy problems.

We’re not using SharePoint search or FAST so the knowledge we have in that space can’t be brought to bear in this case.

I won’t bore you with all the background, but suffice it to say we wanted to understand on a content database by content database basis how many changes were taking place in a given 24 hour period so that this could be cross-referenced to indexing data for sanity checking purposes.

Although doable through PowerShell (this is a MOSS estate) it’s way simpler using some T-SQL against the content database we are interested in.