Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only