Project server 2007 and SQL

D

Dots

I installed the latest Sharepoint and WSS hotfixes (just released) this past
weekend and am now seeing my SQL server hit 85-100% CPU usage. My SQL admins
are telling me that the ProjectServer_Published is the most hit database and
that stored procedure MSP_WEB_SP_SEC_CheckSPGlobalPermission accounts for 82%
of all calls to this database. Any ideas what is happening here? We did
not experieince this prior to installing these new hotfixes.

HELP!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top