Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

monitor tempdb during major 2 hour operation

when the operation team is going to run lot of transactions for 2  hours through ssis package, we want to realize what/how tempdb is being used.

is DMV the better route or profiler?
SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial