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

Permitiendo la administración de los jobs a usuarios que no son System Administrators en SQL Server Agent 2005 o superior

FileTable en SQL Server 2012