This topic discusses hardware and software requirements for Logi Ad Hoc v11. Topics include:
- General Requirements
- How Should Your Server Be Configured?
- How Many Servers Do You Need?
- Server Virtualization
- Product Expiration Information
IMPORTANT: Do not upgrade to JDK 8 release build 261 (1.8.0_261), or any later build of JDK 8. Doing so affects Logi Info and Logi Ad Hoc running the Java engine. If you perform this upgrade, your web server will stop responding indefinitely the first time it has to process a web request. This issue affects both Oracle JDK 8 and OpenJDK 8. This note will be updated when we have found a resolution.
Here are the general requirements for Logi Ad Hoc v11:
- Internet Explorer: 7, 8, 9, 10, 11 (Certified); see note below about earlier versions.
- 1 GHz or higher processor recommended; 400 MHz minimum required.
- Windows Server 2012 R2, 2008, 2003
- 32-bit and 64-bit Windows OS supported
- Microsoft Internet Information Server (IIS)
Logi Ad Hoc v11 builds a metadata repository which can be created on any of the following database servers. All are available for .NET, only those with an asterisk (*) are also available for Java:
- Microsoft SQL Server CE (installed automatically during Logi Ad Hoc v11 installation)
The following components must be installed:
- Microsoft .NET 2.0, 3.x, or 4.x Framework (.NET 4.x required for v11+), or
Logi Ad Hoc v11 can retrieve data for reporting from any of the following database servers. All are available for .NET, only those with an asterisk (*) are also available for Java:
Microsoft Internet Information Server (IIS) must be installed before installing Logi products. The installation program for Logi reporting tools will, if it doesn't find it, install the .NET 2.0 Framework automatically. There is no need to upgrade to .NET 3.x in order to use Logi products.
Browser updates are being released so rapidly that it's impossible for us to guarantee that all versions will work on a day-to-day basis, or that a new browser release won't be incompatible with an older version of Logi Ad Hoc v11.
Internet Explorer 10 is only supported in v11+.
In a typical scenario with an average data size per report (less 10MB of data per report), you should be able serve 50-100 concurrent users per multi-core CPU on a production server, assuming a good amount of RAM (2GB+) and a fast hard drive (12K RPM+). Here are three representative configuration levels for the web server.
- A low-performance hardware configuration: 1 multi-core CPU, 1-2GB RAM, 12K RPM HD, 32-bit OS
- A better performance configuration (for more users or more data): Quad-Core CPU, 2-4GB+ RAM, 15K RPM HD, 32-bit OS
- The best performance configuration begins with the previous configuration and adds: Additional CPUs (2 or more Quad-Core CPUs), more RAM (8GB+), 64-bit OS, or move to a clustered environment.
Here are a few general "rules of thumb" when considering server configuration options:
- More Data and Data Complexity = More RAM
- More Reports, Larger Reports, Complex Reports = Faster hard disk, more available hard disk space
- More Traffic and Concurrent Visitors = More CPUs/Cores
Your production web server hosts your Logi applications, which run as extensions to the web server. Ideally, this computer should be dedicated to this task alone.
However, other configurations are possible and feasible, including those in which the web server also serves other functions (i.e. is not dedicated to reporting alone) or the database server is also on the reporting server computer.
Which configuration should you use? We do not have guidelines based on specific numbers of users or reports to share with you; each deployment situation is different.
Whether you choose to combine functions (web server, Logi Ad Hoc v11 instance, and database servers) on one computer is, ultimately, your decision. Numerous factors can affect this decision, including the amount of web server traffic, the number of concurrent database users, the size of the databases, the complexity of the database queries, the frequency of report access, and, not least, cost.
You may care to begin with a combined configuration and, as your report usage grows, change to a dedicated configuration. The nature of Logi products allows you to do this easily and often without additional cost (if per-server CPU counts remain constant).
Recent studies concerning server virtualization suggest that database servers are frequently under-utilized. On the other hand, many database vendors recommend that their products be run on a dedicated server. You may wish to check with your database vendor for their recommendations concerning database servers.
Many organizations are using server virtualization to maximize hardware usage and reduce costs. Server virtualization products allow the assignment of CPU resources to processes. This may take the form of a maximum percentage of combined CPU utilization, or as specific allocation of logical CPUs, to a virtual machine (VM). The server administrator is responsible for making these configuration decisions. Logi Analytics product licenses treat a VM just like a regular, non-virtualized server. In order to ensure good performance in any virtualized server environment, administrators must be careful to allocate appropriate resources to VMs. It's not uncommon to relocate a VM from one hardware platform to another, for example, for hardware maintenance. The Logi license will "move" with the VM, as long as the machine name remains unchanged.
Information about Logi products and versions that have reached the end of their life cycle can be found in Product Lifecycle Expiration.