Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

how to clean up tempdb Expand / Collapse
Posted Friday, March 14, 2014 12:16 AM


Group: General Forum Members
Last Login: Sunday, October 16, 2016 10:43 AM
Points: 131, Visits: 301

i have on big stored proc , which generates some tabels to be used for reporting, it takes lot of time.
some times it gives tempdb clean up problem , i think it is related to log file . please tel me about it and
how i can perform the task in 2005 and 2008.

yours sincerley.
Post #1551023
Posted Friday, March 14, 2014 12:29 AM


Group: General Forum Members
Last Login: Thursday, March 17, 2016 5:13 AM
Points: 2,796, Visits: 2,232
What do you mean by tempdb clean up? Usually SP use tempdb for temporary calcuation and you need to fine tune stored proc which help to improve performance.


"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1551029
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse