Sql server 2008 filestream maximum number of rows
We are using **filestreams** in **Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) and Windows server 2008** to store millions of files. Since there are millions of files all of them are grouped into 100 filegroups and inserted sequntially one after another filegroup. Now we have around 15K files in each filegroup and expected to grow to 20K soon. so we want to know is there any maximum limit of rows that a filegroup can have to give optimum performance or is there any maximum on the operating system side for optimum performace as we are storing or going to store around <20K files in single folder?

Any suggestion to the right resources will also be very helpful.

Thanks.
Sql server 2008 filestream maximum number of rows
===

We are using **filestreams** in **Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) and Windows server 2008** to store millions of files. Since there are millions of files all of them are grouped into 100 filegroups and inserted sequntially one after another filegroup. Now we have around 15K files in each filegroup and expected to grow to 20K soon. so we want to know is there any maximum limit of rows that a filegroup can have to give optimum performance or is there any maximum on the operating system side for optimum performace as we are storing or going to store around <20K files in single folder?

Any suggestion to the right resources will also be very helpful.

Thanks.