Sentinel partitions limitations

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


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


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?


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.