SMMS Shows blocks when connecting from local PC but there are no locks.

S

SBSP

Senior Member
Joined
Sep 7, 2007
Messages
663
When running the SMMS Client on my PC its shows there is a blocking process = 1 on all SQL transactions.
But when looking at it on the actual server via RDP there are no blocks.

I thought it was my SMMS installation on my PC but the same happens on my colleague's PC

Seems like all remote connections display wrong info ? Could it be a setting ?, Its just the 2 of us using it and there were no changes to the config, the only differance is we both upgraded to Win10
 
H

halfmoonforever

Expert Member
Joined
Feb 1, 2016
Messages
1,196
Nope. If it says there's a lock/block there probably is. I had some handy scripts (which I lost) that showed me exactly where/why/who/when which highlighted a lot of "it wasn't me" type stuff.

Is this a production server?
 
S

SBSP

Senior Member
Joined
Sep 7, 2007
Messages
663
Yes its a production server. But why would the block not show on the server client ?
 
S

SBSP

Senior Member
Joined
Sep 7, 2007
Messages
663
Damn! They were real locks! They have been sitting there for days, I just went and killed them and now the list is empty. Weird that the Server client didnt pick them up. I'm a bit confused now.
 
H

halfmoonforever

Expert Member
Joined
Feb 1, 2016
Messages
1,196
SBSP said:
Damn! They were real locks! They have been sitting there for days, I just went and killed them and now the list is empty. Weird that the Server client didnt pick them up. I'm a bit confused now.
Click to expand...

Told you so :p

I've gotten used to the erratic difference between server/remote access on these things sometimes.
 
You must log in or register to reply here.
Top