question

rudrapbiswas avatar image
rudrapbiswas asked

Cross-database Ownership Chaining

Recently I have a requirement wherein I have to separate (segment) out the one single monolithic large db to physically segmented dbs. The idea is to reduce the maintain ability and remove the dependencies. In order to do so, I have created an empty db with synonyms created for the required tables from the large db and other smaller dbs hosted in the same server. This is for the 1st phase, once everything works fine, I shall move the db physically out to another server and have the physical copies of the tables instead of synonyms. My question is, how well my queries are going to perform to access across multiple databases. One of the solution is to enable “Cross-database Ownership Chaining” to reduce the security check overhead. Is there any other option I have which I can try out, please help me in that. Specially, is MSSQL 2016 comes up with any advantages in this regard? Also, what if I use materialized view in place of synonyms? Does mssql 2016 has any extra advantages added in this regard?
cross-databasemssql2012synonyms
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.