Memory Dumps and many plans for one query in SQL Server

• info.sqldbamail

  SSCommitted

  Points: 1741

  More actions

  April 28, 2016 at 1:04 am

  #307048

  I had run Sp_blitz script in SQL Server on production and it is showing reliability issue

  1) Memory Dumps Have Occurred : That ain't good. I've had 70 memory dumps between Jul 25 2015 1:31AM and Apr 23 2016 5:31AM!

  2) Performance issue: Many Plans for One Query : 188 plans are present for a single query in the plan cache - meaning we probably have parameterization issues.

  How to identify and solve this any pointers for this solution is appreciated in advance.

  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  Save a tree... Please don't waste paper unless you really need to!

  When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'