Statistics for SQL Server 2008

[Former Member]

Hello experts,

We have a BW system installed with SQL Server 2008, could you please let us know how can we schedule the statistics of the DB?

Thanks and best regards,

[Former Member]

Hi,

Please check the s-note: 849062 - Optimizer statistics for InfoCubes in BW.

Regards,

Sitarama.

[Former Member]

Thanks for the recommendation Sita Rr, we have checked it and we will take the note in consideration for the small tables of infocubes.

Best regards,

Rodolfo

[Former Member]

Hi,

MS SQL takes care of statistics, one does not need to update it manually unless and until SAP suggests.

Regards,

SBK

[Former Member]

Hi,

there might be situations where update statistics is necessary: [link|http://blogs.msdn.com/b/saponsqlserver/archive/2010/11/19/sap-bw-on-sql-server-is-auto-update-create-statistics-always-sufficient.aspx]

Regards,

Sven

[Former Member]

Thanks for the information folks, I will review the documentation suggested.

Kind regards,

[Former Member]

have a look at technet.microsoft.com/en-us/library/dd535534%28SQL.100%29.aspx