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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2012-08-07 : 07:03:20
|
| Hi All,I have a really really heavy table in my databsesp_spaceused on this table gives below resultsrows44491095 reserved60976928 KBdata23156280 KBindex_size37816832 KBunused3816 KBThis is one the the most frequently used transaction tables. We have many views derieved from it. But this table is so heavy all the views and sps depending on it get really slow.In some of the views thistable is being refered 3 -4 times also. I tried improving performance on all these as well but i think the main problem is in the underlying table storage itself.. Could someone please advise me what to do with this table. |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-08-07 : 09:06:59
|
this isn't enough information to give any kind of advice.40million rows can either be a lot or nothing depending on what kind of data you have and what kind of queries you are doing on that data.How often the data changes etc...Describe the data and what you are doing with it and we'll be able to advise more.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-07 : 10:36:35
|
| Before you start thinking about distributing the load over different IO channels, have you done any query analyis? Do you have any maintenance in place?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Huge table problem