In the series of Oracle storage wait events I have covered so far, five different events are related to the storage: “db File Sequential Read”, “db File Scattered Read” wait events, “Direct Path Read”, “Direct Path Read/Write temp” and “Free Buffer Wait”. In this post, I will describe the log file sync wait event, which in many cases is caused by poor storage performance. Read the rest of this entry »
Posts Tagged ‘Storage appliances’
Posted March 5th, 2012
 |
Log file sync waitBy Eyal Markovich |
Posted May 5th, 2011
|
New SSD Product TrialTIRED OF WAITING FOR THE RIGHT SSD SOLUTION TO COME ALONG? By Eyal Markovich |
Your wait is over. Kaminario is now accepting businesses to participate in our New SSD Product Trial. This new, blazingly fast SSD storage appliance improves application and database performance by up to 25x, while protecting data at a price/performance point never achieved before. The trial begins in June 2011 and a limited number of companies will be selected to participate.
What you will gain from joining in the Kaminario SSD Product Trial:
- An accurate application and database performance analysis to identify I/O bottlenecks and how to resolve them.
- A reliable and economical multi-terabyte storage solution, on site, for optimizing application and database performance that will extend the life of your storage infrastructure and lower your total cost of ownership.
If interested, please contact tsp_program@kaminario.com for additional information on the New SSD Product Trial.
Posted April 27th, 2011
|
Will SSD Improve Your Database Performance?By Eyal Markovich |
In the article, “Will SSD Improve Your Database Performance,” George Crump from Storage Switzerland takes a look at how the fog around solid state storage is lifting. Most storage and database administrators are convinced that solid state technology is the most viable next step in storage performance. The challenge is that solid state performs so well that now there’s a concern as to whether the databases placed on the platform can take full advantage of that boost in performance. Unlike mechanical storage, investments in solid state storage cannot afford to go under utilized, the price premium is just too high. Making sure that the database will take full advantage of solid state storage is the next big step in solid state adoption. Read full article.
Posted March 31st, 2011
|
The Advantages of DRAM SSDBy Eyal Markovich |
George Crump, Senior Analyst, at Storage Switzerland ponders the Advantages of DRAM SSD in this recent article. Read the rest of this entry »
Posted January 31st, 2011
|
Application Performance Tuning and High Performance StorageBy Eyal Markovich |
One of the advantages of enterprise super fast storage, such as the Kaminario K2, is that it can reduce or eliminate application tuning. Rather than tuning an application that is not performing well, you can achieve greater performance by moving the data to much faster storage. Read the rest of this entry »
Posted January 25th, 2011
|
Startling I/O Performance to Drive Application and Business ValueBy Eyal Markovich |
In his white paper, “Startling I/O Performance to Drive Application and Business Value,” industry analyst Mark Peters from Enterprise Strategy Group (ESG), discusses the need for consistent speed that is well targeted at applications that require higher performance. Read the rest of this entry »
Posted January 12th, 2011
|
Database Performance Assessments for Oracle and Microsoft SQL ServerBy Eyal Markovich |
The majority of applications have a backend database which enables critical data access to those applications. Any database can be negatively impacted by data access bottlenecks caused by I/O wait, which can also result in slow application response time. I/O wait is the total duration that the working processes of a database or application session are blocked while waiting for I/O operations to complete. High I/O wait can mean that your storage device is providing “unacceptable” services to your database or other mission critical applications, resulting in low customer satisfaction and employee productivity. High latency or low throughput can result with significant I/O Wait, resulting in poor database response times for end users.
The following assessments of Oracle and MS SQL Server performance shows that by eliminating I/O bottlenecks, database performance can realize an up to 11-fold improvement.
Posted January 12th, 2011
 |
Digital Trowel Cuts Web Mining Processing Time in HalfBy Gareth Taube, Vice President Marketing, Kaminario |
Digital Trowel, a leading corporation in Web mining, collects, distills and disseminates data from the Internet to provide the knowledge needed to enable its customers to make smart business decisions. It harvests data (structured and unstructured) through Web crawlers and maintains multiple databases with a combined total of more than 10 billion records. Digital Trowel’s applications include data discovery and aggregation of business intelligence information, sentiment analysis and market mapping, and brand awareness analysis.
Learn how they cut their Web mining processing time in half.
Posted January 5th, 2011
|
Replication in a High Performance EnvironmentBy Eyal Markovich |
In many industries, the replication of a company’s storage is a crucial operational task. It may even define a company’s ability to survive major events. In many cases, replicating data could also be a government regulated action. When it comes to implementing replication for high performance storage, one should take into consideration the many characteristics of replication and the storage it is employed on. The Kaminario whitepaper on Replication in a High Performance Environment describes what replication is, followed by a discussion on how to implement replication on high performance storage.
Posted January 3rd, 2011
|
The Importance of Write Performance to RDBMS ApplicationsBy Eyal Markovich |
Both Oracle and SQL Server perform writes that are asynchronous to the user sessions (not to be confused with asynchronous I/O, which is something else). This means that when a user session modifies rows in a table, the modified pages will be physically written to the table at a later stage and will not add additional time to the DML operations.
So, we might say that we don’t care much about storage write performance in Oracle and SQL. Correct?
In short – the answer is no. Read the rest of this entry »
