George Crump, Senior Analyst, at Storage Switzerland ponders the Advantages of DRAM SSD in this recent article. Read the rest of this entry »
Archive for March, 2011
Posted March 31st, 2011
 |
The Advantages of DRAM SSDBy Eyal Markovich |
Posted March 22nd, 2011
|
Cool Tool for Database Performance MonitoringEASILY MEASURE THE NUMBER, TYPE AND LENGTH OF I/O WAITS OVER TIME By Eyal Markovich |
I have recently added a new cool product to the arsenal of tools I use for performance monitoring. The product is called Ignite by Confio. Confio’s Ignite is a database performance monitoring tool focused on identifying the root causes of performance problems in Microsoft SQL Server, Oracle, Sybase and IBM DB2 systems, including those related to database and VMware interoperation.
What I like about Ignite is the simplicity and stability of the product. I installed it a few weeks ago and since then, the product has been running and collecting data without any issues. It is very easy to use and I am able to get real value out of it.
The two things I like the most about Ignite:
- It tracks and reports wait events for the instance level as well as entity level (such as SQL query, program, login, etc.). So I can get I/O wait measurements easily and without doing any calculations.
- Since Ignite stores data in its repository, I can see performance data (including I/O wait) over time. This allows me to easily compare the performance over time and look at trends.
Diagnosing and Resolving Slow Database Batch Processing is a white paper that I wrote which highlights the overall SQL Server performance improvement that can be achieved using the Kaminario K2 storage appliance. The database performance assessment utilizes Confio Ignite for SQL Server to diagnose and quantify I/O bottlenecks as the performance problem affecting the system, and to illustrate the performance benefit achieved from using the Kaminario K2 appliance. Download the white paper or go to Confio for more information.
Posted March 9th, 2011
 |
Kaminario invites customers to join their Technology Sharing Program (TSP) programBy Gareth Taube, Vice President Marketing, Kaminario |
Kaminario invites customers to join their Technology Sharing Program (TSP) program. This program is a partnership between a few select customers and Kaminario and is designed to give customers the opportunity to work closely with the company on designing its future products. Read more about the TSP program.
Kaminario is looking for TSP customers to test a new product in the May time-frame. If you would like to test a revolutionary new storage performance product please email Kaminario at tsp_program@kaminario.com and we will get back to you with additional information about the TSP program.
Posted March 7th, 2011
|
The effect of host/target ports on latenciesBy Eyal Markovich |
I recently tested the performance of an application that was relying heavily on tempdb. Since the tempdb files reside on a dedicated LUN (F:\, in this case), it was easy to examine the performance of this drive through Perfmon. Surprisingly, I noticed an average read latency of 9 ms, which is much higher than the sub-millisecond latency that I usually see from a Kaminario K2 high performance storage appliance. Read the rest of this entry »
Posted March 1st, 2011
|
Solving database performance problems with better storage performanceBy Eyal Markovich |
Any database can be negatively impacted by data access bottlenecks (“I/O wait”) which will 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. If the organization took the time to examine the storage-issues related to I/O wait before simply upgrading system hardware.
In his recent blog post, Dan Kusnetzky, Distinguished Analyst at The Kusnetzky Group, discusses his recent paper on database performance and I/O bottlenecks, “Solving database performance problems with better storage performance.”
