Hi we run std 2008 r2. I'd like to monitor what processes (if any) are using 10 tables on 3 different databases between certain hrs. Two of the dbs are on one server. If a process is determined to be using any of them i'd like to know what account and from what server it is running and anything else I can glean about that process as well as how it is using the table(s). I may want to monitor for 3 or 4 months.
My understanding is that sql profiler is heavy handed in this kind of thing. Can the community make recommendations?
An afterthought...if anything is happening on the db's themselves that might affect table availability, I guess i'd want to know that too.- Edited by db042190 17 hours 21 minutes ago afterthought