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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-06-30 : 20:21:55
|
| I am considering creating another file ie. (*.ndf) for one of my db's. Right now I am not going to split the files on two different drives or controllers. I know this is good idea but here is my question. If I create the two files in the same PRIMARY filegroup will this be considered I/O parallelism and will I see performance gains. My understanding is that two threads will be fired on my SELECT requests thus giving possibly better performance. I don't quite understand the performance gains of doing this can anyone point me in the right direction.ThanksMy DB has many tables one of which is about 1M rows. |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-07-01 : 10:07:18
|
| It depends entirely on your version of SQL Server - 7.0 or 2K. In 7.0, you are correct, SQL Server will issue one I/O op for each file in the filegroup you are accessing. In 2K, the # of asynchronous I/O's is determined dynamically, up to the maximum as specified by sp_configure.Jonathan Boott, MCDBA |
 |
|
|
|
|
|
I/O Performance