<div>
Defragmenting should only be able to help the performance (a), but you need to stop SQL Server for this operation so the database files can be reorganized too (b).<br />
<br />
(a) if the sql files are growing, the extents on disk may be dispersed around the disk, defragmenting should put them together again.<br />
<br />
(b) If SQL Server is still running, the defragmenting process will not be able to reorganize the files at all.<br />
<br />
CHeers<br />
<br />

</div>


Defragmenting should only be able to help the performance (a), but you need to stop SQL Server for this operation so the database files can be reorganized too (b).

(a) if the sql files are growing, the extents on disk may be dispersed around the disk, defragmenting should put them together again.

(b) If SQL Server is still running, the defragmenting process will not be able to reorganize the files at all.

CHeers



<div>
<div class="content wysiwyg-content">
hi,<br />
does defragmenting a disk containing sql files<br />
can decrease the sql-server performance?<br />
i don't want to do anything i'll be sorry after.<br />
&nbsp;<br />

</div>
</div>


hi,
does defragmenting a disk containing sql files
can decrease the sql-server performance?
i don't want to do anything i'll be sorry after.
 


defragment disk and sql performance

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.