so, I was not sure the correct category to post this in but hope this is it!
Imagine the following:
A SQL Server instance that has quite a few DB's. It DOES get hammered by many different SQL Agent jobs OR by external applications that are all around a company or across teams.
Given the high usage, is there a way to take a before and after snapshot of the DB's when a particular job runs? (The ones I have control over at least!)
Since I am exploring this black box, I want a way of knowing the state of the data before the job runs and after and see the delta.
This is for on-prem SQL And NOT SQL Azure