December 2, 2008 at 3:06 pm
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 😉
December 3, 2008 at 5:03 am
Can you post the contents of the email as a text document and seperate image docs so we don't have to open it in outlook?
ed
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply