Block Process Start Times.

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Block Process Start Times.

Postby Luis Martin » Mon Jun 03, 2013 4:41 pm

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?
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm

Postby Brian Donahue » Wed Jun 05, 2013 11:53 am

What does it say under "time raised" and "time ended" on the status ribbon?
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Luis Martin » Wed Jun 05, 2013 6:21 pm

Raised 10:33 AM
Ended 10:34 AM
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm

Postby chriskelly » Thu Jun 06, 2013 2:08 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby Luis Martin » Fri Jun 07, 2013 2:23 pm

Webbrowser and SQL Monitor Base Monitor service :(GMT-03) Buenos Aires
Entities: (GMT-03) Buenos Aires
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm

Postby chriskelly » Fri Jun 07, 2013 2:26 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby Luis Martin » Fri Jun 07, 2013 9:37 pm

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 :D
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest