GPS Query Performance.
Software for capturing, executing and comparing queries in Oracle environments
GPS Query Performance is a Software that allows to Capture, Execute and Compare our Queries in different Oracle, SQL server and PostgreSQL environments.
Our ally to evaluate and measure the impact of possible changes: upgrades, platform migration, code, patches, etc
Ensure compatibility and performance of your Queries after a migration from Oracle to PostgreSQL.
What is GPS Query Performance?
Our DBAs know the dedication required to make parameterization changes in a productive environment, and the number of manual tests required to achieve a minimum of guarantees before tackling a database migration or a version upgrade. Faced with the complex and expensive software solutions of some manufacturers, in GPS We propose that you have a simple tool that allows us to capture, reproduce and analyze queries in different Oracle environments. Query-Performance shows us in detail the performance and metrics that will help us make decisions and anticipate possible problems before implementing those changes in our Oracle environment. Without a doubt, our software will represent a REAL SAVING of time for the Database and Development teams of our clients.
Our solution will allow you to analyze not only the consequences that “scheduled and future changes” on the Oracle environment will have on your Queries, but it will also help you study and analyze which queries have been the ones that have been able to cause a loss or degradation in the service. when this behavior does not respond to a scheduled change. We can do this by retrieving metrics and data on the behavior of a Set of Queries before the moment of crisis and comparing them with the behavior of those same Queries at the current time.
After several years of work dedicated to shaping this idea, at GPS Open Source we are delighted to be able to present GPS Query Performance and its strengths.
With the information obtained after relaunching the queries, possible errors. Avoiding surprises in production passes
The behavior of the selected queries, showing their execution plans, times and other performance measures to be compared
It allows identifying queries with problems and making the necessary adjustments to avoid degradations caused by version jumps or changes in the database
Collect data and statistics from the current environment to compare before and after changes. Stores this data for later use in new changes to the platform
At GPS we understood that having a tool that allows us to reproduce and analyze queries in different environments, simulating the response and performance before implementing changes, would be at least a SAVING of time for us and soon for our clients. For this reason we present GPS Query Performance.
Capture and Replay
About GPS Query Performance
We present GPS Query Perfomance, a tool for analyzing, comparing and executing queries on Oracle platforms. A solution that aims to save database and development teams a lot of time, time spent conducting tests, tests and detailed checks between the environments, tests that until now have meant large time dedications and significant outlays on software licenses.
GPS-QP is a tool that, based on some native Oracle tools, centralizes with a simple software the battery of tests necessary to certify the success of any migration/upgrade or change scheduled for the Oracle environment.
It will also allow us to analyze and measure the performance of the queries, saving their statistics and comparing them with other environments and or moments of execution.
GPS Query Performance has been a very useful tool for our DBAs and for the development team.
It has brought us significant savings in time and dedication for the tests we need before
implement the latest changes to our new platform.
"I wanted to report on the Oracle database migration that we have managed to do in the Rivas City Council. We have migrated from version 11.2 to version 19 with very few issues.
I have to thank the people of GPS Open Source for helping us analyze this migration with GPS Performance Query tool."
"We have installed the software and we have access to all the Oracle databases in our environment. Last week we had a performance problem in a database and we took advantage of Query-Performance to analyze the problems in the queries. David, our DBA, that the tool worked very well, that it is very fast and that it obtained the information of what could be the problem much more quickly and easily than with the usual Oracle tools. We think that it could be very interesting also for the teams of development, we will request a proof of concept for your platform."