Re: [firebird-support] CPU Affinity
Hi Mark. Thanks for your answer. My reasoning was that more cores to process , more performance . However , in the light of your explanation I changed my way of thinking. Do you see any difference between using Classic Server and SuperClassic , except number of processes? Em 19/01/2016 19:14, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] escreveu: Setting the cpu affinity to target more than one cpu will usually be worse for performance, as SuperServer is essentially single threaded and allowing it to run on multiple cores will cause expensive rescheduling. SuperServer may perform better than Classic because CS has a smaller page buffer by default, and the synchronisation between processes is more expensive than in-process. The scale however will usually tip in favor of classic when using a large number of connections, as SuperServer will eventually be limited by how much it can do in its single thread. Mark - Reply message - Van: "Hugo Eyng hugoe...@msn.com [firebird-support]" Aan: Onderwerp: [firebird-support] CPU Affinity Datum: di, jan. 19, 2016 21:01 Hi Thomas. Thanks for your answer. I use SuperServer. Why? Performance. It seems to run faster. Hugo Em 19/01/2016 12:21, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] escreveu: Hi! > Dear Friends. > > FirebirdSQL : 2.5.5 64bits > Operating System: Windows 2008 R2 Enterprise 64bits > Server : Dell Poweredge R620 > 32GB > 2 processors E5-2609 2.40 GHz > 8 Cores > > To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a > way to use all the 8 cores. Which Firebird server architecture are you using? CPU affinity is only for SuperServer and the question is why do you bother with SuperServer on a multi-core machine when there is Classic or SuperClassic available? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Does it make sense or could be better to use less cores, like core > 5,6,7,8 or 3,4,5,6? > > -- > > > Atenciosamente, > > Hugo Eyng > > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu there. > > Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ > > > ++ > > > Yahoo Groups Links > > > -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] CPU Affinity
Setting the cpu affinity to target more than one cpu will usually be worse for performance, as SuperServer is essentially single threaded and allowing it to run on multiple cores will cause expensive rescheduling. SuperServer may perform better than Classic because CS has a smaller page buffer by default, and the synchronisation between processes is more expensive than in-process. The scale however will usually tip in favor of classic when using a large number of connections, as SuperServer will eventually be limited by how much it can do in its single thread. Mark - Reply message - Van: "Hugo Eyng hugoe...@msn.com [firebird-support]" Aan: Onderwerp: [firebird-support] CPU Affinity Datum: di, jan. 19, 2016 21:01 Hi Thomas. Thanks for your answer. I use SuperServer. Why? Performance. It seems to run faster. Hugo Em 19/01/2016 12:21, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] escreveu: Hi! > Dear Friends. > > FirebirdSQL : 2.5.5 64bits > Operating System: Windows 2008 R2 Enterprise 64bits > Server : Dell Poweredge R620 > 32GB > 2 processors E5-2609 2.40 GHz > 8 Cores > > To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a > way to use all the 8 cores. Which Firebird server architecture are you using? CPU affinity is only for SuperServer and the question is why do you bother with SuperServer on a multi-core machine when there is Classic or SuperClassic available? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Does it make sense or could be better to use less cores, like core > 5,6,7,8 or 3,4,5,6? > > -- > > > Atenciosamente, > > Hugo Eyng > > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu there. > > Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ > > > ++ > > > Yahoo Groups Links > > > -- Atenciosamente, Hugo Eyng
Re: [firebird-support] CPU Affinity
Hi Thomas. Thanks for your answer. I use SuperServer. Why? Performance. It seems to run faster. Hugo Em 19/01/2016 12:21, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] escreveu: Hi! > Dear Friends. > > FirebirdSQL : 2.5.5 64bits > Operating System: Windows 2008 R2 Enterprise 64bits > Server : Dell Poweredge R620 > 32GB > 2 processors E5-2609 2.40 GHz > 8 Cores > > To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a > way to use all the 8 cores. Which Firebird server architecture are you using? CPU affinity is only for SuperServer and the question is why do you bother with SuperServer on a multi-core machine when there is Classic or SuperClassic available? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Does it make sense or could be better to use less cores, like core > 5,6,7,8 or 3,4,5,6? > > -- > > > Atenciosamente, > > Hugo Eyng > > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu there. > > Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ > > > ++ > > > Yahoo Groups Links > > > -- Atenciosamente, Hugo Eyng
Re: [firebird-support] CPU Affinity
Hi! > Dear Friends. > > FirebirdSQL: 2.5.5 64bits > Operating System: Windows 2008 R2 Enterprise 64bits > Server: Dell Poweredge R620 > 32GB > 2 processors E5-2609 2.40 GHz > 8 Cores > > To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a > way to use all the 8 cores. Which Firebird server architecture are you using? CPU affinity is only for SuperServer and the question is why do you bother with SuperServer on a multi-core machine when there is Classic or SuperClassic available? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Does it make sense or could be better to use less cores, like core > 5,6,7,8 or 3,4,5,6? > > -- > > > Atenciosamente, > > Hugo Eyng > > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++ > > > Yahoo Groups Links > > >
[firebird-support] CPU Affinity
Dear Friends. FirebirdSQL: 2.5.5 64bits Operating System: Windows 2008 R2 Enterprise 64bits Server: Dell Poweredge R620 32GB 2 processors E5-2609 2.40 GHz 8 Cores To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a way to use all the 8 cores. Does it make sense or could be better to use less cores, like core 5,6,7,8 or 3,4,5,6? -- Atenciosamente, Hugo Eyng ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
