I've worked with our Healthshare instance for almost 2 years now and I still can't answer so many basic questions like "How many searches were performed today".
Two of the reasons (and there are many) are simply the size and complexity of the ATNA table.
To avoid this issue, I'm considering a custom Ensemble/Cache class that would log each ATNA event type to a separate and simpler reporting table.
I wanted to see if anyone had any experience or advice on this front.
