SqlServer2008 & DDBB múltiple

Posted on 2011-04-29
Medium Priority
Last Modified: 2012-05-11
Hemos creado una aplicación Web basada en muchos usuarios pequeños y para cada usuario individual cream,os una nueva DDBB en un SqkServer2008. Ahora, presuntos expertos en Sql nos dicen que está mal enfocado. ¿Porqué sería correcto tener una sola DDBB con el nº de cliente en cada registro de cada archivo y no es correcto tener miles de DDBB con todos los ficheros y registros sin el nº de cliente?. Ejemplo: DDBB name: 000000001 con el fichero XXX con los campos A, B y C. Select A,B,C from XXX de la DDBB 000000001 en lugar de Select A,B,C,D from XXX where D='000000001'. Dajando aparte el tema de la ocupación en bites del resultado.
Question by:77258840
  • 3
  • 2
LVL 81

Expert Comment

ID: 35495420

Unfortunately, my spanish is not that good, but spanishdict.com has a good translator. The problem with your post is that it is not clear what the issue is. If you do not have an identity column, this makes it difficult to normalize data to have maximum information with minimal space usage.
English to spanish translation
Desgraciadamente, mi español no es muy bueno, pero spanishdict.com tiene un buen traductor. El problema con su mensaje es que no está claro cuál es el problema. Si usted no tiene una columna de identidad, esto hace que sea difícil normalizar los datos para tener la máxima información con el uso de un espacio mínimo.
Translation from spanishdict.com
We have created a web application based on many small users and individual users cream, a new DDBB you a SqkServer2008. Now, alleged experts tell us that Sql is misplaced. Why would one DDBB right to have the customer number in each record of each file and it is wrong to have thousands of DDBB with all the files and records without the customer number?. Example: DDBB name: 000000001 XXX file with the fields A, B and C. Select A, B, C from the DDBB 000000001 XXX instead of Select A, B, C, D from D WHERE XXX = '000000001 '. Dajando aside the issue of occupancy bit of the result.

Open in new window


Author Comment

ID: 35496663
The application runs perfectly with: hundreds of DDBB named GWS000000001, GWS000000002, GWS000000003... Each user are one DDBB with the numbner of customer. We do sql like: select * from filename with string connection directed to DDBB GWS000000NNN and this run perfectly. But "the experts" say when we have thousandas of  DDBB that falls on the SqlServer performance.
This is right>?
We think that sqlserver lets you manage many DDBB as requested.
LVL 81

Accepted Solution

arnold earned 750 total points
ID: 35497073

When you have many databases that means that sql server has a "query plan" for each database,  This means that after a while it has to kick one out of memory to load in the one you query.
a different organization where you have a single database where you have a table for all the users. Then you have a table for items with a column that references to which user this entry belongs. Setting up index will let sql keep most of the database in memory.

Where do you keep a reference for the user and their DDBB?

It is still unclear.
IF each user has a completely different, their own designed database, this is the only option you have.

If the databases are identical just separated because they are user based, i.e.
If you have a sign in process for entry into your company, but based on your setup, the front desk will have a sign-in book for each individual rather than having a single sign-in book for all. In this case, the clerk has to locate the correct sign-book for each of the individuals before them. You can see how inefficient that is and it will waste the clerks time who could be using that time for other more productive purposes, answering questions.  In this configuration, during heavy traffic, there will be a line at the front desk longer than necessary.

Author Comment

ID: 35499981
More opinions please?

Author Closing Comment

ID: 35872840
Thenk you

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
New style of hardware planning for Microsoft Exchange server.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question