- Please install interbase to use this functionality software#
- Please install interbase to use this functionality code#
Tab "All connections and Logs" contains the list of all connections and related as master-detail transactions and statements. It will bring you the tab "All connections and Logs". When you have identified the query which has problems, you can see its connection and transaction: for this right-click and choose "View connection and transactions for statement ID=.". You can also force FBScanner to log SQL plans, for this you need to set an appropriate checkmark in "FBScanner Service Settings". You can narrow your search - set start and end moments and then queries on EXECUTION_TIME in order to see the longest queries.įor each query you can see SQL query text, its parameters, start/end time, count of fetched records, and also know who and when executed it: IP address, username, etc. Please note that there are SQL queries from all connections which are logged by FBScanner (it is possible to setup FBScanner to monitor only the one connection or group of computers, or only selected application - all you need is to use an appropriate connection string and/or ports - please read about it in "FBScanner User Guide"). If you have selected tab "All Statements", subsequent list of all SQL queries will be shown. After that right click on the point where you want to go into details and choose "Go to the SQL list on HH:mm". You can zoom and scroll this performance graph, turn on and off parameters to show - in order to catch the moment when the problem starts. It is easy to see peaks of load and determine the moments where performance was bad. At the first tab, "Server load", you can see an overview of SQL connections and statements. Run "FBScanner Log Analyzer " and connect to the log database. After that, all SQL traffic which goes through FBScanner will be stored in the log database. Run "FBScanner Service Settings" from the Start menu, then click "Advanced options", tab "SQL Log ".Ĭreate log database (it should be on another Firebird instance on this or another computer - please refer to "FBScanner User Guide", pages 14-16 for details). STEP 1: LogAnalyzer "Server Load"ĭownload FBScanner demo version and install it.
How can FBScanner help to identify and resolve Firebird or InterBase performance problem? Let's quickly review the most interesting features of FBScanner, and start with LogAnalyzer module.
Please install interbase to use this functionality software#
Check that disconnection is taking place correctly and you can also use this software to disconnect users in order to perform maintenance or database upgrades. Detection of the oldest connection and the oldest active transaction to allow you to analyze that may have non-optimal transaction behavior, or incorrect transaction design or show users who might be using the application in a manner that may be affecting performance.
For each connection, FBScanner shows all the currently running SQL queries along with their transaction parameters. FBScanner Viewer shows all connections to the selected database server: the IP/DNS name of the connected client, database and connection time.
Please install interbase to use this functionality code#
FBScanner is the only tool to analyze SQL queries in production Firebird and InterBase databases in versions before Firebird 2.1, especially if the application has been developed by third-party's and there is no source code available.
0 kommentar(er)
