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.
Hello Client,
I have a 15 years of experience in developing database applications on Oracle Database and others using Delphi.
Please, contact me to discuss more information about your job.
Regards.
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
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 queries that take less load in SQL production.
I think I can provide you a better solution.
Regards
Salman Ahmed