We have peaks where latency (as measured by [Physical Disk\Avg Disk Sec read] on the drive where our data file is) goes up to 0.2 sec.
I immediately started suspecting the SAN while the DBA is suspecting that this is related to the fact that we currently have a single MDF file that is 5 terabytes.
Does a very large MDF file negatively impact latency? If so what is the appropriate size?
I have not seen a lot of content on this subject.