Execution plan size and MTL space

• Andy B.

  SSC Eights!

  Points: 890

  More actions

  November 1, 2006 at 12:37 pm

  #115249

  Is there a way in SQL 2000 to figure out the size of an execution plan for a query/stored procedure? I'm curious to know whether an execution plan is being stored in BPool (<8KB) or MTL (>8KB).

  Thanks in advance.

  
  Enjoy!
  
  A Brown
  
  Manage all of your backups in one simple job using this script.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 1, 2006 at 3:40 pm

  #669367

  I prefer BPool because we can flush out the buffer by using DBCC command.