Configuring Sybase SQL Server 11 
Author Message
 Configuring Sybase SQL Server 11

Hi All,

I'm new at configuring a SyBase Server. I've worked with the Sybase SQL
server for some time but never configured or changed the configuration of a
new or existing server (i.e. added database devices, configuring caches
etc..). I'm experimenting a little with it to see if I can up the
performance a bit..

Does anyone have some nice tips on how to setup caches and stuff like
that??

--
FIQAS Software B.V.

Bastiaan Olij



Fri, 10 Dec 1999 03:00:00 GMT
 Configuring Sybase SQL Server 11


Quote:
> Hi All,

> I'm new at configuring a SyBase Server. I've worked with the Sybase SQL
> server for some time but never configured or changed the configuration of a
> new or existing server (i.e. added database devices, configuring caches
> etc..). I'm experimenting a little with it to see if I can up the
> performance a bit..

> Does anyone have some nice tips on how to setup caches and stuff like
> that??

Bastiaan,

Your request is a bit vague...  it's very difficult to simply
quantify, "if you see this, turn this knob"...  one has to take the
entire system into account.

Things to do, IMHO, is to create a benchmark that simulates your user
load (10, 100, 1000 connections) and run this.  You'll then be able
to tune at the system level, and then proceed to the SQL Server
level.
--

--------------+-----------------+--------------------------------------------



Mon, 13 Dec 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Upgrade from Sybase SQL Server 11.0.1 to Sybase ASE 11.9.2

2. error configuring DAT drive on Sybase 11 under SCO Open Server

3. MaximDevice limit for SQl Server 11-11.5 (was: Sybase 2Gb Limit)

4. migrate Sybase 11.0.1 and Sybase 11.5.1 to MS sql 6.5/7.0

5. Sybase SQL Server 11.0.3 to MS SQL Server 7.0 Migration Experiences

6. Using Sybase Central with Sybase SQL Server 11.0.3

7. Configuring Sybase 11

8. Linked Server Problems with Sybase ASE 11 from SQL Server 2000

9. Sybase System 11 database server access with SQL server 6.5

10. history server 11.9.2.1 on Sybase 11.0.3.3

11. SYBASE SQL SERVER 11 running on Sun's SPARC server

12. Transact-SQL: Diff btw Sybase 11 and MS SQL Server 6.5


 
Powered by phpBB® Forum Software