#21622 [Opn->Bgs]: MSSQL: 100% CPU usage on database queries and eventually timeout

ID: 21622 Updated by: sniper@php.net Reported By: admin@bozobits.com -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Win2K PHP Version: 4.3.0 New Comment: Not PHP bug -> bogus. Thanks for reporting. Previous Comments: ------------------------------------------------------------------------ [2003-01-16 13:10:41] admin@bozobits.com This problem looks like it is solely related to the phpbb forum code. I have isolated the problem there and submitted a bug report to them. Performance is still overall sluggish and cpu intensive, but not a bug :) Thanks! BBJones ------------------------------------------------------------------------ [2003-01-13 13:16:29] admin@bozobits.com I installed php to utilize phpbb forums on a dual CPU high end server. Win2K MSSQL 7.0. Performance was ok but now having only 10,000 posts (and having moved to another server single P3 CPU) I cannot get anything to return from the database. CPU pins at 100% until my forums eventually timeout. All utilization is coming from MSSQL Server (cpu usage and memory). I did have huge memory leak problems coming from MSSQL server on the first server (was using latest PHP installed around Oct/2002). This seems to have gone away (PHP 4.3) but I can't tell for sure since I can't use the forums yet. I have another set of forums on the same server (PHP/MSSQL) with only a few posts and they at least work. I can query the database no problem outside of PHP with excellent performance. I did search around in these bug reports and wasn't able to solve my problem. Thank you. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21622&edit=1