Filegroups question

Hello everyone -

Currently the setup is a single filegroup sql machine
with each company as a new database in a single system.

Would breaking the companies into thier own filegroups
be benefitial?

or perhaps creating a instance of SQL for each company be a better approach?

thoughts / ideas would be appreciated

thanks
tonyWould breaking the companies into thier own filegroups
be benefitial?

Only if those filegroups reside on different actual drives, you might gain the performance benefit of different companies not impacting eachother performance.

or perhaps creating a instance of SQL for each company be a better approach?

Only if you have given the customer sysadmin or someother sql server wide access which I would sincerely discourage. That way the differrent customers could not access eachothers stuff.|||Thanks for the reply

I appreciate it!

take care
tony