Just another WordPress.com site

Post navigation

I Have HOW MANY filegroups!?!

For small DBs one or maybe two data files (.mdf/.ndf) works fine. With larger DBs though there is an opportunity to gain performance by the judicious use of additional file groups and files. Unfortunately some folks go a little crazy and you can end up with more files than you can shake a dead cat at (my apologies to cat lovers).

Here’s a quick script to give you the lay of the land regarding file groups and their files.