Menu

Tree [84e763] master /
 History

HTTPS access


File Date Author Commit
 DEPLOY 2014-02-19 Cafee Cafee [a8db72] Fix possible problems with more sophisticated G...
 FbWebMon.Base 2014-02-25 Cafee Cafee [84e763] Remove unnecessary dependencies. On Exception p...
 FbWebMon.Web 2014-02-25 Cafee Cafee [84e763] Remove unnecessary dependencies. On Exception p...
 .gitignore 2014-02-14 Cafee Cafee [12d33b] Add deploy scripts written in PowerShell
 FbWebMon.sln 2014-02-25 Cafee Cafee [84e763] Remove unnecessary dependencies. On Exception p...
 INSTALL.builtin.txt 2014-02-12 Cafee Cafee [fca813] Initial commit
 INSTALL.txt 2014-02-12 Cafee Cafee [fca813] Initial commit
 README.short.txt 2014-02-12 Cafee Cafee [fca813] Initial commit
 README.txt 2014-02-19 Cafee Cafee [a8db72] Fix possible problems with more sophisticated G...

Read Me

 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
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.