Hi LilyJune-5583,
Do you mean you want to check who used these tables and how long it took for users to run queries?
You can use the SQL Server Profiler to create a trace with event such as SQL:BatchCompleted, SQL:BatchStarting, SQL:StmtCompleted and SQL:StmtStarting to capture the users and queries run by users.
We can specify a filter to monitor the specific database in Event Selection tab->column Filters.
And we can check the Save to table option in the General tab to select the table for trace.
Please refer to this article and this doc which might be helpful.
Best Regards,
Amelia
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.