Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Performance with SQL Server in another server
sp_NewPost Add Reply sp_NewTopic Add Topic
July 23, 2018
5:21 am

Clear now, thanks!

July 21, 2018
4:19 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

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


Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502