if it helps build the complete picture, the log bytes/sec at this time are 1.8MB - 1.6MB

Gila,

The app is running now, but with the counters gathering stats for more than an hour now, I thought we had a reasonable assessment with us. Here is what I...

Gila,

As I mentioned before, not all of the slow performance is attributed to the DB server; in fact it is not being seen as the primary source of slowdown; this...

I believe I have just the one Index on the most voluminous tables -

T-DLR-RTC (6.9 million)

Index - Sequence-number (Non Clustered)

T-TRSPL_RCC (6.9 million)

Index - Sequence-number (Non Clustered)

I will check to...

I meant to say I am seeing a lot of sessions with a 100% writer thread stats for this DB

Oh I should have mentioned this in the initial description -

the DB write performance was the professed bottleneck based on the application session logs - Informatica has this session...

Gila,

Let me get the other statistics too you had asked for .. perhaps there is something in them that could explain the 'suspect' sub-optimal performance. Meanwhile, heres the question again,...

Gail, Jeff,

My apologies for the silence .... kinda juggling between a flurry of issues here. I could gather some information from the scheduled perfmon logs and other documentation .... I...

Gail,

I guess I would want to know about all 3 - memory/disk performance analysis, advice on app and the disk layout (per your convenience).

While I understand that these numbers themselves...

There ya go! I was almost beginning to feel only I could see my posts on the forum ..... I was not getting any replies .....

Gail, nothing significant...

Was there anything I could have done better to have some one reply?

Ok ... I am told, running the application again for recovery is okay on non-quarter months, and not on quarter-close months.

Thanks for all the help!

Gail,

Thanks again for getting back! I will check with the users - this could be interesting to know since for as long as I have been here, we have never...

Jeff,

Not all of T_a is truncated - most of it is - the final reporting tables that house all of the enterprises business for a year have data rolled off...

Thanks a lot you all!

To Jeff's question -

T_r data is never truncated - it has a few DMLs issued very infrequently

To Gail/Krishna's question -

As I understand, since data...