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 ?
ThanksHi
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 fil
es
> ? 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
>
>
2012年3月29日星期四
Diskkeeper users ..
标签:
aware,
cons,
database,
defrag,
diskkeeper,
environment,
files,
microsoft,
mysql,
oracle,
production,
pros,
server,
sql,
users
订阅:
博文评论 (Atom)
没有评论:
发表评论