#21622 [NEW]: MSSQL: 100% CPU usage on database queries and eventually timeout

From: admin@bozobits.com Operating system: Win2K PHP version: 4.3.0 PHP Bug Type: Performance problem Bug description: MSSQL: 100% CPU usage on database queries and eventually timeout 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 bug report at http://bugs.php.net/?id=21622&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21622&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21622&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21622&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21622&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21622&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=21622&r=support Expected behavior: http://bugs.php.net/fix.php?id=21622&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=21622&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=21622&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21622&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21622&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21622&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21622&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=21622&r=gnused