Re: ASSM vs. non-ASSM
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 26 Jan 2012 20:02:19 +0100
Message-ID: <4f21a331$0$5044$ba620e4c_at_news.skynet.be>
mhoys wrote:
> On Jan 25, 9:21 pm, "Gerard H. Pille"<g..._at_skynet.be> wrote:
>>
>> We have a couple of tables in which there are continuous inserts and deletes, at a dreadful
>> rate, and we have to rebuild the indexes every week, to keep size and performance in check.
>>
>> Could not fall back to MSSM, because system is also ASSM, I seem to remember.
>
> "To keep size and performance in check"; I understand the size issue,
> but how do you measure the performance of your indexes before& after
> the rebuild? Do you really have significant performance improvements
> after rebuilding the indexes?
>
> Matthias
>
Date: Thu, 26 Jan 2012 20:02:19 +0100
Message-ID: <4f21a331$0$5044$ba620e4c_at_news.skynet.be>
mhoys wrote:
> On Jan 25, 9:21 pm, "Gerard H. Pille"<g..._at_skynet.be> wrote:
>>
>> We have a couple of tables in which there are continuous inserts and deletes, at a dreadful
>> rate, and we have to rebuild the indexes every week, to keep size and performance in check.
>>
>> Could not fall back to MSSM, because system is also ASSM, I seem to remember.
>
> "To keep size and performance in check"; I understand the size issue,
> but how do you measure the performance of your indexes before& after
> the rebuild? Do you really have significant performance improvements
> after rebuilding the indexes?
>
> Matthias
>
Yes, like 100 times faster, which I would call significant. Do you know what a "soufflé" is, and how it can fail? That's like our indexes. Received on Thu Jan 26 2012 - 13:02:19 CST