|
Posted by Krisnamourt Correia via SQLMonster.com on 05/17/05 17:22
The real problem is incorret result. I can΄t rebuild index on these two
table , because our scenario works 24 hours by day. These table are too big
(17 Gbytes one and 4 Gbytes other), with many Index. The Index Rebuild only
can do at weekends. I intend to eliminated some Index that are redundant(I
just begun), but that bug is very crazy. That became SQL Server not a good
solution for OLTP that grows up strongly. I saw many scenarios like
that...bad performance when the Database became too large.
--
Message posted via http://www.sqlmonster.com
Navigation:
[Reply to this message]
|