SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 the suitable solution for huge SQL server database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mariam Nagy
Starting Member

3 Posts

Posted - 05/07/2014 :  18:25:03  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 05/07/2014 :  18:43:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 05/07/2014 :  18:54:24  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 05/08/2014 :  01:44:09  Show Profile  Visit jackv's Homepage  Reply with Quote
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

USA
37157 Posts

Posted - 05/08/2014 :  11:47:15  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000