November 1, 2005 at 12:03 pm
"Multiple datafiles should help with latch contention"
Could you please enlighten me onthis point ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
November 1, 2005 at 12:17 pm
Multiple data files would only help with latch contention if they were spread across multiple physical disks thereby improving overall IO performance.
There is a fix in SP4 for latch contention on tables with large binary data, but that is a specific problem that isn't necessarily helped by the number of data files. If your tables do contain text, or image data types I'd recommend installing SP4.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply