dbTalk Databases Forums  

Using two or more CPU core

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Using two or more CPU core in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bofcilo
 
Posts: n/a

Default Using two or more CPU core - 11-12-2009 , 05:27 AM






We are using SA10 on Vista 64 PC with CPU 4 core. For one stored
procedure, Vista performance monitor show that only one core (logical
processor) is using. What should be set on database server for using
more than one core per connection or procedure. Is it possible to
manage when or who (connection or procedure) get more than one CPU
core ?

Reply With Quote
  #2  
Old   
André Schild
 
Posts: n/a

Default Re: Using two or more CPU core - 11-12-2009 , 11:25 AM






Bofcilo schrieb:
Quote:
We are using SA10 on Vista 64 PC with CPU 4 core. For one stored
procedure, Vista performance monitor show that only one core (logical
processor) is using. What should be set on database server for using
more than one core per connection or procedure. Is it possible to
manage when or who (connection or procedure) get more than one CPU
core ?
Normally SA does use all available cores.
But of course the tasks must be "threadable", and for stored procedures
it depends what it does, if it can be split ito separate threads.

André

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.