We help IT Professionals succeed at work.
Get Started

A heavily fragmented file in an NTFS volume may not grow beyond a certain size. Operating system error 665. EvenID 17053 MSSQLServer

503 Views
Last Modified: 2015-10-07
Hello  server and SQL EXPERTS,

I need the expertise from both teams, in an issue found in one of my application servers that runs a third party application called Informatica. This application runs some jobs that uses SQL resources, apparently the jobs are performing very slow.

Our DBA guys ran a checkDB and found the following[ see attached screenshot]

and below is what’s recorded in the event log, please take a look while I’m running DBCC checkdb. The error is on a data file that has autogrowth off, and it’s on a different mount point, i.e., data3:

 After the DBA completed DBCC CHECKDB, he started noticing some improvements on the load and blocking, but as this seems to be a known issue with “967351  A heavily fragmented file in an NTFS volume may not grow beyond a certain size” ,which requires a window’s fix:

https://support.microsoft.com/en-us/kb/2002606


 Can you please confirm this is the right solution to fix this isue? and why, please elaborate an action plan step by step, and please provide the hotfix if required

Please elaborate your answer with your thoughts about the issue found and the "possible resolution" any gotchas?
CHECKDBError.jpg
Comment
Watch Question
The More I know, the more I don't know
CERTIFIED EXPERT
Distinguished Expert 2020
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE