Client application generating time-outs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Client application generating time-outs

Client application generating time-outs

Rate Topic

Display Mode

Topic Options

Author

Message

Clark Bones

Posted Monday, December 03, 2012 5:50 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:46 AM
Points: 17, Visits: 161

Hello!

We are having problems with an application which accesses our SQL Server DB. The application generates time-out errors. The application processes XML files and inserts data through issuing INSERTs/UPDATEs commands.The inserts and updates are simple and should consume little time. The application uses JDBC driver for SQL Server 2005. The problems are not reproducible in our test environment, the same files are loaded without any errors.

Setup: SQL Server 2005 SP3 Standard Edition on virtual machine VMWare/ESX
I have checked the SQL Server Logs and found nothing.
I have checked the configuration and there's nothing extraordinary compared to default values. Production and test machine configs are very similar.
I have checked index fragmentation and everything seems OK.

I have run a server side trace and found very little suspicious. I remember reading something about a potential issue when using the JDBC driver. Under some circumstances, the combination of a connection originating from the JDBC driver and another connection (not JDBC-originated) might cause problems if they were issued simultaneously. Though I can't find the link, I remember the connection pool was involved.

Anyway: To exclude the possibility of a cause described, I disabled the Database Mail functionality. In the first trace I could see the database mail component access the database. I did this through the surface area configuration tool. Interestingly enough, the database mail component still connects to the database every five minutes. Using sp_configure, I can see that the database mail component is not enabled.

So, here's my two questions:
- How can I completely disable database mail?
- Has anyone heard of a similar issue?

Post #1391877

Bhuvnesh

Posted Thursday, December 06, 2012 1:23 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Clark Bones (12/3/2012)

How can I completely disable database mail?

see

USE msdb ;
GO

EXECUTE dbo.sysmail_stop_sp ;
GO

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1393362

« Prev Topic | Next Topic »

Permissions