I truly thank everybody for their valuable inputs.

Will try to apply all those mentioned here.

Thanks everybody.

Here is the info from server (used perfmon counters)

Available memory(in mb) - 29914

Free page table entries - 93985

server a

-------

target server memory(kb) - 27785264

total server memory(kb) - 280320

server b

-------

target...

Actually there are is a total of 32gb ram configured for this server.

There are totally 3 intances running on the server including the trouble giver instance.

We have pae in boot.ini

We...

Yes its a 32 bit

and

available memory was 29918 MB

Free system page table entries was 93985

Thanks Imu !

Here is what I got from BOL :

CONTAINSTABLE ranking uses the following algorithm:

StatisticalWeight = Log2( ( 2 + IndexedRowCount ) / KeyRowCount )

Rank = min( MaxQueryRank, HitCount *...

Hi Perry,

Are you available online in any of the chat boxes like yahoo,gmail etc.

If so and if you dont mind can you give me your email id please.

With Kindest Regards,

Sudarsan...

Thanks Perry for the quick and clear response.

Well, maybe you can have a look at my blog :

http://www.incrediblestuff1.blogspot.com

I have given a detailed description about db mail.Maybe that should be giving you a clue.

You might as...