Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
  SQL Server Tips by Burleson

Coming Physical I/O Crisis?

A number of database experts are predicting a coming crisis with respect to database performance and disk I/O. This prediction has to do with the fact that hard disks are continually increasing in their ability to handle more storage capacity. The concern is that the I/O’s per second (iops) that these disks can service has not kept pace with their ability to handle more space.

For example, a DBA used to have ten or more disks at their disposal to service the storage needs of a 500 GB database. But now, storage vendors can offer IT managers the ability to store the same amount of data on only two disks. Such a proposal is not only attractive to IT management, but it often appeals to system administrators as well because fewer disks normally mean less work and maintenance.

Such a situation can place a stranglehold on the DBA’s database because the number of iops that such a disk configuration can handle is far below the iops capability of the previous ten disks.

Storage is typically priced by capacity and not by iops, so database gurus are sounding the alarm for all DBAs to hear; make sure their voice is heard when the storage configuration of the database server is being decided. If their opinions are not heard, the database may be robbed of performance because of poor disk purchasing decisions.


The above book excerpt is from:

High-Performance SQL Server DBA
Tuning & Optimization Secrets

ISBN: 0-9761573-6-5
Robin Schumacher

 http://www.rampant-books.com/book_2005_2_sql_server_dba.htm  

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks
 

Hit Counter