Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am primarily a web developer, not a DB admin, so hence this question!

We have a webservice that we have created which has a Database on our SQL 2008 server.

We are currently creating a web portal to manage some of that information that is within the database for the webservice. The web portal will need some of its own Tables which will not be used by the web service. It will need to use Stored Procedures to access some of the webservice DB tables and obviously have its own SPs for accessing its own tables.

From a performance point of view, what is the best set up to use for doing this? I have thought of the following scenarios, but am not sure which is best.

  1. Add the Web Portal Tables + Stored Procedures into the existing DB and just connect/call from there
  2. As above, but create a new Filegroup for the Web Portal Tables + SPs so that they are in a different physical file (possibly move to different Disk drive).
  3. Create a new DB for the Web Portal to create the Tables and SP in, and access the other database through cross-database queries within Stored Procedures (possibly use Views to simplify this)

I want to make sure that the web portal has as little performance impact as possible on the web service.

Any suggestions would be gratefully received!

share|improve this question
    
crikey - look at the tumbleweed! Can anyone suggest a more appropriate place to ask this question maybe? –  user49447 Jul 30 '10 at 9:14

1 Answer 1

Without knowing anything more about your infrastructure, your best bet, based solely on performance, would to be to create another database whose files reside on a separate physical drive.

HTH, Dan

share|improve this answer
    
Yes. That said, in 99% of the instances that is a totally idiotic approach as there is only a theoretical and no practical performance gain. –  TomTom Oct 7 '10 at 14:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.