>>I wonder, does reindexing SQL Server database improves performance? If yes, how often do you do it?
>
>You already got some good information from Martina, but just to add on....
>
>We reindex and we update statistics nightly. Fragmentation can impact performance once it hits about 30% (just an estimate)
>
>Some might view that as overkill, and might only do it weekly, etc. Every installation will be different.
I ran the code the Martina posted that gives the percentage of the fragmentation (I ran it on my SQL server only) and it shows some numbers that I didn't understand. Shows two records. One shows 80 in the column AVG_FRAGMENTATION_IN_PERCENT. The other record is 52. Combined with your input it means pretty high.
I will run it now on the customer SQL Server.
I have not ran the Reindex code that Martina posted simply because I don't understand it have a concern that I will do some damage to the customer data. I wish I understand what the first query says.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
