Limpiar el Cache en Reporting Services

Encontré esta información sobre cómo limpiar el caché en SQL Server Reporting Services.

You can find information about scripting here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rs_v1_5fxe.asp

You should also look at this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_3249.asp

The flush cache method is here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_22i9.asp

You script will look something like this (not sure this is 100% correct)

Public Sub Main()
    Dim items() As CatalogItem
    items = rs.ListChildren("/", True)

    Dim type as ItemTypeEnum
    Dim item As CatalogItem
    For Each item In items
type = rs.GetItemType(item)
if (type == ItemTypeEnum.Report || type == ItemTypeEnum.LinkedReport)
         rs.FlushCache(item)
    Next item
End Sub

I think I mixed in C# and VB.Net, but hopefully you can get the idea.

 

Saludos,

Eduardo Castro

Comunidad Windows Costa Rica http://mswindowscr.org

Comments

Popular posts from this blog

Cómo identificar consultas más pesadas en SQL Server

Power View en SQL Server 2012 Primer Entrega

Machine Learning Services con SQL Server Managed Instance