Diskeeper Blog: Welcome to the Diskeeper Blog

This blog will provide technical data and insights into performance and reliability issues surrounding file system performance. We hope to cover all topics related to system performance including defrag whether you are running SANs, NAS, workstations, servers, SSD's or other systems. We will provide interesting anecdotes, white papers, and related story topics on defragmentation and other performance issues. The blog is intended to be personal rather than a formal Diskeeper website. You will read personal viewpoints on our products and where we see the industry and our company going. We are excited to have this opportunity to share our product knowledge and insight, and hope this information helps you. We encourage your comments and look forward to you following this blog.

Defragmenting databases

by Michael 17. May 2006 19:57
In order to squeeze optimal performance out of a database, there are two "layers" that need defragmentation; the database file(s) themselves, and the internal records/indexes within those files. Diskeeper, of course safely and automatically defragments files and free space (yes even live databases). Advanced Diskeeper features like I/O Smart ensure that defragmentation can occur during production without impact to the system. Diskeeper does not offer, nor perform, internal file defragmentation. I've authored several white papers that discuss the internal defragmentation/compaction tools Microsoft offers with their Exchange and SQL products. It is those tools, development by the application vendors, that have the understanding required to address internal fragmentation. You can read up on those white papers in the Knowledge Center. The problem with these free provided tools is they are cumbersome to use and integrate with IT operations. Fortunately there are vendors that have dramatically improved upon the basic scripting tools and offer powerful features so you can avoid the long and often complex coding normally required to operate them. I'd like to introduce you to a couple of great products I'm familiar with and personally recommend.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

General

Comments are closed

RecentComments

Comment RSS

Calendar

<<  February 2012  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011

View posts in large calendar