Cinegy System

Reading time ~6 minutes

Cinegy software provides various components such as servers and clients. Depending on which tasks have been delegated to each component, the system recommendations will vary.

This article provides an overview of the principal system components needed and their corresponding recommendations.

The diagram shows a possible Cinegy workflow network infrastructure:

The Cinegy workflow environment is made up of the following components:

A typical Microsoft Windows network. Servers and workstations participate either in Active Directory or in the legacy domain (the so-called "Windows NT domain").

Caution
The legacy Windows NT domain must support WINS and/or DDNS.
Gigabit LAN connection is necessary to provide the performance needed for all the appointed servers. The only necessary network protocol is TCP/IP. Coupling that protocol with other network protocols (like NetBEUI or IPX/SPX) is not recommended.
Microsoft SQL Server installation. It is possible to use a single server installation, but it is recommended to use separate server machines for larger network installations.
A file server with a domain controller, WINS/DDNS server or DHCP server. The file server must provide its resources over the SMB-TCP (SMB = Server Message Block; the so-called "Microsoft Network protocol").

SQL Server

The performance of the SQL Server database is determined by the processor performance. As the total number of users and/or the size of the database itself grows, the amount of installed RAM and the speed of the disk I/O system and how it is configured become increasingly important.

Note	Cinegy Archive requires one of the following SQL Server versions: SQL Server 2008 SP3, SQL Server 2008 R2 SP1, SQL Server 2012, SQL Server 2014. The use of SQL Server 2016 is permitted, but not recommended due to limited testing and support.

Caution

SQL Server Express can be used only with the Advanced Services installed; the other SQL Server versions must have the full-text service installed.

Caution

With very large databases and a lot of users it becomes crucial that neither processor memory nor disk I/O become a bottleneck; otherwise, it will cause the entire system to slow down.

Important

Study thoroughly all the Microsoft recommendations on the SQL Server installation and performance.

Note	It is recommended to use a dedicated SQL Server for the Cinegy software exclusively. Running other databases on the same server can affect the performance in an unpredictable way.

Note	Cinegy clients need access to the SQL Server and databases, so it has to be accessible via TCP/IP. Default port 1433 must be opened in Windows Firewall.

SQL Server Hardware

SQL Server Performance

The following table gives an indication of what processing power is required in relation to the number of concurrent users on the Cinegy Archive SQL Server.

Processor RAM	Number of users
Core 2 Duo E8400 4GB	1-25
Xeon X3430 8GB	25-75
Dual Xeon E5620 16GB	up to 250
Xeon E5-2670 32GB	up to 350

Processor RAM

Number of users

Core 2 Duo E8400 4GB

1-25

Xeon X3430 8GB

25-75

Dual Xeon E5620 16GB

up to 250

Xeon E5-2670 32GB

up to 350

Test machines used SQL Server 2008 R2 SP1 on Windows Server 2008 R2

The number of users given in this table is estimated based on assumption that Cinegy Desktop client performs a range of tasks: search, browse, edit, logging, etc. If it is clear from the beginning that there will be a very large amount of searching with complex search queries, then the performance required will be much higher.

Cinegy Workspace users create less load on the database server than an average Cinegy Desktop user. Search queries from web users are serialized – queued – so, in the worst case, they have to wait. This is not the case with the Cinegy Desktop search requests. Cinegy installations with more than 200 users have been deployed and are in use with even lower performance hardware than recommended in the table above. To be able to run the Cinegy system successfully and without performance issues, the rights and roles management of the Cinegy Archive database can be used to determine which user can do what. By limiting rights to powerful features available in the system, administrators can help limit possible performance bottlenecks.

Important

The rights management issue is covered in the Cinegy Archive Manager Manual.

Disk I/O

Caution

It is always important to adhere to the Microsoft best practices and guidance for SQL Server installations (available for free from the Microsoft website).

This is not as important with small installations, but when building systems for more than 30 users, choosing the right disk layout can give a considerable boost of performance at a very little extra cost. For example, using different disks for temp files, log files, the database itself and so forth will improve overall throughput by allowing the system to separate these tasks to dedicated disks. When building an I/O subsystem for a database, one should also remember that the read/write performance is often secondary to the number of I/Os the subsystem can perform per second. The data that is written to a database in general does not exceed 8k per write; so formatting a volume with a 64k block size for use with a database is counterproductive.

Clustering

All larger, mission critical Cinegy Archive SQL Server database server installations will choose the option to use the standard Microsoft clustering feature of Windows Server Enterprise (this is not available using Windows Server Standard or Small Business Server).

A cluster typically consists of two machines that form one new virtual machine. One of the cluster machines will be active and the other will be passive standing by in case of an emergency. If the active machine were to fail, the passive machine would take over and become the new active machine. The signaling of the state of the machines is done by a dedicated Ethernet "heartbeat" cable that connects the two machines.

This shared storage, the Quorum disk, is usually a RAID5 system that has two SCSI or FibreChannel adapters allowing both machines to be connected at the same time. An important issue to remember when building a cluster is that all components need to be cluster-capable. This is especially important for storage adapters and for the storage subsystem itself. Every major server vendor can provide a list of clustering-capable hardware they sell.

Caution

When clustering two systems, the amount of usable RAM is half of what the machine would have compared with running as a stand-alone machine. Therefore, in order to have a system with 16GB of usable RAM in a two machine cluster configuration, 32GB of RAM is recommended in both cluster machines.

SQL Server Native Client

SQL Server Native Client is a data access library introduced in SQL Server 2005. Database mirroring is a primarily software solution to increase database availability and data redundancy. SQL Server Native Client provides implicit support for database mirroring. In addition to exposing features of Windows Data Access Components (Windows DAC), SQL Server Native Client also implements such features as database mirroring, Multiple Active Result Sets (MARS), query notifications, snapshot isolation, and XML data type support.

Important

Refer to the Microsoft SQL Server documentation for more information about the new features supported by SQL Server Native Client.

Important

For more information, please read the following article or visit the Microsoft SQL Server website.

Cinegy Archive Video Server

The Cinegy Archive video server has to support the streaming request of all users and accommodate for all the qualities in use. The most important recommendations are high performance network adapter and connection (1GB LAN or a fiber channel connection). A good quality RAID system should be installed to provide fast access to the data. The disk recommendations really depend on your own individual needs and you must calculate this generously, considering the number of users and the streaming qualities you are planning to use.