SQL Server Performance

What sps are causing temp-db activity?

Discussion in 'T-SQL Performance Tuning for Developers' started by brimba, Oct 25, 2007.

  1. brimba New Member

    Hello!
    I noticed that one server had twice as many transactions/sec in the temp-db than in the actual database.
    How is this possible, and how can I investigate it more? Is there a way to find out which sps that are causing all this activity in the temp-db?
    I tried to profile on the temp-db but couldnt find anything.
    Thanks


  2. satya Moderator

    PROFILER is the best way forward, rather you can run server side trace to take more of that analysis.
    What events you have captured?http://www.simple-talk.com/sql/database-administration/tracking-tempdb-growth/

Share This Page