Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > White Paper-Technical > Capacity Planning with SQL Anywhere  
RSS Feed
 
 
 

Capacity Planning with SQL Anywhere

We present an overview of issues to consider when designing a performance evaluation of SQL Anywhere. In particular, we outline potential pitfalls when designing a benchmark based on a specific database application. We address issues related both to the construction of a model database instance, and a model application workload, and outline an approach to construct a model of performance to determine the relative importance of various performance factors, such as database cache size and the server multiprogramming level. The paper contains several examples illustrating the potential of negative scalability that can occur when executing concurrent requests in an smp environment, and how these scenarios can be generated easily by artificial contention caused by poorly-defined workloads.

Click here to view the complete document (PDF).


 

DOCUMENT ATTRIBUTES
Last Revised: Mar 26, 2008
Product: SQL Anywhere
Technical Topics: SQL Anywhere, SQL ISV Applications, SQL Server Applications
  
Business or Technical: Technical
Content Id: 1056535
Infotype: White Paper-Technical
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics