[轉][Dapper]參數化查詢慢

來源:互聯網
上載者:User

標籤:roc   cache   https   log   tar   creat   div   nbsp   DApp   

 參考:https://www.cnblogs.com/wy123/p/7190785.html參考:https://www.cnblogs.com/Irving/p/3951220.html
if object_id(‘tempdb..#t_remove_expired_plan‘) is not null    drop table #t_remove_expired_planGOcreate table #t_remove_expired_plan(    id int identity(1,1),    plan_handle varbinary(500))GOinsert into #t_remove_expired_plan (plan_handle) select  qs.plan_handlefrom sys.dm_exec_query_stats qs where creation_time< dateadd(hh,-24,getdate())GOdeclare @exists_data bit = 1declare @v_plan_handle varbinary(500)declare @str_sql varchar(1000)while @exists_data = 1begin    select top 1 @v_plan_handle = plan_handle from #t_remove_expired_plan    if(@v_plan_handle is not null)    begin        execute sp_executesql N‘DBCC FREEPROCCACHE(@plan_handle)‘ ,N‘@plan_handle varbinary(500)‘,@plan_handle = @v_plan_handle    end    delete top (1) from #t_remove_expired_plan    if exists(select 1 from #t_remove_expired_plan)    begin        set @exists_data = 1    end    else     begin        set @exists_data = 0    endend

 參考:https://www.cnblogs.com/quanweiru/p/5577421.html

[轉][Dapper]參數化查詢慢

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.