100% cpu usage

    Date: 03/30/05 (SQL Server)    Keywords: sql, web

    My sql server is driving me crazy. It's pegging out at 100% CPU for almost anything. dropping tables, truncating tables. It will be at 0% CPU, I'll attempt to drop a table and it will sit at 100% until I cancel the request. Some of my webpages are timing out. Anyone have any idea where to start? Event viewer doesnt give much info.

    I'm running sql server 2000 sp3 on win2k3 sp1.

    Source: http://www.livejournal.com/community/sqlserver/22992.html

« Noob. || fileslistonly vs.... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home