Post reply

PREEMPTIVE_COM_GETDATA

  • October 28, 2011 at 1:58 pm

    #262108

    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

  • January 30, 2012 at 12:34 pm

    #1440197

    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...

  • January 30, 2012 at 1:17 pm

    #1440216

    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

  • February 6, 2012 at 11:03 am

    #1443338

    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

  • July 14, 2013 at 12:37 am

    #1632212

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

  • May 25, 2022 at 5:17 am

    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