Re: Digging in to trace files


hpuxrac wrote:
> Ed you are probably aware that even though the server is running MTS
> you can create a dedicated connection when you need to correct?
>

Yes, and that is something I still need to address. I know I can set
up separate 'dedicated mode' and 'shared mode' entries in tnsnames, and
that's what I've been doing for my own testing. However, the app uses
JDBC Thin Client, and their connection specification data is held in
some sort of resource file controlled by the administrator of the
middleware. I haven't yet gone down that road to see if there is some
way of specifying to the app to use different types of connections for
different types of work. What is known is that the app that drove us
to shared server by requiring a high number of concurrent sessions ALSO
has some lengthy batch processing. (There are several apps impacting
this db -- it is only used directly by the middleware to hold
'persistence data' for several web-based apps.)

> Most batch jobs should probably be running dedicated anyway and the
> ability to create and then trace a dedicated session to help in the
> debugging is very handy.
>
> *** But I haven't tried Egors utility ( which is EXCELLENT !) on an MTS
> system ... this might help somewhat but there are issues with getting
> all the files depending on number of servers.

Thanks. I'll take a look at it.

.

Relevant Pages

  • Re: Deployment + Vista
    ... I'm talking about the user being able to edit the server connection setting ... MSI will allow you to edit the app directory, ... function in order to put together the connection string something like: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Thread Issue
    ... > in/output streams to all of them from the application server. ... > a sepreat client. ... So your 'app' server is acting as a proxy; every client connection made to ...
    (comp.lang.java.programmer)
  • Re: Interesting issue connecting to Sql server through a firewall..
    ... Client Network Utility. ... >This app communicates to a sql 2000 server on our corporate network. ... >connection is via microsofts jdbc 2000 connector. ...
    (microsoft.public.sqlserver.security)
  • Re: Opening ServerSocket in EJB
    ... However, there's a vague chance it will work, and if it does, i imagine opening a server socket right from an EJB will be the simplest way of solving your problem. ... I'm not aware of a standard, portable way of adding application-layer protocols to app servers. ... You'd write a JCA resource adaptor to handle the connection, configure an instance of it in your app server, and use that from an EJB, just as you'd use a database connection or message queue. ...
    (comp.lang.java.programmer)
  • Re: SQLServer 2000 Driver for JDBC behaviour on SQL Server restart
    ... > Luke Webber wrote: ... > connection fails; it then auto reconnects, you do some more work while ... like a web app, which stays up for long periods of time. ... in the event that you are accessing the server ...
    (comp.lang.java.databases)