Post reply

tempdb increases

  • February 24, 2009 at 8:50 am

    #384006

    Hi,

    we have the problem that the tempdb is growing to large, if our application runs.

    I could identify one procedure but the tempdb is growing only if it is called by the application. If i start the procedure from Management Studio, i run's a long time but tempdb keeps constant.

    (there are not many users in the application, the procedure is only called once!)

    How can I dive deeper into the problem?

    Thanks,

    to

  • February 24, 2009 at 8:57 am

    #949457

    Run your profiler and check the reads and also the Plan. See if when running from SSMS is using the same plan. Probably a different plan is being used by the APP.

    -Roy

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

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