Mak042298
asked on
tempdb full with INSERTS?
Hi,
I've got an application that takes data from one table, do certain processes with the data and put it on other tables.
The problem is the data space in tempdb become full at record number 280. I did some test and I did identify that the inserts are the problem, without them the process runs normally with 5000 records.
I'm doing about 4 selects, calling 4 Stored Procedures to verfiy data and i'm doing around 8 inserts per record.
I'll apreciate some help.
I've got an application that takes data from one table, do certain processes with the data and put it on other tables.
The problem is the data space in tempdb become full at record number 280. I did some test and I did identify that the inserts are the problem, without them the process runs normally with 5000 records.
I'm doing about 4 selects, calling 4 Stored Procedures to verfiy data and i'm doing around 8 inserts per record.
I'll apreciate some help.
Did you try to use begin transaction and commit transaction without expecting everything to be uncommited up to the end of the process?
What is the size of your tempdb? The initial default size of 2Mb is not too much, since all sorting and grouping operations are performed in temdb. To be on the safe side I would make it initially 50-100Mb.
ASKER
1st. bamartino. I'm not using BEGIN TRANS - COMMIN TRANS
2nd.spiridonov. The size of tempdb is 30MB. But the strange is the INSERTS are filling up the tempdb, not the SELECTS or SPs.
2nd.spiridonov. The size of tempdb is 30MB. But the strange is the INSERTS are filling up the tempdb, not the SELECTS or SPs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Either increase the size of tempdb or then use begin tran commit tran. Your tempdb gets full when you are not commiting data and holding everything to the end. Working tables are created until you finish your transaction if these working tables get out of hand in size then your tempdb explodes.
ASKER
I tried, but BEGIN - COMMIT doesn't seem to work, not even with small chunks.