Performance issue
From: Henry (Henry_at_discussions.microsoft.com)
Date: 11/23/04
- Next message: Raji: "store & retrieve Blob(ntext in particular) datatype in SQL Server"
- Previous message: Tibor Karaszi: "Re: SQL SERVER + XP_SENDMAIL"
- Next in thread: Mike Hodgson: "Re: Performance issue"
- Reply: Mike Hodgson: "Re: Performance issue"
- Reply: Greg Linwood: "Re: Performance issue"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 02:07:05 -0800
Dear Sir/Madam,
I would like to know how would be the impacts eg. query performance, if
tables are relocated to 20 different databases on same server? As a
consultant is recommending us to relocate the existing tables to different
databases, in order compile with Object Orientated modle. e.g. Group tables
and put them to corresponding entity database. Currently, all tables are on
same database (around 16GB).
My main concern is as query will now be spreading across different
databases, will performance be downgraded? What issue do I needed to consider?
Many thanks!
From,
Henry :)
- Next message: Raji: "store & retrieve Blob(ntext in particular) datatype in SQL Server"
- Previous message: Tibor Karaszi: "Re: SQL SERVER + XP_SENDMAIL"
- Next in thread: Mike Hodgson: "Re: Performance issue"
- Reply: Mike Hodgson: "Re: Performance issue"
- Reply: Greg Linwood: "Re: Performance issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
