|
INTERVIEW QUESTIONS
DATABASE
FIREBIRD
DETAILS
Question: How to monitor Firebird server activity?
Answer: Firebird 2.1 introduces server-side monitoring via special system tables. This way you can monitor your server directly from SQL. Those system tables all have prefix MON$ in their name. To use them, you need to make sure your database file is created with Firebird 2.1 or higher (ODS version 11.1). If you have a database that is created with earlier versions, you need to do backup and subsequent restore with Firebird 2.1 to have those tables.
For detailed information about each monitoring table, read the file README.monitoring_tables in 'doc' directory of your Firebird installation.
Please note that monitoring tables just offer the data, but you'll probably need some way to aggregate those and spot the problems. Most of these tools can also be used to monitor earlier Firebird versions as well.
|
|
|
Category |
Firebird Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8145 users |
Added on |
7/23/2015 |
Views |
65458 |
Rate it! |
|
|
Question:
How to monitor Firebird server activity?
Answer:
Firebird 2.1 introduces server-side monitoring via special system tables. This way you can monitor your server directly from SQL. Those system tables all have prefix MON$ in their name. To use them, you need to make sure your database file is created with Firebird 2.1 or higher (ODS version 11.1). If you have a database that is created with earlier versions, you need to do backup and subsequent restore with Firebird 2.1 to have those tables.
For detailed information about each monitoring table, read the file README.monitoring_tables in 'doc' directory of your Firebird installation.
Please note that monitoring tables just offer the data, but you'll probably need some way to aggregate those and spot the problems. Most of these tools can also be used to monitor earlier Firebird versions as well. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How to move a multi-file database?
|
View Answer
|
|
How to open the database in exclusive mode?
|
View Answer
|
|
How to pipe multiline string to isql?
|
View Answer
|
|
How to determine who is and change the owner of database?
|
View Answer
|
|
How to detect the server version?
|
View Answer
|
|
How to detect applications and users that hold transactions open too long?
|
View Answer
|
|
How to debug stored procedures?
|
View Answer
|
|
How to deactivate triggers?
|
View Answer
|
|
How to create a database from my program?
|
View Answer
|
|
How do convert or display the date or time as string?
|
View Answer
|
|
How to configure events with firewall?
|
View Answer
|
|
How to change database dialect?
|
View Answer
|
|
How to add, remove, modify users using SQL?
|
View Answer
|
|
How to activate all indexes in Firebird?
|
View Answer
|
|
Can I concurrently access a Firebird database with embedded and with regular server?
|
View Answer
|
|
What is command for supporting foreign key in Firebird?
|
View Answer
|
|
What is the maximum number of rows in a table in Firebird?
|
View Answer
|
|
What are the vital features of Firebird that makes it powerful database?
|
View Answer
|