Transaction Trace Analysis 12.2 Installation SQL Problem

Our existing 11.5 version has its database on a seperate SQL server - In line with company policy of keeping databases on SQL servers and applications on application servers. The install of version 12.2 seems to try and insist they co-exist on the same server. The install guide does make a note that "Compuware highly recommends a locally installed database for use with TTA. Perfomance may significantly degrade when using a remote database", which would suggest that it is possible to run the database on a seperate SQL server. It does not say how this is done and there is no opportunity to change things in the install reoutine.

Setting aside the impact of running the database on a seperate server, it is possible to install version 12.2 with the SQL database on a remote sever?

3 Replies

But - when you install the DC RUM solution, the TTA is a part of that and it supports remote databases. But based on experience, the comment on performance has some weight as the TTA uses SQL to store packet information as opposed to many other network analytics tools. The more you poke around in TTA, the more you will come to experience the consequences of network latency

Thank you for your comments. With such a change in installation / infrastructure I would have hoped Compuware had spent a little more time documenting the reasons why things have changed. We can't be the only company with a database separation policy. If we have to combine the two onto a single server we need some kind of justification. Also interesting is why such an 'ancient' version of SQL Express is included with the installation media (Version 2005).

Perhaps you need to take this through the policy board a second time. I'm not clear on the choice of the version of SQL, but the purpose is clear. It is done so that you can work without network access. If you rely on a shared services SQL, then you are giving up your autonomy.

Also at this day and age, many of us work out of a luggage bag. If you then need to have a umbilical cord for you laptop that is attached to a physical geography, you become very limited.

I'll see if I can dig something up on other versions of SQL but I think I've managed to work against most of the flavours of the last 10 years.