SQL Server Performance

Difference between Reconnect and Reflesh buttons

Discussion in 'SQL Server 2005 Analysis Services' started by hernan93, Jun 18, 2007.

  1. hernan93 Member

    Hello people,

    In Analysis Services 2005's cube browser, there are two buttons "Refconnect" and "Refresh", which is the difference between them?? When should I use each one?

    Thanks in advance.

    Hernán.
  2. satya Moderator

    http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc fyi.

    BOL

    For client applications connected to an instance of Microsoft SQL Server 2005 Analysis Services (SSAS), this statement causes the memory cached on the client application to be synchronized with the server. While this will ordinarily be detected and updated automatically, the length of time before this happens depends on the client connection string settings. The REFRESH CUBE statement refreshes data immediately.

    For client applications connected to a local cube, the REFRESH CUBE statement causes the local cube file to be rebuilt.


    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page