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 |
|
deepakugale
Starting Member
33 Posts |
 Posted - 2010-02-16 : 04:10:56
|
| I have one dataware housing table,having around 60 columns,15 indexes,over 50,00000 rows, The table goes through above 200 transactions(insert,update,delete)daily . What steps should i take to boost the performance of data fetching querry as well as performance related to insert,update and delete operation? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-16 : 04:14:50
|
| does DML operations happen frequently? or is it happening at some specified intervals?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 04:15:11
|
| With 200 transaction daily (did I read that correctly?) I don't think you need to do anything special.With 10,000 or millions of transactions daily you might need to update statistics so that queries remain optimised.So I think just the normal query optimisation is enough for your case.If you have a slow query post the Query Plan here so we can help optimise it. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 04:17:00
|
" over 50,00000 rows"Should that be 50,000,000 - i.e. 50 million?Its still only a LARGE table, not a HUGE table  It needs proper housekeeping (index rebuild, update statistics),and the queries will almost certainly need checking for Query Plan and, where necessary, optimising. |
|
|
|
deepakugale
Starting Member
33 Posts |
Posted - 2010-02-17 : 00:36:51
|
| OK,lets think of Huge table,and having large transactions concurrently on daily basis and with same structure as mentioned earlier,what are steps should i follow on table to boost the performance of the operations.I mean to say what are the template steps should i follow to tackle the same situation ? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-17 : 02:48:13
|
| Its hypothetical.But you would do what you normall do for a slow query.View query plan, and optimise.And make sure that your housekeeping was working properly - Index rebuilds, Update statistics.There isn't a magic bullet, its experience that counts.if you have a huge database, and no in-house skills, then get a skilled person in to give you a hand now-and-again. |
|
|
|
|
|
|
|
|
Steps to improve performance