But it does not seems the problem is related to the l0op,When I remove the Select statment it workes pretty fast.Also when I used the xEvents here is the result:

wtype...

I created a loop like (This is how it runs in productions,in a loop the SP is being called):

DECLARE @Temp AS INTEGER

SET @Temp = 1

WHILE @Temp <1000

Begin

...

Actually I need the output.

If I remove the select statment runs very fast.Is there anyway to remove that select statment.this code has been generated from Stored Procedure call in C#

Thanks for your reply,what should I set in code to pypass that select statment.Because without that select statment ,it's running very fast.

I have the same issue,Has anybody found solution for this problem?

Thanks

Thanks for your reply.

But setting the compatibility level to SQL SERVER 2000(80) does it have any effect on Performance and Operation of engine itself.

Thanks

no,I don't,for each thread ,it is creating a new connection,and cause of that there are 100-200 connection exists.Can this number of connection cause the problem.

No,it is not dynamically expanded and we need manually to expand them.does this cause any problem for SQL SERVER

I don't want to SQL SERVER detect the Drive size,I just want to make sure,expanding drive size will not cause any problem for SQL SERVER in Cluster environment.

Thanks a lot for your reply.Then it is ok,I f I use Standard Edition(SQL SERVER 2008 R2) for Distributor and Enterprise Edition(SQL SERVER 2008 R2) for Publisher.

So,by taking a backup from Transaction logs will automatically truncate it.

I have similer problem ,I do not know how can I give permission non window domain users to access reportserver url .

In security setting,I can only give permission to Windows...

Thanks alot for your reply.

Is there any standard for setting the Max Memory for SQL SERVER 2008(Like 80% of Physical memory)?