Microsoft SQL Server

By default, the XPhone Connect Server is operated with a local Microsoft SQL Server Express Server. The XPhone Connect Server installation offers this Microsoft SQL Express Server for installation. All Microsoft SQL Servers can be operated locally on the XPhone Server, or with remote connection.

Attention

From 500 XPhone Connect users (or from 250 when using hotline and direct calls), it is strongly recommended to use a Standard or Enterprise SQL Server Edition.

Released versions

Number of contacts in the XPhone Connect Directory

The table shows the approximate number of storable contacts in comparison between Express and Standard/Enterprise edition of the SQL server. For the Express edition, the maximum size of the index table is assumed to be about 10 GB.

Recommendation: Max. number of contacts per SQL database

Data source

SQL Server Express [1]

SQL Server Standard/Enterprise [2]

Simple ODBC contact database without relations

3 million

300000

CRM Contact (ODBC with few relations)

1 million

100000

Outlook private contacts

450000

45000

Outlook public contacts

250000

25000

Active Directory

500000

50000

Microsoft SQL Express

The following sections refer to the local Microsoft SQL Express Server.

Limitations

  • Database engine: 1 mainboard socket and max. 4 CPU cores.

  • Maximum 1 GB RAM data cache per instance (occupies about 2 GB RAM).

  • Maximum database size: 10 GB (data file size).

  • Maximum 50 instances per server.

  • Suitable for up to 500 users

  • Maximum contacts connected to the directory: approx. 250,000 - 3,000,000. However, this number serves only as a rough guideline and varies with the size of the actual contacts or the database type.

  • Die Begrenzung auf 1 GB Memory reduziert die Leistungsfähigkeit der Datenbank mit zunehmender Größe der Datenbank. Kompensiert werden kann dies durch möglichst schnelle Festplatten, z.B. durch SSDs. Ob die Leistungsfähigkeit der Datenbank ausreicht, hängt stark von der Anzahl der Benutzer und deren Suchverhalten und von der Größe der angeschlossenen Datenquellen ab. Unkritisch im Sinne der Datenbank ist die Anbindung der Datenquellen ETV und Telefonbuch Deutschland.

  • The SQL Express edition supplied is limited to the use of one physical CPU. Therefore, the cores necessary for the use of the directory must be available on a single physical CPU. If the Connect Server is used in a virtualized environment, this must also be configured so that the available cores are available in a single CPU from the perspective of the guest operating system.

Instances and databases

The functions of the XPhone Connect Server are divided into two instances of the Microsoft SQL Express Server and three data bases:

Function

Microsoft SQL Server instance

Data base

Server base functions

1

A

Telephony, chat

Fax

Voicemail

Journal

Instant messaging

Directory

B

Analytics

2

C

Hardware requirements

Here you can find the Hardware requirements for an XPhone server with locally installed Microsoft SQL Express Server <req-sql-xps-hw>.

Storage period

Call Journal

The storage period of the journal refers to the above-mentioned load profile and is based on the assumed size of the journal table of about 4 GB (40% of the available database size). Per record an average of 3 to 4.5 Kbytes should be estimated.

Storage period (days)

Number of users

90

300

60

450

The above table contains the recommended storage duration. It must be configured globally in the XPhone Connect Server.

Chat history

The storage period of the chat history refers to the above-mentioned load profile and is based on the assumed size of the journal table of about 4 GB (40% of the available database size). Per record an average of 3 to 4.5 Kbytes should be estimated.

Storage period (days)

Number of users

90

300

60

450

The above table contains the recommended storage duration. It must be configured globally in the XPhone Connect Server.

Analytics

The storage period of the Analytics data refers to the above-mentioned load profile and is based on an automatically generated database instance for Analytics (approx. 10 GB). Per record an average of 0.3 to 0.5 Kbytes should be estimated.

Storage duration (years)

Number of users

2

1000 (Hotline calls, without direct calls)

2,5

1000 (direct calls, without Hotline calls)

Microsoft SQL Standard/Enterprise

Hint

Here you can find the Hardware requirements for XPhone Connect Server and SQL Server on different machines.

Important

When using the customer’s own Microsoft SQL server instances, the responsibility for use and configuration lies with the respective database system administrator and not with the XPhone Connect software manufacturer C4B or the XPhone Connect partner.

Tip

See the Connection instructions for Microsoft SQL Server.

Have you found an mistake on this page?

Please send us a hint about this error by mail to doku@c4b.de. Thank you very much!