Monday, February 13, 2012

about indexes

Hi Grus,
How can i know that on what date a index was created and how many times
it was reindexed.
Or how offen it being reindexed.
from
DollerSQL Server doesn't keep such information. So you would have to keep track of
it yourself, possibly
using a Profiler trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"doller" <sufianarif@.gmail.com> wrote in message
news:1132808347.911840.163270@.g44g2000cwa.googlegroups.com...
> Hi Grus,
> How can i know that on what date a index was created and how many times
> it was reindexed.
> Or how offen it being reindexed.
> from
> Doller
>

No comments:

Post a Comment