I have a server with hundreds of Firebird DB files and thousands of transactions per hour. I want to be able to monitor the database transactions and see which one takes longer than usual so I can work on improving this specific sql. I am looking for a tool to help with this. The server is a production server so I want something that doesn't take much in terms of server resources. If Firebird has a built-in tool, I don't mind using it.
I need help to set the tool up and explanation of how to use it. Please include any experience you have done that is similar to this.
6 freelance font une offre moyenne de $228 pour ce travail
I am ready to monitor the database transactions and see which one takes longer than usual so I can work on improving this specific sql. please send me a message to discuss further requirements. thanks
Hi! I think you first must read this article [login to view URL] After that you can specify what you want (when you audit databases your performance worsens.). Take in account the version of your firebird Plus
Hello, Having at least 2 years working as an IT business Application Analyst in a Multinational retail chain my key responsibility in making reports through SQL queries. Where we need to write always Optimized querie Plus