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.
| Author |
Topic |
|
Mariam Nagy
Starting Member
3 Posts |
 Posted - 2014-05-07 : 18:25:03
|
HelloI have a huge database1- I have about more than 20 tables with some of them with many-to-many relations2- I have some of these tables may contain a very large row size may exceed 8K3- 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 tablesThe question isWhat 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 tablespart 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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 |
|
|
|
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 timesDo 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.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
the suitable solution for huge SQL server database