Are there any instructions or best practice on setting up the large SharePoint content DB (larger than 1 TB) on multiple SQL data files?
We currently have a SharePoint site collection (thus one content DB) and having issue with the performance. According to MS and MCS, it is because of the size (1TB+) and the number of items (millions) in that single content DB.
I need the detailed instructions on setting up this on multiple SQL data files and it still needs to stay as one site collection (because it is integrated with the Dynamics CRM 2011 site and it can't handle multiple SharePoint sites)