32-bit vs. 64-bit
StudyTRAX is completely compatible with 64-bit operating systems, however you must specify that the application pool run in 32-bit mode. This is due to some 3rd party libraries used by StudyTRAX and should be addressed in future versions to allow full blown 64-bit access.
Software Requirements
- Windows Server 2008 R2 or Windows Server 2012
- 64-bit OS is supported
- IIS 7.0 (add Server Role )
- ASP.NET Runtime v4.61 (Determine if version 4.5 installed)
- MS SQL Server 2008 or 2012 (Web edition or better).
Hardware Requirements
It is common that the database and web server co-exist on the same server However, there are reasons why it is preferable to have the database on a separate server, such as when the database is on a shared environment. Thus, both requirements are listed.
Web Server
- RAM: 4 GB
- CPU: 1.6+ GHZ
- Hard Drive: 250 MB
Web Server + Database Server
- RAM: 4 GB
- CPU: 1.6+ GHZ (Dual Core)
Database Size
The initial size for the database should be large enough so it should never or very rarely need to grow. An initial size of 1 to 4 GB should be enough for most installations. Make sure autogrowth is enabled on the database and the autogrowth size is specified as a size (e.g. 500MB) and not as a percentage.
If a more specific size is required, the following formula may be used as a guide.
Database Size Formula:
((# of Projects * # of Subjects * # of Intervals * # of Variables * 100)
+ (# of Projects * # of Subjects * # of Project Variables * 100)) * 1.1