Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Log & Event Manager (LEM) > MSSQL Auditor frequently crashes

MSSQL Auditor frequently crashes

Updated January 17, 2017

Overview

There may be instances where you notice that the MSSQL Auditor is crashing randomly and you get a message similar to below:

An unhandled exception ('System.NullReferenceException') occurred in MSSQLAuditor.exe [6072].

 

Environment

  • All LEM versions
  • MSSQL Server
  • MSSQL Auditor
  • SQL Profiler

Cause 

Likely reasons are:

  • MSSQL Server is taking up all the memory allocated to the machine.
  • There is not enough memory for SQL and the Operating System.

Resolution

Take necessary steps to either increase your RAM or limit how much RAM MSSQL server is allowed to use.

 

Last modified

Tags

Classifications

Public