Thanks for your immediate reply.

Can you elobrate how to do this?? as i told you i given unlimited connection..even though i am getting this issue.

Is this problem related with front...

Thanks mike,

Pls let me know how much ram i can allocate to sql server??

we have 65 gb ram on node1 and node2.

Pls let me know what explanation i can...

Thanks for your immediate replay..

As i am oracle dba,not no much about pt in sql server 2008..

Pls elobrat your answer so it will help me lot .

Regards,