Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    91

    Unanswered: 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
    tony

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Quote Originally Posted by alt-088
    Would 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.

    Quote Originally Posted by alt-088
    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.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Oct 2004
    Posts
    91
    Thanks for the reply

    I appreciate it!

    take care
    tony

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •