ASE Database forum - Question on logsegment/tempdb

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Question on logsegment/tempdb

Sumit Bagla

2005-12-23, 7:24 am

Hi,

I have some questions on the logsegment/tempdb usage.
As I understand, tempdb has it's own logsegment and the main db has it's own
logsegment.
If I am running some big queries in the main db involving some temp tables (like
#1,#2 etc), then which logsegment is getting used? tempdb /OR main database?

We are running 11.9.2 and we encountered an issue of log-segment getting full ,
but we were not sure which logsegment it was. Not sure if my understanding
itself is correct..hence this question.

Thanks in advance.

Regards
Sumit

---== Posted via the PFCGuide Web Newsreader ==---
http://www.mcse.ms/_newsgroups/group_list.asp

Hemendra Rathi

2005-12-23, 9:23 am

If you are using #tables, then the tempdb gets utilized. You
can use sp_helpsegment "logsegment" to get the info on space
utilization. Its advisable to have data and log of tempdb in
mixed data and log mode.

Sponsored Links