How to know how much history being accessed

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Highlighted
Enthusiast

How to know how much history being accessed

I have an application database where we stored historical data with day paritioned.

 

Task is to findout how much history data being accessed by downsteam applications with partition column?

 

eg: lets say if a table has 5 years of data, how to determine if qureies are accessing all the history info or only for few years ? any means ?

 

Appreciate your quick help?