on 2017 Sep 13 2:04 PM
Hello,
We are using a 3rd party product running under Sybase 8 (dbsrv8.exe) and we are experiencing extreme slowdowns at all of our 42 POS terminals at peak periods (breakfast, lunch & dinner).
The vendor had rebuilt our database back in December and since then, there have been intermittent "freezes" across the board. They are unable to determine what the cause is.
I've spent the last month monitoring performance and resources on the server and I see some telling activity.
Only in the last couple of days have I convinced the vendor to give me SA access to the database, but I would love some help in pinpointing the issue so that I may go back to them and ask that they fix it.
I'm not a DBA. I'm a programmer and analyst and have extensive experience with Oracle and MySQL.
Here's what I see on the server end:
Although I have a VNC view of a dozen POS terminals, there is nothing that is obvious on the performance monitor when one or more terminals freeze up.
Now it's time for me to do some database monitoring and see where the bottlenecks may be and for that I would appreciate a bit of help.
Please let me know if I can provide more information.
If someone can point me in the right direction, that would be great.
Thank you,
Elie
Request clarification before answering.
Foxhound is the only database performance monitor that works with target databases running on SQL Anywhere 8.
It does require SQL Anywhere 16 or 17 to be installed to support Foxhound's own database, and SQL Anywhere 8 doesn't provide as many performance statistics as later versions, but...
...the following screenshot of a busy SQL Anywhere 8 database with over 100 connections gives an idea of what's available:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great! I'll give it a look.
The scary thing in all this is that there is no Dev, Test or QA environment. This production-only environment is what I adopted. It's on my to-do to clone this server in the near future.
That being said, is there any risk of installing Foxhound and SQLA 16 on the same server as SQLA 8. Will they play nice together?
User | Count |
---|---|
41 | |
15 | |
10 | |
9 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.