I have ASSP build 15059 running on Windows 2008 Server against a MS SQL Server 2008 R2 database. It's running Activestate v5.20.1 (32 bit).
The server has lots of disk space and 16 GB of RAM. I have seen as many as 50 simultaneous inbound SMTP connections, but it averages more around 10-15. I'm having major problems where ASSP will just die, stop accepting connections for long periods of time - between 30 and 60 seconds. Sometimes it will just run really slowly, where it will accept a connection, but it will be 30 seconds or more before the connection is transferred to the mail server and a 220 response is received. During this time, both the mail server and the SQL server are basically idling, doing nothing at all. However, I am seeing this being logged in ASSP: Mar-04-15 17:13:40 [Worker_5] Warning: Worker_5 - check the database connections has taken 2.375 seconds (max=1.000s) Mar-04-15 17:14:41 [Main_Thread] Warning: Main_Thread - check the database connections has taken 2.822 seconds (max=1.000s) Mar-04-15 17:16:45 [Worker_10] Warning: Worker_10 - check the database connections has taken 27.143 seconds (max=1.000s) Mar-04-15 17:17:41 [Worker_2] Warning: Worker_2 - check the database connections has taken 7.436 seconds (max=1.000s) Mar-04-15 17:21:56 [Worker_9] Warning: Worker_9 - check the database connections has taken 25.270 seconds (max=1.000s) Mar-04-15 17:27:23 [Worker_6] Warning: Worker_6 - check the database connections has taken 4.449 seconds (max=1.000s) Mar-04-15 17:27:24 [Main_Thread] Warning: Main_Thread - check the database connections has taken 5.634 seconds (max=1.000s) Mar-04-15 17:27:26 [Worker_9] Warning: Worker_9 - check the database connections has taken 4.603 seconds (max=1.000s) Mar-04-15 17:27:26 [Worker_7] Warning: Worker_7 - check the database connections has taken 5.896 seconds (max=1.000s) Mar-04-15 17:29:14 [Worker_10] Warning: Worker_10 - check the database connections has taken 9.730 seconds (max=1.000s) When the server is running smoothly (and it does, sometimes!) and processing lots of mail, I can see the SQL server processing between 30-50 transactions per second. When ASSP stops responding, and starts logging the database connection messages, the SQL server activity drops to pretty much zero. So I don't think a database bottleneck is the issue. My DBdriver is set to ADO,provider=SQLNCLI10;DataTypeCompatibility=80; I have my DBCacheMaxAge set to 10. Any ideas what else I should be looking for to figure this problem out? ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
