<div>
<div class="content wysiwyg-content">
I have a client who I manage the server for. &nbsp;A company has installed a Sybase iAnywhere database for them that tracks inventory. &nbsp;The software front end is used to enter transactions, etc. &nbsp;The problem I am having (as they have laid this at my doorstep) is that the system is slow according to the vendor. &nbsp;If I run a query in the Advatage Data Architect on the terminal server, it returns in between 7 and 60 seconds. &nbsp;If I run the same query on the DB server itself, it takes 16 ms - MUCH faster obviously. &nbsp;I would imagine the terminal server query would be a little slower due to network traffic, but I don't think it should be that slow. &nbsp;<br />
<br />
The DB server is Windows 2003 SBS with 8 GB of ram. &nbsp;It has MS SQL 2000 and Exchange 2003 on it running. &nbsp;I also have Trend Micro installed on that server. &nbsp;This server has two dual-core processors.<br />
<br />
The terminal server is Windows 2008 with 4 GB of ram and one dual-core processor. &nbsp;They have maybe 8 users on their server at most at any one time.<br />
<br />
Task manager doesn't show either box being hit hard when I do any queries. &nbsp;Memory, processory utilization and network traffic are all low.<br />
<br />
Any ideas about where I can look?
</div>
</div>


I have a client who I manage the server for.  A company has installed a Sybase iAnywhere database for them that tracks inventory.  The software front end is used to enter transactions, etc.  The problem I am having (as they have laid this at my doorstep) is that the system is slow according to the vendor.  If I run a query in the Advatage Data Architect on the terminal server, it returns in between 7 and 60 seconds.  If I run the same query on the DB server itself, it takes 16 ms - MUCH faster obviously.  I would imagine the terminal server query would be a little slower due to network traffic, but I don't think it should be that slow.  

The DB server is Windows 2003 SBS with 8 GB of ram.  It has MS SQL 2000 and Exchange 2003 on it running.  I also have Trend Micro installed on that server.  This server has two dual-core processors.

The terminal server is Windows 2008 with 4 GB of ram and one dual-core processor.  They have maybe 8 users on their server at most at any one time.

Task manager doesn't show either box being hit hard when I do any queries.  Memory, processory utilization and network traffic are all low.

Any ideas about where I can look?

Sybase iAnywhere SQL database performance issues

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Network Operations includes asset management, help-desk supervision, security and user policies, infrastructure administration and anything else that affects the operation of your network. Discussions will include those of best practices in platforms, configurations, performance, security and accounting.