Red Gate forums :: View topic - Block Process Start Times.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Block Process Start Times.

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Mon Jun 03, 2013 4:41 pm    Post subject: Block Process Start Times. Reply with quote

I have the following:

Details
Block occurred at: 3 Jun 2013 10:33 AM

Processes
Blocked process: XXXXXXX
Process ID: 99
Database: XXXX
Host: SERGIO
User: SERGIO
Start time: 3 Jun 2013 8:41 AM

Blocking process: XXXXXXX
Process ID: 98
Database: XXXX
Host: PC-ROSANA
User: ROSANAF
Start time: 3 Jun 2013 8:43 AM

Actually the blocking ocurrs at 10:33 AM and was Medium.

I also check Hosts users times, and are OK.

What I'm missing?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Wed Jun 05, 2013 11:53 am    Post subject: Reply with quote

What does it say under "time raised" and "time ended" on the status ribbon?
Back to top
View user's profile Send private message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Wed Jun 05, 2013 6:21 pm    Post subject: Reply with quote

Raised 10:33 AM
Ended 10:34 AM
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Thu Jun 06, 2013 2:08 pm    Post subject: Reply with quote

Please can you confirm the time-zone of:

- your webbrowser
- the SQL Monitor Base Monitor service
- the entities you are are monitoring.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Fri Jun 07, 2013 2:23 pm    Post subject: Reply with quote

Webbrowser and SQL Monitor Base Monitor service :(GMT-03) Buenos Aires
Entities: (GMT-03) Buenos Aires
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Fri Jun 07, 2013 2:26 pm    Post subject: Reply with quote

Looking back at the details. It lists that the block occurred at 10:33. The following two times are the times that the processes started, and so do not have a relation to the time of the block other than to help you identify the processes involved.

Does that make sense?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Fri Jun 07, 2013 9:37 pm    Post subject: Reply with quote

If you mean: Users began to use Application at : 8:41 and 8:43 and some process, belong to that Application, was blocked at 10:33 then that make sense.

Thanks a lot Very Happy
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group