SQL Server Performance Forum – Threads Archive

Job Failure

Hi, Things were ok till vacations got over.now clients starts buggin me.so m back again(newbie DBA) <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> pbm is tht one job failedin my SQL server.whn i checkd the job history,i saw a comment "The job failed.The job was invoked by Schedule 21(Schedule 1).The last step to run was step1(Step 1)" .I have only one step for this job,which is a TSQL.M really struglin how to troubleshoot this pbm. any tips anyone can provide? thnx in advance. Rajiv SQL-DBA

is it outputting to text file? make sure that it is, then review the contents of the text log file. that’ll probably tell you more. Tom Pullen
DBA, Oxfam GB

What kind of job is this?
If this is a database maintenance plan scheduled job then ensure to perform the same process using SQL statements in job scheduler. If not run PROFILER during this execution to capture the moments of truth. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

hi i have checkd output text file and found low diskspace for backup.now i freed space and working fine.Thnx a TON for ur help now comes other pbm.one other job is not running and outputin error …. "Primary file group is full for database STOCK" i have only primary filegroup for this database and contain one file. b4 it was restricted filegrowth,4.5GB. and i changed it to 5.5GB restricted growth.now DB is using 5Gb.but y job failing stating primary file group is full , though ther is .5 GB of free space ?? <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />

if it’s doing reindexing it needs to have freespace which is 1.5 times the space of your largest table to have enough room to reindex it. it may be running out of room during reindexing? Tom Pullen
DBA, Oxfam GB

That was a real gr8 reply from Thomas.Thnks a lot thomas.My job is doin reindexing and fail each times.Nice guess u made.
any problem if i extend the file once agin to 1 more GB.i already extended the file from 4.5 to 5.5 GB.again extending the file create any perfomance or any kinda pbms???any limit in size of primary file tht we can extend??
i prefer to extend file than adding one more file creating other group.Pls waiting for ur valuable info:….

You can improve performance if you are able to put files on diferent drives, but you should put tran log files on separate drive first.

thnx,YEa i know its better to put it as different file,different drives.But any pbm in simply extending one more GB??I am planin to do this way

I don’t see a problem.

ok wil add one more Gb then, to run the job fine.thnx marovic. currently i have .5 Gb free in primary file.but when i chek properties of data base,its showing availble memory as 0.00 MB .donno in wht sense. any suggestions..

Better to run SP_SPACEUSED and SP_HELPDB or DBCC SHOWFILESTATS from query analyzer for better results, sometime GUI tool will be flaky or you may need to refresh to get the information. Review thishttp://www.databasejournal.com/features/mssql/article.php/3339681 article to monitor database growth. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I have added one more GB and nwo job is running fine. VERY VERY SPECIAL THANKS TO THOMAS. Sathya, i have small query.it was 4.5GB restricted filwgrowth for primary file.and it got full.I made it to 5.5 GB,then datafile size gone upto 5GB.nwo i increasd unrestricted file growth to 6.5 GB,but now datafile showing 6GB. how come its increasing this much while i add each GB ??

You must check the activity on the database to findout how the space is filled up quickly, I guess its the transaction log file increasing with the set of queries you execute.
And check how much freespace left on each filegroup, data file and log files. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>