señorowlconbarriga_Mesa-de-trabajo-1_262x269

GPS Query Performance

A Test Software that allows to Capture, Execute and Compare our Queries in different Oracle environments

Our ally to evaluate and measure the impact of possible changes: upgrades, platform migration, code, patches, etc

capture-01-1_43x49
GPS Query Performance

Product

Our DBAs know the dedication required to make parameterization changes in a productive environment, and the number of manual tests that are required to achieve a minimum of guarantees before approaching a database migration or a version upgrade. Beyond the expensive software solutions of some manufacturers, in 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 the changes, would at least SAVE time for us and soon for our clients. For this reason we present GPS Query Performance.

iconos-web-home-features+grandes-01

Anticipates

With the information obtained after relaunching the queries, possible errors. Avoiding surprises in production passes

iconos-web-home-features+grandes-02

Measure

The behavior of the selected queries, showing their execution plans, times and other performance measures to be compared

iconos-web-home-features+grandes-03

Adjust

It allows identifying queries with problems and making the necessary adjustments to avoid degradations caused by version jumps or changes in the database

iconos-web-home-features+grandes-04

Informs

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

iconos-web-home-features+grandes-01

Anticipa

Con la información obtenida tras relanzar las queries, posibles errores. Evitando sorpresas en los pases a producción.

iconos-web-home-features+grandes-02

Mide

El comportamiento de las queries seleccionadas, mostrando sus planes de ejecución, tiempos y otros medidores de rendimiento para ser comparados.

iconos-web-home-features+grandes-03

Ajusta

Permite identificar las queries con problemas y realizar los ajustes necesarios que eviten degradaciones provocadas por los saltos de versión o cambios en la base de datos.

iconos-web-home-features+grandes-04

Informa

Recoge los datos y estadísticas del entorno actual para comparar el antes y el después de los cambios. Almacena estos datos para usos posteriores en nuevos cambios en la plataforma.

Overview

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-01

Capture

replay-01

Replay

Captura de pantalla 2020-08-07 a las 20.32.16

Works

Capture and Replay

Captura de pantalla 2020-07-03 a las 3.48.54

Your captures

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 will centralize, supported by some native Oracle tools, and through simple software, all the battery of tests necessary to certify the success of any change.

Gallery

Look at our platform

GPS Query photos

Check all the possibilities of our tool, accessing our gallery. In it you can find real captures of GPS Query Performance.

Success stories

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.

New Setelec
Project Manager

Thanks to the implementation of GPS Query Performance and the help of GPS in our change management models,
we have managed to minimize the risks for changes in our software by comfortably testing between environments
of production and development and creating checkout routines for our most critical processes.

TransLogic OS
Applications Manager
GPS Query Performance nos ha resultado una herramienta muy útil para nuestros DBAs y para el equipo de desarrollo. Nos ha reportado un importante ahorro en los tiempos y dedicaciones para las pruebas que necesitamos antes de implementar los últimos cambios en nuestra nueva plataforma.

New Setelec

Responsable de proyectos
Gracias a la implementación de GPS Query Performance y la ayuda de GPS en nuestros modelos de gestión de cambios, hemos conseguido minimizar los riesgos para los cambios en nuestro software realizando pruebas de forma cómoda entre los entornos de producción y desarrollo y creando rutinas de chequeo para nuestros procesos más críticos.

TransLogic OS

Applications Manager