Monday, March 19, 2012

defragment os and dbs

Hi,
Could someone help me what the best practice is for defragging sql server?
Do i need to defrag the OS first and then the databaseserver (with DBCC
REINDEX or DBCC DEFRAGINDEX). For the DBCC statements i could only do it for
a table, it would be nice if it could do for the whole database.
Thnx
dbcc checkdb
Message posted via http://www.sqlmonster.com
|||See this white paper
(http://www.microsoft.com/technet/pro.../ss2kidbp.mspx)
for best practice information on defragging.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:%23BHXsDx$EHA.2032@.tk2msftngp13.phx.gbl...
> Hi,
> Could someone help me what the best practice is for defragging sql server?
> Do i need to defrag the OS first and then the databaseserver (with DBCC
> REINDEX or DBCC DEFRAGINDEX). For the DBCC statements i could only do it
> for
> a table, it would be nice if it could do for the whole database.
> Thnx
>

No comments:

Post a Comment