Sentinel partitions limitations

  • 3926646
  • 06-Dec-2006
  • 26-Apr-2012

Environment

Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris

Situation

For Sentinel 5.x version with MSSQL Server database, is there a limit on how many partitions one should keep on line in the database?

Resolution

Yes, there is a limit of 125 partitions total per table. If you have more than 125 partitions total per table, Quick query and Drill Down will not be able to query all the past partitions online.