RMS Slow Down

I would check the database size, I experianced the same problem and noticed that my database size was massive 40+ GIGS. There is sql code that will clear transactions before a specific date.

What type of Firewall are you using? Especially on the server? You will probably want to open port 1433 on the firewall on both the POS station and the server. Check with your IT to make sure it will not cause security problems. I've found that McAfee, Norton, etc really slow things down, but opening port 1433 (the SQL port) works, even though it might say SQL Server, or RMS Admin, etc is "Allowed"..

"keith6566" wrote:

IMO, port 1433 is the port used by SQLServer database, so it has to be open unless you ask your database administrator to change the default port used by SQLserver

SQLServer is the RMS database server

Have you tried the reindex function At RMS?

May be the RMS database has grown so large

rgds, Joie

Hi Joie! Thanks for your reply, I am having an other problem in connecting database on trail of Web integrator. when I install Web integrator it gives me an error connection failed. I verify my network connectivity and the port 1433 is not blocked by any firewall.

You are right that IMO, port 1433 is the port used by SQLServer database, but as per New West Technologies Support team, it cannot connect to the SQL database as the server is blocking access on port 1433 which his application uses to connect and communicate with SQL server & we need to get the port opened up on the server. As per my opinion, this is a significant risk to have 1433 ports open to the internet, because it this time we are working from an other PC through network connectoin to the SQL server & its work fine. Due to this reason I am not agree to open the port 1433 to internet. Please help us, if you have any other solution.

Here's what I understand about the web application architecture, may be applicable to your RMS

1. At front tier typically we have web / HTTP server where the static/dynamic pages are stored. This HTTP server will reside on the boundary between corporate network an the internet (outside world) Users use port 80HTTP or 443 SSL to connect to this web server
2. At mid tier is where the application server (possibly RMS) or the business logics are stored. They are located within corporate network E.g. Application servers are Apache, Microsoft IIS etc HTTP servers talk to application servers via the application server port number (varies among the product)3. At the last tier is where the databases are. They are located deep within corporate network and protected by firewall devices.Application servers talk to the database via database port 1433 for SQL server and different port number for Oracle So i think port 1433 should not be opened to internet. If it is opened for some reason (e.g. remote access to database server) it has to have to be protected by firewall access control list

So when you cannot have access to certain port may be:

1. port is not open
2. you may be connecting from different network segment separated by router/firewall devices and their access control list do not allow such connection

Here's what i can think of possible cause of RMS slow down

1. Database size is huge ? If the transaction table is huge, may be need to take some of the data offline or reindex ?
2. Many table triggers on RMS tables due to customization ?
3. Memory leak on the database ?(probably need a patch)

Rgds, Joie

Once again thanks for your opinion. As per your opinion that port 1433 should not be opened to internet. If it is opened for some reason (e.g. remote access to database server) it has to have to be protected by firewall access control list. If we not open it, is there any way to conect web integrator with SQL. please help me. Thanks Akbar

"Joie" wrote:

I am not sure what is web integrator but anyway to talk to the SQL server, an application must connect to the port where SQL server is listening to. And the port has to be opened /available

The default is 1433

At the SQL server machine, run netstat to see what are the ports that are open and listening. Or was the SQL server was configured to listen to different port ?

I dont have an SQLserver with me at the moment, but you (or the database administrator) can configure such that the SQL server is listening to different port number say 1456 using its SQL Network client utility.

So are you trying to connect to your client's SQL database server via remote access from your office ? try to "telnet" to the port to see whether you can connect

Is your user id / pasword correct ? Does it have permission to connect to the database ?

Hi Joie ! I open the Port 1433 through SQL Sever Configuration Maneger>Protocols for MSSQL SERVER> VIA> DEFAULT PORT 0:1433 Enable Click Yes > Apply > Ok again through Client Protocols > VIA > DEFAULT NIC 0:1433 Enable Click Yes> Apply> Ok Then in Administrative tools> Service> Telnet> Startup Type Automatic> Statuse Start ( verify please) user id / pasword are also correct . At the SQL server machine, I run netstat & see that port 1433 is open and listening. please tell me the way of telnet test for port 1433.

This test should be from another PC through network connecting to the SQL server. Thanks

"Joie" wrote:

Hi this is like forgotten knowledge to me since now I handle merchandise instead of computers

But it should be like

1. Open windows command prompt i.e Start -> Run -> type cmd
2. If you know the target server IP Address example 192.168.0.3 do : telnet 192.168.0.3 1433
3. Press enter
4. If you dont get connection refused / failed message that means the port is open to you to access
5. If you do get refused connection you may try to find out where it is blocked along the network path

1. To trace the path to the SQL server you can type tracert 192.168.0.3

1. See where it hangs..take note the last ip address in the hop
2. Ask your customer what is that IP address (it may be a network device / router/firewall ip addresses)
3. Check with them whether that device in the middle is configured to block your access through port 1433

Hi Joie Thanks for your Help. The telnet test is OK, also trace test is OK, then I turn ON Telnet Server & Telnet Client in Server machine, as well as checked all port through netstat

-an, every th> Hi this is like forgotten knowledge to me since now I handle merchandise