Performanc of joins betwen two dbs

What are the performance rammifactions of joining two or more tables in one
db with two or more table in another db vs having all the tables in the same
db'
Barry FitzgeraldShould not be any difference (unless you go between servers/instances, of
course. But there are other reasons as to why you want to avoid splitting
into several database; backup is one.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Barry Fitzgerald" <barryfz@.home.com> wrote in message
news:uYneHQrqDHA.1880@.TK2MSFTNGP09.phx.gbl...
> What are the performance rammifactions of joining two or more tables in
one
> db with two or more table in another db vs having all the tables in the
same
> db'
> Barry Fitzgerald
>|||Hi Barry
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
As I understand£¬for the database level, there is no obvious performance
difference between joining two or more tables in one database with two or
more table in another database and in the same database.
However, if you carry out any distributed query, that is a query on joined
tables in different servers (Linked Server), many factors will affect the
query. For example, the execute plan, the server load, the network, memory,
IO, CPU, etc.
If you could provide why you want to carried out you plan, I can explained
more clearly.
You can also test the query performance base on your own environment to
find which factor will cause the performance difference.
If you need more help, please fill free to contact me.
Sincerely Yours
Wei,Baisong
--
| From: "Barry Fitzgerald" <barryfz@.home.com>
| Subject: Performanc of joins betwen two dbs
| Date: Fri, 14 Nov 2003 07:34:27 -0600
| Lines: 7
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <uYneHQrqDHA.1880@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: exchangetest.gumdropbooks.com 209.152.94.98
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:316543
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| What are the performance rammifactions of joining two or more tables in
one
| db with two or more table in another db vs having all the tables in the
same
| db'
|
| Barry Fitzgerald
|
|
||||Hello Barry,
Taking about the backup/recovery, If the logically related tables are
spread across different databases, then those databases must be
logically consistent at any given time and you may need to implement
special procedures to ensure the recoverability of these databases.
Please look at "Backup and Recovery of Related Databases" topic in the
SQL2K Books On Line for more information
(BOL URL >
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adm
insql.chm::/ad_bkprst_9ttf.htm)
Thanks for posting to MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security."
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Barry Fitzgerald" <barryfz@.home.com>
>Subject: Performanc of joins betwen two dbs
>Date: Fri, 14 Nov 2003 07:34:27 -0600
>Lines: 7
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <uYneHQrqDHA.1880@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: exchangetest.gumdropbooks.com 209.152.94.98
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:316543
>X-Tomcat-NG: microsoft.public.sqlserver.server
>What are the performance rammifactions of joining two or more tables in one
>db with two or more table in another db vs having all the tables in the
same
>db'
>Barry Fitzgerald
>
>