December 3, 2012 at 5:50 am
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?
December 6, 2012 at 1:23 am
Clark Bones (12/3/2012)
How can I completely disable database mail?
see
USE msdb ;
GO
EXECUTE dbo.sysmail_stop_sp ;
GO
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply