dbacockpit "A table has more than 900 partitions"

[Former Member]

Hello,

We have upgraded Solman from 7.0 sp15 to ehp1 sp26 and made basic configurations.

after this we noticed additional tab (alert) in dbacockpit in performance overview.

there is one alert: "1 SQL Server setup checks failed 1 red alerts 0 yellow alerts".

double click on this alert opens SQL Server setup checks where is the alarm:

"A table has more than 900 partitions".

Also we noticed that value of "Latch Wait Time per Request (ms)" differs from value what we see in another systems (we use one mssql 2005 server for several systems).

[markus_doehr2]

> there is one alert: "1 SQL Server setup checks failed 1 red alerts 0 yellow alerts".

> double click on this alert opens SQL Server setup checks where is the alarm:

> "A table has more than 900 partitions".

You have to compress the cube:

Note 869407 - Partitioning on Microsoft SQL Server

Markus