Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL JOB taking more space Expand / Collapse
Author
Message
Posted Wednesday, April 16, 2014 1:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:08 AM
Points: 100, Visits: 328
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
Post #1562161
Posted Wednesday, April 16, 2014 2:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1562166
Posted Wednesday, April 16, 2014 2:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:08 AM
Points: 100, Visits: 328
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.
Post #1562167
Posted Wednesday, April 16, 2014 2:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
Is it possible tempdb used a lot of space? (is tempdb stored on the c drive?)



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1562169
Posted Wednesday, April 16, 2014 2:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:08 AM
Points: 100, Visits: 328
tempdb is located to the other drive and we have lot of space on that drive.
Post #1562171
Posted Wednesday, April 16, 2014 2:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:08 AM
Points: 100, Visits: 328
Windows folder is occupied 14.9 GB space. I am not able to find , why that folder is taking more space.
Post #1562173
Posted Wednesday, April 16, 2014 2:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1562174
Posted Wednesday, April 16, 2014 2:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:08 AM
Points: 100, Visits: 328
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..
Post #1562179
Posted Wednesday, April 16, 2014 2:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1562182
Posted Wednesday, April 16, 2014 2:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:08 AM
Points: 100, Visits: 328
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.
Post #1562190
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse