Post reply

tempdb

  • August 23, 2010 at 8:58 am

    #140327

    Find user database operation on temp db,

    I need a information to find operations on user database which performaing operationns on temp db,

    how much performance / space etc.,, which are occpuied on temp db with user database,

    Please Help...

  • August 23, 2010 at 9:15 am

    #1210516

    Its not very clear why you are looking for this information. Is there any underlying issue, or you are just looking for this information for reference purposes?

    Anyways, you would need to setup and run with a profile run to analyze what all is using your tempdb. Use Database ID as 2 for filtering purposes.

    Also, you can check against DMVs sys.dm_exec_requests and sys.dm_db_session_space_usage to find possible candidates which are consuming max of tempDB space.

    _____________
    Vikas S. Rajput

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply