Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

PREEMPTIVE_COM_GETDATA Expand / Collapse
Author
Message
Posted Friday, October 28, 2011 1:58 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 302, Visits: 225
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



Post #1197659
Posted Monday, January 30, 2012 12:34 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:55 PM
Points: 377, Visits: 535
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...
Post #1243858
Posted Monday, January 30, 2012 1:17 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:37 AM
Points: 2,673, Visits: 3,325
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.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1243880
Posted Monday, February 06, 2012 11:03 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, March 03, 2014 7:31 AM
Points: 731, Visits: 405
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
Post #1247573
Posted Sunday, July 14, 2013 12:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 03, 2013 2:51 AM
Points: 1, Visits: 142
This may be due to the query execution from linked serevrs.
Post #1473346
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse