Unanswered: Will a seperate Database on the same server will add to Performance improvement?
I have a database on one of the SQL server. This particular database is used by our website. Now, I have to develop one API which will expose the data in my database to third party. Is it better to create one more database on the same server and using replication update the data in this database from the database used by web site. My only concern here is the database used by web site will have lots of traffic. In this case my plan is to create a seperate database which has the same data and use this one for my API.
Now, please let me know creating a seperate database on the same server will add any performance improvement for my API?