Cita:
Empezado por ContraVeneno
¿Existe alguna herramienta parecida al SQL Server Profiler que funcione con una base de datos de Firebird?
Buscando en google, en firebirdsql y aquí en el foro menciona un Interbase Monitor u observer, pero no encuentro de donde bajarlo. Existe un IBMonitor, pero supongo que al ser para interbase, no funciona en Firebird porque lo ejecuto y na mas no jala... (error de acceso de memoria al entrar).
¿alguien conocerá alguna herramienta para ver qué consultas o transacciones se ejecutan en una base de datos firebird 2.1?
|
no sabria decirte ..
¿
como funciona eso de
SQL Server Profiler ?
¿que beneficios hay. por que se usa, donde y en que situaciones es necesario
monitorear con una herramienta asi?
estos tienen herramientas
http://www.sqlmanager.net/en/products/studio/ibfb
http://sqlmaestro.com/products/firebird/
esto parce que si es
http://support.embarcadero.com/en/article/34781
Problem: Use the TIBSQLMonitor component to monitor the dynamic SQL that passes through the InterBase server. You can write an application that can view only its own SQL statements, or you can write a generic SQL monitor application that monitors the dynamic SQL of all applications built with InterBase Express (IBX). Use the TIBSQLMonitor component to watch dynamic SQL taking place in all InterBase data access applications both before and after they have been compiled. Solution: To build a simple SQL monitoring application, follow these steps: 1. Open a new form in Delphi. 2. Add a Memo component to the form and clear the Lines property. 3. Add a TIBSQLMonitor component to the form 4. Double-click the OnSQL event and add the following line of code: Memo1.Lines.Add(EventText); 5. Compile the application. You can now start another IBX application and monitor the code.
esto no se
http://blogs.teamb.com/craigstuntz/2004/09/07/1249/
esto nose
http://cc.embarcadero.com/item/16162
Interbase® Monitor is a small utility witch monitors current attached databases and users.
MiTeC Interbase Performance Monitor v.2.2FW482 k05 Feb 2002By
MiTeC. InterBase 6.x Performance Monitor. It scans and shows some parameters of Interbase state such as:
- Memory and CPU usage
- Reads from memory buffer cache
- Writes to memory buffer cache
- Reads from database
- Writes to database
- Active users
- Server log
- Allocated pages
- Number of buffers
- Removals of a version of a record
- Removals of fully mature records
- Removals of a record and all of its ancestors
- Reads done via index
- Sequential table scans
- Database updates
- Database inserts
- Database deletes
- Local SQL Monitor (for apps based on FIBPlus).
Fully functional
Source: N/A
Download: ME NT4 W2K W95 W98 XP