Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Join of two tables of the different database. Expand / Collapse
Author
Message
Posted Wednesday, October 9, 2013 3:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:15 AM
Points: 40, Visits: 172
Is it any impact on the performance if we join the two tables of the different database. my current database size in 1.5 TB. Now I am creating the new table structure for my applicaton which will have large data in future. I want to create the new database. Is it will be good for performance prospects or we should create it in the same database. actually there is one questoin in my mind is that New table will be used at multiple place in the reports, in joins with old database large tables to select the data. what will be performance Impact in that case. Please suggest.
Post #1502996
Posted Wednesday, October 9, 2013 4:09 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 12:43 AM
Points: 630, Visits: 1,290
Technically if it is on the same instance, it should not create a problem.

But is it only because of the size you are going for a new database? In that case you should introduce new filegroups and try partitioning.



-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1503000
Posted Wednesday, October 9, 2013 4:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:15 AM
Points: 40, Visits: 172
Yes it is on the same Instance.
Post #1503002
Posted Wednesday, October 9, 2013 4:27 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 12:43 AM
Points: 630, Visits: 1,290
As I mentioned since both databses are in same instance, the buffer pool is shared, there wont be impact in join performance.

But normally we split databases for security or functional reasons. For performance, you should try a different aproach like partitioning.


-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1503007
Posted Wednesday, October 9, 2013 5:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:15 AM
Points: 40, Visits: 172
Thanks joeroshan.
Post #1503035
Posted Wednesday, October 9, 2013 6:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:15 AM
Points: 40, Visits: 172
can you please suggest what are functional reason behind that ?
Post #1503046
Posted Wednesday, October 9, 2013 8:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 6, 2014 5:46 AM
Points: 2,840, Visits: 3,969
nitin.varshney (10/9/2013)
can you please suggest what are functional reason behind that ?


See this http://architects.dzone.com/articles/20-database-design-best


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1503129
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse