Our management wants the Enterprise level weekly report of 'Top 10 Expensive SQL Batches/Quries/SP's' . I dabbled with Fog light's 'Database Expansion Pack' and was able to create it at an instance level .There is no option to combine all and produce an executive report in a single window.
Did anyone have luck doing something on these lines ? Is is even possible to achieve something like this within Fog Light ? One of the options suggested by my management was to utilize tables in 'spimsql-XXXXX' database that Fog Light creates for its reporting and try to Reverse Engineer the process. Is it a viable option ?
Quite frankly, I am lost of ideas at this time. So , any assistance from anyone around here is highly appreciated