Post reply

TempDB and User DBs

  • March 13, 2009 at 4:02 am

    #94736

    Hi,

    I have three DBs in my server. (DB1, DB2, DB3)

    In these three DBs, there are procs that has temp tables in it.

    When all these DBs are Online and procs in all these DBs execute simultaneously, Is it possible to track down which temp table belongs which DB and procedure.

    Thanks in advance.

    "I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin

  • March 13, 2009 at 7:27 am

    #959081

    First I'd be interested in why you need to know this. Then I'd say, I don't think there is any way to determine this as temp tables are confined to a session and created in tempdb. You could query sys.tables in tempdb, but that isn't going to tell you what process created the table(s).

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • March 14, 2009 at 5:22 am

    #959670

    "You could query sys.tables in tempdb, but that isn't going to tell you what process created the table(s). " ..

    This is what i need that you have mentioned .. Is there any way other than sys.tables to find the process that created the table .. The reason why i ask this qn is tempDB gets fulled when all these three process happens .. I need to find which is causing this issue..

    P.N: Condition: All three DBs runs simultaneously and cant be run individually...

    Thanks in advance.

    "I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin

  • March 14, 2009 at 7:34 am

    #959696

    The only way I know of to do something like this is to set up a server-side trace that will show the SQL Statements and autogrow events.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • March 16, 2009 at 1:10 am

    #960061

    Fine .. Lemme check with that..

    Thanks

    "I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin

Viewing 5 posts - 1 through 4 (of 4 total)

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