Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MichaelHLutz
Starting Member
19 Posts |
 Posted - 2009-06-25 : 10:45:48
|
| When writing a single object assigned to a filegroup consisting of multiple files, does SQL Server write to each file with a different thread?So in other words if a table T is assigned to filegroup FG, and FG consists of 4 files, does SQL Server spawn 4 threads when writing to it, assign each thread to a different CPU, and write the data concurrently to each of the 4 file?I understand the concept that SQL Server first writes to the memory buffers (creating dirty pages) and transaction log and then later (asynchronously) during a checkpoint the dirty pages are written to disk so I don't need this concept recapped and I also understand that SQL Server generally tries to write each object evenly across the available files in the filegroup.Rather, I'm trying to understand the exact concurrency model SQL Server uses when writing a single object to a filegroup containing multiple files.Thanks in advance for any thoughts on this matter.Mike |
|
|
|
|
|
file IO threading question