use master
go
dbcc freeproccache

public static void Main()
{
  using (var cnn = new SqlConnection(@"Data Source=.;Initial Catalog=master;Integrated Security=True"))
  {
    cnn.Open();
    using (var cmd = new SqlCommand("select object_id from sys.all_objects where name=@name", cnn))
    {
      var p = cmd.Parameters.Add("@name", SqlDbType.NVarChar, 128);
      p.Value = "sp_addrolemember";
      using (cmd.ExecuteReader()){ }
    }
    using (var cmd = new SqlCommand("select object_id from sys.all_objects where name=@name", cnn))
    {
      var p = cmd.Parameters.Add("@name", SqlDbType.NVarChar, 128);
      p.Value = "sp_droprolemember";
      using (cmd.ExecuteReader()) { }
    }
    using (var cmd = new SqlCommand("select object_id from sys.all_objects where name=@name", cnn))
    {
      var p = cmd.Parameters.Add("@name", SqlDbType.NVarChar, 128);
      p.Value = "sp_helplogins";
      using (cmd.ExecuteReader()) { }
    }
    using (var cmd = new SqlCommand("select object_id from sys.all_objects where name='sp_addsrvrolemember'", cnn))
    {
      using (cmd.ExecuteReader()) { }
    }
    using (var cmd = new SqlCommand("select object_id from sys.all_objects where name='sp_dropsrvrolemember'", cnn))
    {
      using (cmd.ExecuteReader()) { }
    }
  }
}

select
  ecp.refcounts,
  ecp.usecounts,
  ecp.cacheobjtype,
  ecp.objtype,
  st.[text]
from sys.dm_exec_cached_plans ecp 
cross apply sys.dm_exec_sql_text(ecp.plan_handle) st
where st.dbid=db_id()
select @@version;

refcounts   usecounts   cacheobjtype    objtype     text
----------- ----------- --------------- ----------- ----------------------------------------------------------------------------------
2           1           Compiled Plan   Adhoc       select ecp.refcounts, ecp.usecounts, ecp.cacheobjtype, ecp.objtype, st.[text] ....
2           1           Compiled Plan   Adhoc       select object_id from sys.all_objects where name='sp_dropsrvrolemember'
2           1           Compiled Plan   Adhoc       select object_id from sys.all_objects where name='sp_addsrvrolemember'
2           3           Compiled Plan   Prepared    (@name nvarchar(128))select object_id from sys.all_objects where name=@name

(4 row(s) affected)
-----------------------------------------------------------------------------------
Microsoft SQL Server 2014 (SP2-CU17-GDR) (KB4505419) - 12.0.5659.1 (X64) 
  May 24 2019 19:09:40 
  Copyright (c) Microsoft Corporation
  Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


(1 row(s) affected)

public static void Main()
{
  using (var cnn = new SqlConnection(@"Data Source=.;Initial Catalog=master;Integrated Security=True"))
  {
    cnn.Open();
    using (var cmd = new SqlCommand("SELECT [object_id] FROM [sys].[all_objects] WHERE [object_id]=@1", cnn))
    {
      var p = cmd.Parameters.Add("@1", SqlDbType.TinyInt);
      p.Value = 5;
      using (cmd.ExecuteReader()) { }
    }
    using (var cmd = new SqlCommand("SELECT [object_id] FROM [sys].[all_objects] WHERE [object_id]=@1", cnn))
    {
      var p = cmd.Parameters.Add("@1", SqlDbType.TinyInt);
      p.Value = 6;
      using (cmd.ExecuteReader()) { }
    }
    using (var cmd = new SqlCommand("SELECT [object_id] FROM [sys].[all_objects] WHERE [object_id]=@1", cnn))
    {
      var p = cmd.Parameters.Add("@1", SqlDbType.TinyInt);
      p.Value = 7;
      using (cmd.ExecuteReader()) { }
    }
    using (var cmd = new SqlCommand("select object_id from sys.all_objects where object_id=8", cnn))
    {
      using (cmd.ExecuteReader()) { }
    }
    using (var cmd = new SqlCommand("select object_id from sys.all_objects where object_id=9", cnn))
    {
      using (cmd.ExecuteReader()) { }
    }
  }
}

select
  ecp.refcounts,
  ecp.usecounts,
  ecp.cacheobjtype,
  ecp.objtype,
  st.[text]
from sys.dm_exec_cached_plans ecp 
cross apply sys.dm_exec_sql_text(ecp.plan_handle) st
where st.dbid=db_id()

refcounts   usecounts   cacheobjtype    objtype     text
----------- ----------- --------------- ----------- ---------------------------------------------------------------------------------
2           2           Compiled Plan   Adhoc       select ecp.refcounts, ecp.usecounts, ecp.cacheobjtype, ecp.objtype, st.[text] ...
2           1           Compiled Plan   Adhoc       select object_id from sys.all_objects where object_id=9
2           1           Compiled Plan   Adhoc       select object_id from sys.all_objects where object_id=8
4           2           Compiled Plan   Prepared    (@1 tinyint)SELECT [object_id] FROM [sys].[all_objects] WHERE [object_id]=@1
2           3           Compiled Plan   Prepared    (@1 tinyint)SELECT [object_id] FROM [sys].[all_objects] WHERE [object_id]=@1

(5 row(s) affected)