Hello,
I work for a company that chose to implement one database with LOTS (126) of
tables. There are many applications that use different tables in this datab
ase and the users are spread throughout the business areas of the company.
The idea for one database w
ith ALL the tables the company uses was for ease of backup (only having to b
ackup 1 database instead of the 20 or so for each applcation).
We do not use stored procedures or relationships on SQL server - just primar
y keys and handle everything else in the application.
My question is this: Does this sort of setup impede performance of the appl
ications or SQL database? If many users are hitting a set of tables in the
database - does this interfere with other users in the same database but usi
ng different tables?
Any insight would be appreciated on this topic. Implementers of this model
are of the mainframe mindset and I would like validation to its effectivenes
s.
Thank you for your time,
Angelahttp://www.sqljunkies.com/Article/7...E8946C8D0C.scuk
for information on common symptoms and tools to assess the performance.
HTH
--
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Perform
ance topic.
"Angela" wrote:
> Hello,
> I work for a company that chose to implement one database with LOTS (126) of table
s. There are many applications that use different tables in this database and the us
ers are spread throughout the business areas of the company. The idea for one datab
ase
with ALL the tables the company uses was for ease of backup (only having to backup 1 databas
e instead of the 20 or so for each applcation).
> We do not use stored procedures or relationships on SQL server - just prim
ary keys and handle everything else in the application.
> My question is this: Does this sort of setup impede performance of the ap
plications or SQL database? If many users are hitting a set of tables in th
e database - does this interfere with other users in the same database but u
sing different tables?
> Any insight would be appreciated on this topic. Implementers of this mode
l are of the mainframe mindset and I would like validation to its effectiven
ess.
> Thank you for your time,
> Angela
