Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

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?
0
25112
Asked:
25112
2 Solutions
 
Scott PletcherSenior DBACommented:
Most likely DMVs, since you'll want to review things that won't appear in Profiler.
0
 
ProjectChampionCommented:
If you expect an intensive operation running for 2 hours, the last thing you want is to slow it down and burden the server even further by profiling the whole operation.
You should be able to get most of the info you want by reviewing and analysing the SSIS package itself and the queries and procs that it will use, before even starting the package.

While it runs, I'd use a combination of DMV's, SQL Server Activity Monitor and perhaps some ad hoc queries to keep the tab on the metrics that matter to you most.

SQL profiler is a diagnostic tool not a monitoring tool; it can also add a significant overhead so should be used with care and only for the intended purpose.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now