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 database 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 backup 1 database instead of the 20 or so for each applcation).
We do not use stored procedures or relationships on SQL server - just primary keys and handle everything else in the application.
My question is this: Does this sort of setup impede performance of the applications 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 using 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 effectiveness.
Thank you for your time,
Angela
http://www.sqljunkies.com/Article/7F...8946C8D0C.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 Performance topic.
"Angela" wrote:
> 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 database and the users are spread throughout the business areas of the company. The idea for one database
with ALL the tables the company uses was for ease of backup (only having to backup 1 database instead of the 20 or so for each applcation).
> We do not use stored procedures or relationships on SQL server - just primary keys and handle everything else in the application.
> My question is this: Does this sort of setup impede performance of the applications 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 using 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 effectiveness.
> Thank you for your time,
> Angela