FbDbMon Code
Small web-based application for monitoring Firebird database
Status: Beta
Brought to you by:
cafee
File | Date | Author | Commit |
---|---|---|---|
DEPLOY | 2014-02-19 |
![]() |
[a8db72] Fix possible problems with more sophisticated G... |
FbWebMon.Base | 2014-02-25 |
![]() |
[84e763] Remove unnecessary dependencies. On Exception p... |
FbWebMon.Web | 2014-02-25 |
![]() |
[84e763] Remove unnecessary dependencies. On Exception p... |
.gitignore | 2014-02-14 |
![]() |
[12d33b] Add deploy scripts written in PowerShell |
FbWebMon.sln | 2014-02-25 |
![]() |
[84e763] Remove unnecessary dependencies. On Exception p... |
INSTALL.builtin.txt | 2014-02-12 |
![]() |
[fca813] Initial commit |
INSTALL.txt | 2014-02-12 |
![]() |
[fca813] Initial commit |
README.short.txt | 2014-02-12 |
![]() |
[fca813] Initial commit |
README.txt | 2014-02-19 |
![]() |
[a8db72] Fix possible problems with more sophisticated G... |
FbDbMon =========== FbDbMon (Firebird database monitor) is a small utility for monitoring Firebird server state. It should help you with tweaking database for best performance. It can tell you configuration of firebird server itself and database. It displays all current connections and running transactions. It will calculate cache hit ratio for them. It can also log transactions running on database and help you with performance optimizing of you applications. Requirments =========== ASP .NET framework 4.0+ Firebird Server 2.5+ Firebird .NET provider 4.1+ Configuration ============= For simple instalation everthing shoult work out of the box, but i recomend you to store connection strings in web.configuration files. Connection string could be stored under ConnectionString or AppSettings section of configuration files. Connectin strings must be .NET formated like: 'Database=(file);Datasource=(server);User=(sysdba);Password(masterkey);dialect=(1|3);' Optionally you could set Connection pooling. For more informations about it please visit firebirdsql.org website I recomend you to use ConnectionString part of config file. Under ConnectionString section it should look like this: <add name="(name)" providerName="FirebirdSql.Data.FirebirdClient" connectionString="(ConnectionString)" /> It will only allow to use connection stings with providerName equals to FirebirdClient library assembly name. Under AppSettings section if ahold look like this: <add key="(name)" value="(ConnectionString)" /> You could set prefix for all Transaction Trapper items in database. If you want it you sholud put something like this under AppSetting section in web.config: <add key="TriggerTablePrefix" value="DBM$" /> Tested platforms ================ FbDbMon was developed on Windows environment with IIS 8 web server, but it's possible to run it under other operating systems. I try it under Linux (Debian Jessie, kernel 3.10) with nginx (1.4.1) server and Mono funtime. It runs, but it's slower then on Windows installation. I don't recomend to run it under non Windows server. Instalation =========== Please red INSTALL.txt for standalone installation or INSTALL.buildin.txt for instalation into another asp.net application. Developing ========== Use Microsoft Visual Studio 2012 with Web Essentials extensinos. (c) Lukas Vykydal 2014 Written 10.2.2014