Showing posts with label DB2. Show all posts
Showing posts with label DB2. Show all posts
Tuesday, July 3, 2012
Comparison of different SQL implementations
I found an excellent resource to perform a comparison of the different implementation of SQL in various databases. The document is found here.
Tuesday, April 19, 2011
Confio Ignite
Most developers and DBAs are aware of Toad to help with performance tuning and database management. However, very few are aware of Confio Ignite. This is an excellent tool for identifying and fixing performance issue in your Oracle, MS SQLServer, DB2, and Sybase.
It help answer questions like
It help answer questions like
- Why is an application waiting on the database and what can be done?
- How did the code promotion affect response times in your database?
- Did the vendor patch really fix the problem?
- Which bottlenecks in your database directly impact end-user service?
To try out the tool, you can use the free version called IgniteFree.
The tutorial is available here.
In addition to that you can also see
4 Oracle Performance Tips You Should Know presented 24 June 2010
Learn how to determine the best tuning approach for a SQL statement by utilizing response time analysis and visual SQL diagramming techniques. A "must see" for those who rely on OEM Performance Packs.
The tutorial is available here.
In addition to that you can also see
- Ignite PI for SQL Server Demo (5 minutes tutorial)
- Ignite PI for Oracle Demo (5 minutes tutorial)
- 4 minutes narrated slide show
There are also Webinars provided:
Learn how to determine the best tuning approach for a SQL statement by utilizing response time analysis and visual SQL diagramming techniques. A "must see" for those who rely on OEM Performance Packs.
4 SQL Server Performance Tips You Should Know presented 25 May 2010
Learn a four-step process that will help you quickly find and correct the bad SQL code. Covering topics such as: SQL diagramming, wait type data, column selectivity, and more.
Subscribe to:
Posts (Atom)