March 31, 2009 at 10:04 am
I was thinking of defragmenting disk drives on my servers where database files are residing.
Just as i do for my personal computer how about doing that on servers where disk drives are of 2 TB. does it improve performance for my databases if so can we do that regularly.
March 31, 2009 at 10:09 am
Yes, it definitely does improve the performance but remember it is an expensive operation. You have to opt doing out of business hours. After that you can see more disk I/O with better performance.
March 31, 2009 at 10:50 am
In order to do a disk level defrag you will need to be certain that no one is using the databases (in most cases) in order for the defrag to work or it will bypass the data and log files. I typically do a defrag monthly without worrying about the data and log files. When I feel I need a disk level defrag including the data and log files I go to the extent of detaching the databases (backup first) and then doing the defrag. This way I keep everyone out of these databases. To some this may seem extreme, but our production environment allows for it several times a year.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply