Severity 16

• n00bDBA

  SSCrazy

  Points: 2986

  More actions

  May 8, 2012 at 2:49 am

  #273733

  Hi all,

  I set up email alerts for Severitys 16-25 and ive been getting a lot of severity 16s.

  Ive got the following, But im finding it hard to get info on what these mean and there implications:

  DESCRIPTION:The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

  Is this a memeory issue??

  ------------------------------------

  DESCRIPTION:BackupIoRequest::ReportIoError: write failure on backup device '\\server\backups\db\file20120426073005.trn'. Operating system error 112(failed to retrieve text for this error. Reason: 15105).

  I backup to another servers storage and get this error semi requently im guessing this is the issue with backing up to another device and having posslbe packet lose (and curruption of the backup file) ???

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  May 8, 2012 at 8:01 am

  #1484522

  the second error is an out of space on the disk issue (run net helpmsg errorno from the command line to see what OS error codes mean)

  ---------------------------------------------------------------------

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  May 10, 2012 at 4:51 am

  #1485598

  First one, no, not a memory issue (although more CPU/RAM might get around it briefly, that'd just be papering over a large crack!)

  It means SQL can't produce a valid execution plan in time, due to the complexity of the query.

  As the message says, you'll need to simplify the query in question.

  Does the error identify the query(s)?

  Thanks