Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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