Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 the suitable solution for huge SQL server database

Author  Topic 

Mariam Nagy
Starting Member

3 Posts

Posted - 2014-05-07 : 18:25:03
Hello

I have a huge database

1- I have about more than 20 tables with some of them with many-to-many relations
2- I have some of these tables may contain a very large row size may exceed 8K
3- The expected data for these tables is about 1 million record for the master table and of course may be 10x (10 million or more) for the detail tables

The question is

What is the suitable solution for this situation as there is a lot of screens in the web application that may select from all these tables at the same time .. like the search pages that use a view that contains all these joined tables

part of the database http://imagizer.imageshack.us/a/img842/9901/i1f3.jpg (full size)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-07 : 18:43:13
This doesn't sound like a huge database. A huge database, in my opinion, is one that is over a terabyte in size and has tables that contains hundreds of millions or billions of rows.

To answer question though, you would write efficient queries and have covering or sufficient indexes on the tables.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Mariam Nagy
Starting Member

3 Posts

Posted - 2014-05-07 : 18:54:24
i ve done everything u said but the database is very poor performance and i have a task to find a solution for this urgently even if i need to redesign all the database from scratch
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-05-08 : 01:44:09
Could you define poor performance?
Do you have benchmarks for an acceptable response time? That way you can compare response times
Do you have index maintenance in place?
Has the workload increased suddenly , which has caused a drop-off in performance?Read this post if this situation http://www.sqlserver-dba.com/2013/11/sql-server-tuning-method-for-a-drop-in-throughput.html


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-08 : 11:47:15
quote:
Originally posted by Mariam Nagy

i ve done everything u said but the database is very poor performance



Show us. We need to see queries, indexes and execution plans.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -