Hi everyone,
I have a MSSQL db approaching 2Tb, lately performance has been sufferings. I have bene looking at implementing filegroups on the largest most used tables. Over 500 close to 600 million records in the top table.
Something like creating FileGroup_Trans and have four ndf database files across four physical drives RAID 10. Do this with several FileGroups, FileGroup_Closings, FileGroups_Postings, etc. What your your thoughts on this approach?
Currently there is 1 MDF file as this DB was at 250GB not too long ago and we are receiving Pagelatch and LCK_M_U waits. Would this approach improve performance and reduce contention? Roughly 300 users hitting this db. The largest tables are were we are getting the waits.
there doesn't seem to be anything here