Can SQL server performance be improved by defragmenting?

Asked By jabez zion 10 points N/A Posted on - 06/26/2012

For most installations, the only access to the SQL Server database is through the client program. This provides the essential database management services, such as backup and restore. However, system owners can be given SQL Server logins providing administrator access to the database using the Microsoft SQL Server client tools, such as Enterprise Manager and Query Analyzer.

 

• Status: Open
• Question Views: 716
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: File Servers

Answered By Kevin Milton 0 points N/A #132536

Can SQL server performance be improved by defragmenting?

Yes, of course.

There are certain scripts which recommended by the professionals in the industry which you can use for defrag your SQL db. Since some of the data located in your DB is not actually required to run your system perfectly with improved performance, such tools can highlight and fix those errors with few clicks. 

Also, you can manually authorize the changes and you can see how the performance progress. 

However, don't forget to make backups of your system before you use such tools to defrag your base. 

Thanks.

About Kevin Milton

Questions
3

Answers
40

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 08/05/2012
• Question Category: File Servers