Why am I receiving the following MSSQLServer event in the application log of the Operations Manager (NETIQKB1887)

  • 7701887
  • 02-Feb-2007
  • 17-Apr-2008

Resolution

fact
Operations Manager 3.30

symptom
What is the following MSSQLServer event in the application log of the Operations Manager database server?

event id 17052

Description:

Error: 50000, Severity: 0, State: 1
OnePoint Free Data Space Percentage.



cause
These are informational events that are the result of a stored procedure that runs against the OnePoint database to collect performance data related to the amount of freespace in the database.

fix
These events can be disabled by following the steps below:

  1. Open SQL Enterprise Manager
  2. Drill down to the Onepoint database
  3. Open Stored Procedures.
  4. Find the sp_OnePointFreeSpace stored procedure.
  5. Open this stored procedure and find the following text:
  6. --IF ( (@DBFreeSpaceinMB - @LogFreeSpaceinMB) / (@DBSpaceinMB - @LogSpaceinMB) * 100 ) <= 40
    --BEGIN
    SET @Results = 'OnePoint Free Data Space Percentage: ' + convert(char(20), (@DBFreeSpaceinMB - @LogFreeSpaceinMB) / (@DBSpaceinMB - @LogSpaceinMB) * 100)
    RAISERROR(@Results, 0, 1) WITH LOG
    --END
    RETURN

  7. Remove the '--' from the front of the lines beginning with IF, BEGIN & END.
  8. Select OK.

You will no longer receive an event unless the DB free space is less than or equal to 40%.



Additional Information

Formerly known as NETIQKB1887