Post reply

waitresource field 4 blocked & blocking processes

  • October 2, 2003 at 2:11 am

    #65731

    Hi!

    I collected some stats for the applications running on a server. These stats show that about 5 tables are the most often (75%) act as waitresource for blocked processes.

    The developers swear on a bible, that most applications can not ever access these tables.

    What can be an explanation for this situation?

    What is precise definition for waitresource for blocked and blocking processes?

    /* i.e.: waitresource is a resource that blocked process wants to get, but it is taken by blocking process */

    Can the information in sysprocesses table be incorrect as far as waitresource field is concerned?

    /* I am running MS SQL Ent Server 2000 sp3 on Win 2000 Adv. Server sp4 */

    Thanks.

    Edited by - Roust_m on 10/02/2003 02:13:28 AM

  • October 2, 2003 at 5:52 pm

    #476894

    Want to play around with the following sp, maybe it can be of use to you.

    http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q271/5/09.asp&NoWebContent=1

  • October 2, 2003 at 11:25 pm

    #476909

    Figured this out!

    The reason was a poor database design. It contained a table that was referenced by FK on large number of other tables. So updating or deleting on this table caused large number of blocks on the tables that "never used by application"!

    fn_get_sql() works really fine.

    /* Just remember it needs a specific syntax, as described in September issue of SQL Server magazine */

    Edited by - Roust_m on 10/02/2003 11:25:41 PM

    Edited by - Roust_m on 10/02/2003 11:26:56 PM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply