Hello again,
Can anybody tell me what shoul i check for the problem (image) that i put in one attached .zip file (FW EPG Manager - Problemas Bd's.zip)
The point is that this guys are telling me that thay have a lot of timeouts when they are running one process inside management studio.
I've already check if there are locks in the database and nothing.
Q1-
select * from sys.sysprocesses where blocked <> 0
Q2-
I've try to make one select in one table that they suppose have problems and this table return to me all records without any problem.
use boepg
go
select * from dbo.Canais with (nolock)
go
Q3- i've check if there are any open transactions and nothing.
use BOEPG
go
SELECT open_tran FROM sys.SYSPROCESSES WHERE blocked<>0
go
and
dbcc opentran
What should i check more.
Thanks and regards,
JMSM 😉