2012年3月29日星期四

Diskkeeper users ..

Anyone uses Diskkeeper in their production environment to defrag their files
? Any pros and cons that you are aware of ? Can you defrag the files while
the databases are active or do we need to do it when SQL is offline ?
Thanks
Hi
Yes, but not with SQL Server running.
Once it has been defragmented, and you manually grow the DBs to a decent
size so that autogrow does not kick, there is very little need to do i again.
Regards
Mike
"Hassan" wrote:

> Anyone uses Diskkeeper in their production environment to defrag their files
> ? Any pros and cons that you are aware of ? Can you defrag the files while
> the databases are active or do we need to do it when SQL is offline ?
> Thanks
>
>

没有评论:

发表评论