SQL Server on SGI 
Author Message
 SQL Server on SGI

Hello
I am running SQL server on an SGI (IRIX 6.2).  For some reason, 7
dataserver processes get spawned upon startup, even though 'max online
engines' = DEFAULT (which is one).  Any hints here?

Kevin

--

  vcard.vcf
< 1K Download


Sat, 26 Aug 2000 03:00:00 GMT
 SQL Server on SGI

Kevin>
Kevin> Hello
Kevin> I am running SQL server on an SGI (IRIX 6.2).  For
Kevin> some reason, 7 dataserver processes get spawned upon
Kevin> startup, even though 'max online engines' = DEFAULT
Kevin> (which is one).  Any hints here?

What you are seeing are the AIO_THREADS:

   - one master/coordinator thread
   - and the default of five user level threads
   - one "true" dataserver

You can tune the aio threads by editing your RUN_* file and
change the number of threads by setting the AIO_THREADS
environment variable.  The rule of thumb is:

        AIO_THREADS= 1.5 * <active devices>

ps:  only do the above if you are on a multiprocessor box,
     otherwise you may get better performance by turning off
     async I/O.
--
Pablo Sanchez              | Ph # (650) 933.3812          Fax # (650) 933.2821

-------------------------------------------------------------------------------
I am accountable for my actions.   http://reality.sgi.com/pablo [ /Sybase_FAQ ]



Sat, 26 Aug 2000 03:00:00 GMT
 SQL Server on SGI


Quote:

> Hello
> I am running SQL server on an SGI (IRIX 6.2).  For some reason, 7
> dataserver processes get spawned upon startup, even though 'max online
> engines' = DEFAULT (which is one).  Any hints here?

Output from the ps -ef command on SGI will show that multiple
dataserver processes exist when the SQL Server is running. The reason
for this is that IRIX creates a number of sprocs (lightweight
processes) that perform the asynchronous io operations in user space.

The 10.0.2.4 SQL Server creates 10 of these sprocs per engine.
Previously, there were 5 or 6 per engine.  These sprocs should
accumulate
very little cpu time.

--
Bret Halford                    Imagine my disappointment
Sybase Technical Support        in learning the true nature            
3665 Discovery Drive            of rec.humor.oracle...
Boulder, CO 80303



Sat, 26 Aug 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Sybase SQL server for SGI

2. OpenClient and/or web.sql on SGI IRIX to Microsoft SQL Server 6.0

3. SGI Irix to SQL Server 2K

4. MSSQL Server from SGI

5. Oracle 8i and SGI Origin 200 Server

6. 7.3 server / SGI hw

7. Installation Oracle Web Server v2.1.0.3.0 on SGI

8. Universal Server for SGI IRIX6.2

9. how to backup a sql server 65 server from a sql server 2000 server


 
Powered by phpBB® Forum Software