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:
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?