There is a sharply increase in the size of transactions that is inserted in that table,and if i can do partitioning the remaining range of kind field will be half,and...

Thanks a lot for your reply.

Due to the increases in page reads counter in performance monitor(during the time out) I think the problem is fragmentation.I will check the fragmentation...

Tanks for your useful explanation.

As you mentioned and if I understood correctly,if there is a shared table-lock , the INSERT would be blocked until the whole operation(select) completed .Is...

Thanks for your reply

so if i have a select on a table that takes long 25 seconds and an insert on the same table is running at the 10th...

Yes ,excuse me

I am going to read the links

Thank you both for your comments.

Does it have any effect,If i implement partitioning only on one drive ?

I will read more,and also focus on partitioning.

Thanks Jeff

The time out is on inserts.But i can not test any thing on main server.I even could not run DBCC SHOWCONTIG ('dbo.Table_Name' ) to see if it is necessary...

Thanks to all for your helpful suggestions.

EXEC sp_executesql

N'SELECT TOP (1000) [t0].[ReferenceNum], [t0].[TDate], [t0].[Counter], [t0].[Success], [t0].[Kind], [t1].[Amount], [t1].[UID], [t1].[INumber], [t1].[IDate], [t1].[State]

FROM...

the most conflicts faced by me is key lookup in most of queries that i get time out.

also there is a job that updates statistics of a table every night,and...

many thanks

that was a helpful article:-)

the servers are in a workgroup.

both of sql servers are in windows authentication mode i cant connect to server B from server A

also the log on services for both of them are local system.

yes exactly as you said.

thanks a lot for your reply

how can i restore logs to server B?

i use Map Network Drive so i have a drive for backups in server B but...

great it works ,tanks alot both of you.

what about apex?is there any table that it reads from that?

i need to know it shows the log from where?

i think it is...