Re: FW: getting error while running sql on mm_activealrm table

On 12/3/2014 9:30 PM, M Tarkeshwar Rao wrote:
> I have found corrupted indexes are usually a sign that something is not well with the server. It is good to check and
makesure memory, CPU's and hard drives are all happy and not reporting problems. I have found overheating servers to be
particularlyprone to index corruption and if indexes can get corrupt one has to worry about data becoming corrupt too. 

do your servers not have ECC memory?   the number one source of data
corruption is cached data getting transient one-bit errors, which occur
at a more common rate than you might expect if you have many gigabytes
of ram...   ECC will fix and report these single bit errors.




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast