2 ILM Sync Engnes 1 SQL DB that supports a front end Web page for account management RRS feed

  • General discussion

  • Situation

    1 SQL Server with that supports a Webpage used to create accounts lets call the WEBSITE (ALPHA)

    2 ILM servers that both have MA's that point to the same DB and Table on the SQL Server. 

    Often the Web Site ALPHA has an error stating that it is unavailable

    when logged into the SQL Server i see the following info about the DB

    wait type LCK_M_IX

    wait Resource pagelock field

    task state suspended

    On the 1 of the ILM Servers i get a few Event ID's 6050 and Event ID 6060

    I believe this issue is related to both ILM servers connecting to the same DB but wanted to some other thoughts.

    I am currently trying to monitor times of syncs on each ILM Server and correlate to the next triggered event.

    Anthony Marsiglia

    Wednesday, November 21, 2012 2:38 PM