Home Forums SQL Server 2008 SQL Server 2008 Administration Plan Cache - Adhoc - Usecounts 1 RE: Plan Cache - Adhoc - Usecounts 1

  • October 26, 2012 at 11:30 am

    #1553321

    TheSQLGuru (10/26/2012)

    sys.dm_exec_query_plan ( plan_handle ) has a dbid field.

    That column shows null for adhoc and prepared statements

    Guess I'll have to do some serious digging..

    Thanks