| Publisher | SQL Server Bible | ||
|---|---|---|---|
| Format | 133.1KB PDF | Date added | 10 Jan 2005 |
| Topics | Back-up | ||
| Downloads | 86 | ||
One of the biggest hardware bottlenecks of any SQL Server is disk I/O. And anything that a DBAs can do to reduce SQL Server's use of disk I/O will help boost its performance. Some of the most common things DBAs do to reduce disk I/O bottlenecks include; Tuning queries to minimize the amount of data returned; Using fast disks and arrays; Using lots of RAM, so more data is cached; Frequent DBCC REINDEXing of data to remove logical database fragmentation. Another less frequently used method to reduce overall disk I/O, but nonetheless important, is to perform physical defragmentation of SQL Server program files, database files, transaction logs, and backup files.
Did you find this white paper useful?
21 out of 50 users found this white paper useful
Related white papers
Backup System Keeps Core Data and Applications Accessible 24/7, While Delivering Peace of Mind
The Royal Victoria Hospital provides health carefor patients 24 hours a day, seven days a week. Royal Victoria's backup system plays a central role in meeting this expectation. When its...
Email Archiving in the SMB
Addressing Enterprise Needs with Fewer Resources A discussion of SMB needs for email archiving.
Gartner Webcast: Data Loss Prevention, Compliance Trends
The regulatory environment is changing. Find out what companies need to consider to best protect themselves from data leaks. Watch this Gartner webcast today to learn more about data loss...
Building, Maintaining, and Tuning the Box
This paper covers many of the basic practical matters in assembling a server and then keeping it in good working order. It's a really big subject, so the author has...
The Importance of Disk-Based Backups for Your Small Business
Do you have a recovery plan in case you get hit by a computer attack? Do you have the latest information on backup solutions? This webcast explains the importance of...
Sears Canada Racks Up Sales, Floor Space and Higher Service Levels With StorageTek Virtual Solutions
Sears Canada (Toronto: SCC.TO) enjoys a significant retailing presence through 165 department, furniture and appliance stores. In time, the company's 30 percent annual data growth began to tax its infrastructure....
Appleton Faculty Commence Year With New e-Mail Power
The first Appleton public school began in 1850 with the confidence that education would shape the future independence and prosperity of the entire country. The Appleton Area School District needed...
