SQL JOB taking more space

Question

Post reply

SQL JOB taking more space

arooj300

Hall of Fame

Points: 3433
More actions
April 16, 2014 at 1:51 am

#292454

Hi All,
One SQL SERVER job has scheduled for morning 3:00 AM , that job is taking 3 to 5 hour to execute. Yesterday C:/ drive space was 28 GB free but today i have checked c:/ having only 13 GB free space.
Anyone , please help me on this and also tell me what are thing is taking more space in C:/ drive because when I restart the server the drive space reached 28 GB.
Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

How are you sure the space issue is linked to the job?

What does the job do?

Are your databases stored on the C: drive?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

arooj300 Hall of Fame Points: 3433 More actions · Answer 2

Job has scheduled for updating the data from source to target. For that one we have created SSIS package.

Databse backup we used to take in other drive.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Is it possible tempdb used a lot of space? (is tempdb stored on the c drive?)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

arooj300 Hall of Fame Points: 3433 More actions · Answer 4

tempdb is located to the other drive and we have lot of space on that drive.

arooj300 Hall of Fame Points: 3433 More actions · Answer 5

Windows folder is occupied 14.9 GB space. I am not able to find , why that folder is taking more space.

free_mascot One Orange Chip Points: 27169 More actions · Answer 6

You mean due to SSIS package database size is growing on C:?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

arooj300 Hall of Fame Points: 3433 More actions · Answer 7

I am not sure. I think , because of SSIS package C:/drive is growing. I read some article about this one to change the SSIS package temp file location in BLOBTEmpStorage Path and BufferTempStorage path. So Iahve changed the path also but still the issue is remain..

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

The package itself will not take that much space.

It all depends on what the ssis package is doing exactly.

Without more info, we're just guessing here.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

arooj300 Hall of Fame Points: 3433 More actions · Answer 9

Hi All,

Thanks for the reply, I got the problem the System file is taking 13 GB space.

Could you please tell me , is there any alternative ways to release the space from the drive.

free_mascot One Orange Chip Points: 27169 More actions · Answer 10

What kind of System File?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."