PREEMPTIVE_COM_GETDATA

  • We are running SQL2008R2 64 bit standard version.

    One of the application encountered (via Tomcat service) error " database.pool.ConnectionPool Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.BindException: Address already in use: connect" when the application has high usages. I noticed there were PREEMPTIVE_COM_GETDATA wait types associated. What is the Preemptive _com_getdata wait type? or any one know what the tomcat error mean?

    Thanks in advance for any response.

    Jenny

  • I am seeing the preemptive_com_getdata wait also with a db2 ole linked server connection. Did you have any resolution?

    There is an exception to every rule, except this one...

  • Did you run sp_who2 and see if there is any blocking going on? I believe we had issues with tomcat trying to open connections over and over again and it screwed things up.

    Jared
    CE - Microsoft

  • Preemptive is a non-cooperative, which generally happens with processes that are running outside SQL.

    This is not good for SQL Server as it is a particular external process which makes SQL Server to yield.

    Sometimes it can be fixed by re-indexing/de-frag but most of the times it happens if there are a lot of Context Switches on your server. Consult your SA

  • This may be due to the query execution from linked serevrs.

  • This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

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