Support forum

Home Support forum Using Diafaan SMS Server Performance with SQL Server in anot…

Performance with SQL Server in another server

Add Reply

Add Topic

July 23, 2018
5:21 am

Udo

Guest

Guests

Quote

Clear now, thanks!
Udo

July 21, 2018
4:19 pm

Henk Helmantel

Admin

Forum Posts: 1488

Member Since:
May 28, 2013

Offline

Quote

Hello Udo,

a) When you have a lot of SMPP binds and a high message traffic then the performance of the server where Diafaan SMS Server runs is the most important, specifically the performance of the hard disk. The performance of the server that is running SQL Server (Express) is not important for the performance of Diafaan SMS Server but it is important that the network connection between Diafaan SMS Server and MS SQL Server is fast and reliable, preferably within the same LAN network.

b) Yes, but only if the '...RetryOnError' properties in the advanced settings of the SQL Connector are set to 'True' (default is 'False') and the SQL Connector is not stopped or restarted while the database is offline.

c) I can't give you any specific requirements. For Diafaan SMS Server a fast (SSD) hard disk helps performance very much, memory and CPU is less important. The specifications for the SQL Server is not very important but the connection between Diafaan SMS Server and the database server should reliable and fast.

Regards, Henk

July 19, 2018
5:56 pm

Udo

Guest

Guests

Quote

Hello Henk,

In our tests with Diafaan we are logging the message log into SQL Server Express. Working ok with both on the same machine running on a SSD. No customer is using the SQL connector.
For maintenance reasons I would like to run the SQL Server on a separate server and have a few questions:
a) Who requires the HD performance when we have high volume SMPP binds? Diafaan, SQL Server or both?
b) If the SQL Server is shut down for maintenance/backup overnight, when traffic is small, will Diafaan store the messages and update the SQL DB when it is back online?
c) What is required when we have 30-40 MPS and run SQL and Diafaan on separate machines:
i) Connectivity: Gigabit?
ii) HD for Diafaan: Enterprise disk SATA vs enterprise disk SAS vs good SSD?
iii) HD for SQL: Enterprise disk SATA vs enterprise disk SAS vs good SSD?
iv) Memory required?
v) CPU required?
I need general guidelines, nothing so precise.

Thanks for the help

Udo

Add Reply

Add Topic

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)