A web application using sql server 2005 having the following problem :

The CPU utilization goes through the roof and the SQL 2005 server stops accepting transaction requests. The database is rather small. The table with the most transactions (insert/updates) has about 115,000 rows. The concurrent users to the website are about 600 users. And the transactions are about 10 – 15 per second. The HP server has four processors and 4GB of memory. Right now we have allocated 2GC fro SQL and have been trying to up its allocated memory unsuccessfully.


The only thing ‘new’ in the event log is:

Source: DCOM

Event ID: 10016

User: NT AUTHORITY\NETWORK SERVICE

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool


Any help is appreciated.

Thanks,
Sergio