Details of the components of the SQL Database Server

Name Version Comments
Operating System

Windows 2022 - 64 bit

Windows 2016 - 64 bit

Windows 2019 - 64 bit

Standard or Enterprise

Datacenter or Standard

Datacenter or Standard

Standard

Standard

SQL Server

SQL 2014 Enterprise or Standard SP1 - 64 bit

SQL 2014 Enterprise or Standard SP2 - 64 bit

SQL 2014 Enterprise or Standard SP3 - 64 bit

Note: You can restore IRC database from the Enterprise edition of the SQL server to the Standard edition. Refer to Restoring database from Enterprise edition of the SQL server to the Standard edition section for details.

The following features need to be installed:

Instance Features

  • Database Engine Services
    • Full Text and Semantic Extractions for Search [2014]
    • Full Text and Semantic Extractions for Search [2012]
    • Full Text Search [2008 R2]
  • Reporting Services – Required for Reporting Server

Shared Features

  • Business Intelligence Development Studio [2008 R2]
  • Client Tools Connectivity
  • Client Tools Backward Compatibility
  • Client Tools SDK
  • Documentation Components
  • Management Tools - Basic
    • Management Tools – Complete
  • SQL Client Connectivity SDK

Collation

Collation set to the default value at install: ‘Dictionary order, case-insensitive, for use with 1252 character Set’, which equals the ‘SQL_Latin1_General_CP1_CI_AS’

Mode

  • Native Mode / Compatibility Level (level 120)[2014]
  • Native Mode / Compatibility Level (level 110) [2012]
  • Native Mode / Compatibility Level (level 100) [2008 R2]

Size

  • The recommended initial size for CoreDB database is –
    • IRC Database data file (mdf): 20GB
    • IRC Database log file (ldf) : 2GB. ldf, 10% auto growth and recovery model as simple
    Note: The IRC Database size is set by default during IRC activation.

tempdb

  • Minimum requirement for SQL tempdb: 8 GB
  • Minimum Requirement for ldf: 2GB. ldf, 25% auto growth for data file and 20% for log files with recovery model as simple.
SQL Server

SQL 2016 SP1/SP2 Standard or Enterprise Edition 64-bit

Note: For Clustered support, you must use the SQL 2016 SP1 Enterprise Edition 64 bit.

The following features need to be installed:

Instance Features

  • Database Engine Services
    • Full Text and Semantic Extractions for Search
  • Reporting Services Native– Required for Reporting Server

Shared Features

Collation

Collation set to the default value at install:‘Dictionary order, case-insensitive, for usewith 1252 character Set’, which equals the‘SQL_Latin1_General_CP1_CI_AS’

Mode

  • Native Mode / Compatibility Level for SQL Server 2017 is 140
  • Native Mode / Compatibility Level for SQL Server 2019 is 150

Size

  • The recommended initial size for CoreDBdatabase is –
    • IRC Database data file (mdf): 20GB
    • IRC Database log file (ldf) : 2GB. ldf,10% auto growth and recovery model as simple
      Note: The IRC Database size is set by default during IRC activation.

tempdb

  • Minimum requirement for SQL tempdb:8 GB
  • Minimum Requirement for ldf: 2GB. ldf,25% auto growth for data file and 20%for log files with recovery model as simple
SQL Server
  • SQL 2017 CU20 Standard or Enterprise Edition - 64 bit
  • SQL 2019 CU4 Standard or Enterprise Edition - 64 bit

The following features need to be installed:

Instance Features

  • Database Engine Services
    • Full Text and Semantic Extractions for Search
  • Reporting Services Native
    Note: A separate reporting services installer is available for SQL 2017 and 2019.

Shared Features

Collation

Collation set to the default value at install:‘Dictionary order, case-insensitive, for usewith 1252 character Set’, which equals the‘SQL_Latin1_General_CP1_CI_AS’

Mode

  • Native Mode / Compatibility Level (level130)

Size

  • The recommended initial size for CoreDBdatabase is –
    • IRC Database data file (mdf): 20GB
    • IRC Database log file (ldf) : 2GB. ldf,10% auto growth and recovery model as simple
      Note: The IRC Database size is set by default during IRC activation.

tempdb

  • Minimum requirement for SQL tempdb:8 GB
  • Minimum Requirement for ldf: 2GB. ldf,25% auto growth for data file and 20%for log files with recovery model as simple
SQL Server

SQL 2022 Enterprise or Standard SP1 - 64 bit.

Note:  When installing IRC application on an environment that already has SQL 2022 installed, you must run the Enable SQL 2022 Support utility. See, https://inforsaas.service-now.com/now/cwf/agent/record/u_kb_template_product_knowledge/04c72579936bc650c2eeb9084dba1050

The following features need to be installed:

Instance Features

  • Database Engine Services
    • Full Text and Semantic Extractions for Search
  • Reporting Services
    Note: A separate reporting services installer is available for SQL 2022.

Shared Features

  • Microsoft SQL Server Management Studio must be deployed. For details, see https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
    Note: This feature is recommended to help the IRC administrators configure and administer components within the IRC database server. However, even without deploying the Microsoft SQL Server Management Studio in the IRC database server, IRC will continue to work.
  • Size

    The recommended initial size for CoreDB database is:

    • IRC Database data file (mdf): 20GB
    • IRC Database log file (ldf) : 2GB. ldf,10% auto growth and recovery model as simple.
      Note: The IRC Database size is set by default during IRC activation.
  • tempdb
    • Minimum requirement for SQL tempdb:8 GB
    • Minimum Requirement for ldf: 2GB. ldf,25% auto growth for data file and 20%for log files with recovery model as simple