Hi Anil,

If possible could you please share Capacity planning for Database growth.How are you tracking Db growth.

Hi,

I got my ans and i am going to implement this.

If I get any issue then let you know.

T & R,

Shikha

Hi,

There is a need to do the same.

Is this possible to recover the .ldf file in any case.

Regards,

Shikha

Hi,

I can help you may be.

As per my knowledge :

•Excessive Compilation And Recompilation

•Inefficient Query Plan

•Intra Query Parallelism

•Poor Cursor Usage

First you check all these areas to find cpu bottelneck.

Regards,

Shikha