CPu high

• bala2

  SSCertifiable

  Points: 5547

  More actions

  November 19, 2013 at 5:25 am

  #300282

  Hi,

  User was getting error saying that database locked out.and when i logged into server i could see

  Sql is taking high CPU and i found that one of the SP is taking CPU.after killing the SPid ,cpu came to normal.

  But i found some errors on the application log .

  1)

  The description for Event ID ( 17052 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Severity: 16 Error:258, OS: 258 [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Timeout error [258]. .

  2).

  Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

  Please help me to trouble shoot...