Subject | Re: [firebird-support] Firebird 2.5.1 and SQL Server 2008 R2 on same server? |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2012-05-15T19:38:09Z |
Hello, alexander.melak!
Tuesday, May 15, 2012, 4:32:16 PM, you wrote:
am> i'm a newbie concerning firebird and my question is really simple:
am> I have to install firebird 2.5.1 in our environment for the first
am> time and my first decision to make is: on which server shall i install firebird?
am> It sounds logical for me to install firebird on my existing
am> database server to hold all my databases on one single server, but this server is already
am> running sql server 2008 r2 standard (operating system: windows server 2008 r2 standard)!
am> Is it clever to run both services on the same server?
not a good idea to keep 2 database servers on the same computer.
At least, they will fight for the storage performance.
You can combine rdbms'es only if you are sure that no one server will be highly
loaded or will consume computer resourses.
While Firebird does not eat processor and memory too much (depends on
load and number of users), MS SQL can allocate all the memory and
leave nothing for Firebird. Another kind of problem happens
with PostgreSQL and Firebird on Linux, etc.
am> Are there any incompatibilities known between both products?
no.
am> Anything special to pay attention to?
If you able to monitor resource consumption
(memory, processor, disk) on windows, and you know how to tune MS SQL
and FB, than it will not be a problem for you to understand
where performance problem is, if it happens.
--
Dmitry Kuzmenko, www.ib-aid.com
Tuesday, May 15, 2012, 4:32:16 PM, you wrote:
am> i'm a newbie concerning firebird and my question is really simple:
am> I have to install firebird 2.5.1 in our environment for the first
am> time and my first decision to make is: on which server shall i install firebird?
am> It sounds logical for me to install firebird on my existing
am> database server to hold all my databases on one single server, but this server is already
am> running sql server 2008 r2 standard (operating system: windows server 2008 r2 standard)!
am> Is it clever to run both services on the same server?
not a good idea to keep 2 database servers on the same computer.
At least, they will fight for the storage performance.
You can combine rdbms'es only if you are sure that no one server will be highly
loaded or will consume computer resourses.
While Firebird does not eat processor and memory too much (depends on
load and number of users), MS SQL can allocate all the memory and
leave nothing for Firebird. Another kind of problem happens
with PostgreSQL and Firebird on Linux, etc.
am> Are there any incompatibilities known between both products?
no.
am> Anything special to pay attention to?
If you able to monitor resource consumption
(memory, processor, disk) on windows, and you know how to tune MS SQL
and FB, than it will not be a problem for you to understand
where performance problem is, if it happens.
--
Dmitry Kuzmenko, www.ib-aid.com