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: