Timeline for Tempdb is getting full very quickly in microsoft sql server 2008
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 14, 2012 at 4:07 | history | migrated | from stackoverflow.com (revisions) | ||
| Jun 13, 2012 at 15:11 | comment | added | Saurabh | Probable reason for this can be that either you do not have the permission to drop tempdb objects or the objects are currently in use by some session (as you have reduced old objects' age from 12 to 1 hr). | |
| Jun 13, 2012 at 15:02 | comment | added | Rishi Ranka | Hi Thanks for your reply but this did not work . The query runs successfully but did not see any changes . I even tried using 1 hh instead of 12 | |
| Jun 13, 2012 at 14:51 | history | answered | Saurabh | CC BY-SA 3.0 |