SQL Activity Monitor detail

jdr0606
jdr0606 used Ask the Experts™
on
I'm investigating some performance issues that seem to be happening at around the same time every day. What I'd like to do is capture the activity detail (similar to what I see in SQL Activity Monitor) for a period of time . Is this something easily done or is there something better to run to capture SQL activity?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott PletcherSenior DBA
Most Valuable Expert 2018
Top Expert 2014

Commented:
SQL Profiler /  SQL trace.
DBA Freelancer
Commented:
Best is to use Activity Monitor and Data Collection.
Have a look for detail: http://www.sqlshack.com/sql-server-performance-monitoring-data-collector/

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial