2

We have a database server with U2 installed on a windows 2003 server with RAID5 setup. I'm wanting to use Diskkeeper to defragment the different partitions. Has anyone ever ran into any issues or data loss when defragmenting a drive? Are there any dangers when defragging?

Jacob
  • 443
  • 1
  • 9
  • 23

3 Answers3

2

No. Except it makes NO SENSE on a properly conffigured SQL Server (if your partitions are aligned, node size is set correctly to the NOT DEFAULT value).

TomTom
  • 50,857
  • 7
  • 52
  • 134
  • 2
    No benefit to the data/log files, maybe. But the rest of the file system benefits just as much as any other system. – Chris Thorpe Jul 30 '10 at 21:34
  • The rest of the system is irrelevant, though. Seriously. Once SQL is loaded, and if properly configured, the pretty much ONLY load you have is on the data and log files. Which, under proper guideliney, are static in size. – TomTom Jul 31 '10 at 06:17
1

You'll be fine.

mrdenny
  • 27,074
  • 4
  • 40
  • 68
0

Other than defragmenting the filesystem there may be a way of defragmenting the database itself (i.e. how data are stored inside the database files) . The exact procedure depends on the database product you're using though.

Alex Jasmin
  • 406
  • 2
  • 6