sql server - Architecture - how to run SP on distributed databases and data sync to primary db -
my project database huge , there multiple stored procedure jobs running based on schedule..basically bottleneck database performance. want distribute load different db servers , merge data primary db.
my question is: how manage this? efficient method?
my plan : primary database replicate data multiple databases specific jobs/sp's executed on replica databases once job done merge data (using ssis) primary db
any ideas or suggestions on how tackle it?
Comments
Post a Comment