How do you split a large .MDF file?
We are running SharePoint 2007 and our WSS_Content_xxx.Mdf is a huge 194Gb. I've already managed to shrink the .Ldf file to virtually nothing but we are still getting performance issues and my thinking is that it would be best to split the MDF file.
Does anyone know if splitting the mdf file would increase VLE performance? If so, what is the best method to do this?
Also - I would like to find out why the .mdf file is so big - is there software which can explore this file to show the main areas of our VLE which are causing it to be so big?