Oracle Licensing For Dual Core Processors
Nov 23, 2005
Hi,
Is there a reason why we have to pay more for licensing for a different
kind of processor?
Why are we not charged for the Hyperthreading on some processors also.
If Oracle is really conserned about the low end business market (small
and medium), then they should drop their attitude on Dual Core
processors.
If they start charging as if it was a normal processor, and ask the
normal price, then they would get more of this market coming in.
As long as Oracle keeps on having the attitude of charging more,
because Intel or some other cpu vendor decided to mprove their
processors because of overheating problems, I will have the attitude
that I will keep on reoccomending alternatives for Orcle like Mysql /
Postgre sql / Sybase, etc to the small/medium sector.
Microsoft's pricing model on double core processors suddenly sound
allot better.
Oracle are shooting themselves in the foot! Or am I the only person
feeling this way?
Shaun O'Reilly
View 2 Replies
ADVERTISEMENT
Mar 17, 1999
We have a 200MHz Pentium Pro based machine, with 128MB RAM running SQL Server 6.5. Because of performance issues, we are contemplating an upgrade to a dual 200MHz Pentium Pro processor with 256MB RAM. However, the vendor we are dealing with has suggested an upgrade to a single Pentiun II/333MHz first, and if this still causes problems, then to a dual P II/333MHz.
Does anyone have any suggestions from similar upgrades that they may have undergone?
We have 72MB allocated to SQL Server.
View 3 Replies
View Related
Aug 3, 2007
We are in process of moving to 64 bit HP servers with sql2005 standard edition. We were just wondering which is better option, to get a server with 2 dual core processor or to get a srver with just 4 processor? How does SQL2005 handle the hypertheading of dual processor?
Thanks,
Carlos
View 1 Replies
View Related
Jul 17, 2007
Hi,
I am running MSSQL 2005 Standard edition on a two processor Intel Xeon 3GHz (dual-core) with 8GB RAM.
I notice in "Windows task manager CPU performance" while running a long SQL statement (takes 1.5 hours), only 1 logical (out of 4) is utilised at >70%. The remaining 3 logical processors hover around 10%
Using Performance monitor, the average read queue, write queue, and pages/sec also hovers around 25%, indicating no heavy physical disk/memory loading.
How can I set to utilise more physical/logical processor to improve the MSSQL performance ?
Thanks.
View 2 Replies
View Related
May 7, 2007
ok i have intel dual core i have a conflict only in playing a game black hawk down it gives me a run stop error. locks up and has to be restarted. microsoft gave me a fix but when i do the fix it causes me to get a system dump error on the game. i can update my web site do anything else let daughter play her games or do her school work and nothing happens. i was told i needed to set up the dual core so that my programs dont conflict i am a moron when it comes to computers is there a fix for this or i am i just going to have to go back to single core processor for now thanks
View 1 Replies
View Related
Feb 13, 2008
When Standard Edition says it supports 4 processors, is this just the physical processor or do we have to factor in multiple cores?
If SE supports 4 physical quad-core processors, is it written to optimally utilize the quad-core technology or would I be better off using Enterprise Edition?
Dave
View 4 Replies
View Related
Feb 27, 2008
hi all,
I was under the impression that SQL Server 2005 can install on dual processor, quad core Intel machines.
Here's what we have: Intel Quad Core Xeon (E7340) @ 2.4Ghz. (8 way)
Has anyone encountered any issues w/ this setup -- particularly on this Intel CPU version?
thank you,
Cosmin
View 3 Replies
View Related
Jul 18, 2007
Is it possible in SQL Server 2005 to limit the number of processors used? For cost reasons, we are consolidating servers and want to start running SQL Server 2005 on one of our dual-processor Win2K3 machines instead of the standalone machine it's currently running on. Because we have about 75 users, it's only cost effective to purchase a processor license (vs. a server license with CALs). But right now we only need and can only afford a single processor license, not two. So...
Is there any way in 2005 to limit the number of processors used so that we only need to purchase one processor license? I know in 2000 you could set this on the "Processor" tab of the "SQL Server Properties" dialog. In 2005, is this accomplished by unchecking the "Processor Affinity" and "I/O Affinity" checkboxes for processor #2 on the "Processors" page of the "Server Properties" dialog? If I uncheck these two options does that fully disable SQL Server 2005 from accessing the second processor in any way? From things I've read I can't tell if it restricts access to the second processor completely or if it just places some limitations on the ways it accesses the second processor.
Also, the licensing information for SQL Server 2005 leads me to believe that if you are going down the "processor licensing" route that you have to buy a processor license for every processor that the OS itself has access to and not just what processors SQL Server has access to. I thought I understood that in SQL Server 2000 the licensing information did allow you to buy a processor license just for each processor that SQL Server 2000 had access to, but has that changed for 2005?
Hope someone can provide some clarification on limiting processor access and the licensing implications for SQL Server 2005.
Thanks,
Scott
View 5 Replies
View Related
Aug 13, 2015
I configured an SSIS package to collect information about servers in our environment and as a part of it the package collects the Physical and Logical CPU's. Since we are on per-core licensing for SQL Servers, i would need to get the exact core count. I can simply do Logical cpu / Physical CPU to get the Core count assuming that hyperthreading is turned on. What if the hyperthreading is not on, then i would end up getting the wrong Core count.
I query the registry to get this info. I would like to get your inputs for getting the exact core count on Windows servers with Intel and AMD processors.
View 3 Replies
View Related
May 25, 2001
I am searching for the MS SQL equivilent for the Oracle Dual command.
select 'hello' from dual;
Jeff
jchie@vafb.com
View 2 Replies
View Related
Jul 20, 2005
I am planning to build a server to be used as a SQL Server and web server.Right now I can only use a single box for both.I have read some threads were dual processors are having problems with someparallel queries and the suggestions of having sql server use a single CPU.My budget is limited so I am debating whether to get 2.6G dual xeon 533FSBor dual P4 800FSB (DRR@ ram) or stick with a speedy single cpu.If I get a dual cpu motherboard, is it a good idea to have 1 cpu used forsql server and the other for everything else?John Dalberg
View 5 Replies
View Related
May 2, 2000
Hi all,
I am using sql server 7 i am having 4 processors in development server.
How i have to allocate those servers, means all 4 do i need to allocate to sql only or 3 processors.
same like 8 processors in production, how many processors to sql..
pls tell me the way..and how..
thank u all
esh
View 4 Replies
View Related
Nov 18, 1999
Specs: Dell 6350 Poweredge, 4 Xeon 500, 4GB Ram
SQL 7 Sp1.
At some point, my 4 processors began a cycle of Peaks and Valleys.
AFter stopping ALL processes using the SQL server the processors were still doing this Max, then none, Max, then none.
I think the oddest part of this is that all 4 processoers were Exactly the same Peaks/Valleys from my Workstation (perfmon).
Anone had their processors do this? HELP PLEASE.. .
View 2 Replies
View Related
Jun 24, 2003
While installing SQL2k I selected a 4 processor liscense aggreement. The server only has two. Does anybody know of a technial reason I should change it back? Can it be done without reinstalling?
Sidney Ives
Database Administrator
Sentara Healthcare
View 2 Replies
View Related
Jun 19, 2003
We are looking at upgrading our SQL Server machine to multiple processors.
Will this act alone result in a performance improvment?
View 3 Replies
View Related
Sep 14, 2007
how to find out how many processors are licensed on the server?
=============================
http://www.sqlserverstudy.com
View 1 Replies
View Related
Jun 5, 2001
Is there a limit to the number of processors that can interact with SQL Server 7?
Also, what is the minimum amount of memory necessary to run SQL Server 7?
View 1 Replies
View Related
Aug 30, 2005
Hi,I have an application where I need to find out about the followinginformation regarding SQL server:Processors enabledi.Threads allocatedii.PriorityCan somebody throw some light on this. How are the processors relatedto the threads running and the priority is w.r.t. what?Thanks,Verve.
View 1 Replies
View Related
May 30, 2007
I'm spec up a new server At the minimum I'll specify a quad core cpu. What would be the best way to utilize the cores? Assign a core to specific processes (tempdb?) or let sql server figure out the best way to used the processors it finds?
View 1 Replies
View Related
Jul 10, 2006
Can I install SQL Server on a machine and use less than the # of processor on the machine. In a UNIX world, I'd call it LPARing with Oracle and AIX, and they only let me do this with Enterprise Edition. With Windows, I think the only way is using virtual machines and attaching processors to them? Do any vendors offering LPARing? Can I take any edition of SQL Server and subcapacity price so that I only pay for the processors I'm using?
What about SS Express? It only scheds to a single core - so could I put that on a larger machine?
Thanks!
View 5 Replies
View Related
Feb 23, 2007
Problem: We have a set of sql queries and one core duo processor. We want one subset of queries would be executed on first core of our CPU and the rest of queries would be executed on the second core of CPU. We are using MS SQL Server 2005 – Workgroup edition.
Is there any way how to do this with one instance of SQL Server or with two instances at least (is there any way how to force an instance A to use CPU1 (first core of core duo CPU) and instance B to use CPU2 (second core of core duo CPU)) ?
Thank you for your ideas!
Jan
View 1 Replies
View Related
Nov 1, 2007
The number of data files within a single filegroup should equal to the number of CPU cores. So for a quad core CPU there should be 4 data files. Is there anything that one need to take care besides creating the data files for a filegroup. I belieev SQL takes care of itself how to update data files .
View 5 Replies
View Related
Feb 20, 2008
Does SQL 2005 Enterprise utilize Xeon Quad Cores? or should i go with Dual Cores?
if it DOESNT, any idea if they plan on releasing a service back to allow it to?
View 9 Replies
View Related
Dec 10, 2007
We just purchased a Quad Core xeon server. It it my understanding that express can only utilize a single cpu/core. Is there a way I can setup windows or ms sql server to dedicate one particular core soley for ms sql?
View 3 Replies
View Related
Dec 6, 2004
In oracle you can run queries against some built in virtual table called dual. Like below:
SELECT SEQ.NEXTVAL FROM DUAL
does sql server have anything similar?
View 2 Replies
View Related
Dec 27, 2006
Greetings,
I'm wondering if it is possible to have two independent y-axes on a single chart?
I am wanting to plot data using a hybrid bar/line chart and have the values for the vertical bars show on the left y-axis and the values for the points on the line show on the right y-axis.
I've seen this sort of thing done on other platforms before, but don't know if it is possible with SQL Reporting. We are using SQL RS 2000 by the way.
Thanks
--
Anthony
View 6 Replies
View Related
Mar 10, 2000
Hello,
Yesterday I was looking to the processor usage in the Task Manager of Windows NT when a script of mine was running. The script was an InfoPump Script; which is a tool from the DecisionBase suite from CA (was previously owned by Platinum). This script contains SQL statements that select data from several tables and stores the result into another table. The SQL code used for this looks fine to me.
The query was running on a Compaq Proliant 5500 with 4 500 Mhz Xeon processors, 1 GB RAM, NT Server 4, SP 5, RAID 5. The SQL Server is configured to use all resources and SQL has normal priority on NT.
When the select part was running al four processors were used for about 75% and when the store happens only 1 processor is used for 100%.
Why is the store not spread over all four processors? It only uses one processor and it seems to be a bottleneck.
Stef
View 2 Replies
View Related
Sep 5, 2007
Hello,
I need change a SQL Server 2005 configuration, this service is placed in a server with 2 Physical processors dualcore and 4 processing nucleus.
I need that it´s use only one of the Physical Processors....How i do that?
TKS
View 1 Replies
View Related
Mar 7, 2007
Is it true that SQL Server treats it as 2 processors and Microsoft only charges 1 license?
That sounds VERY un-Microsoftish......but I'd better shut up....MS is probably in the process of figuing out how to nik me more for my license.)
View 1 Replies
View Related
Sep 13, 2000
I've heard somewhere that SQL Server supports dual languages ? Can anyone confirm this ? How do you set it up please ?
Essentially we need to run our database in Japanese. It currently runs in english.
thanks
Paul
View 1 Replies
View Related
Mar 15, 2007
any tutorial on how to setup SQL Server in a dual redundant environment ?
thanks
View 3 Replies
View Related
Feb 20, 2008
I have created a C# Windows Forms application that can be run connected directly to SQL Server 2005 (publisher) for in-office users and to a SQL Express (subscriber) on a tablet PC for remote users. The server is set through configuration and the remote users sync using replication and it all works.
The issue I'm having is that I've found it necessary to install SQL Server management objects (SQLServer2005_XMO) on the clients who sit at desktops and never use replication or SMO. I believe this is because SMO has to be installed in the GAC and I can't just distribute the required dlls with my app.
Is there any way I can deploy this app to always connected users without installing SMO on their machines?
Thanks, Jamie Ide
View 1 Replies
View Related
Mar 1, 2007
Hello,
Is performance of web application (ASP.NET + SQL Server 2005 Wrg edition + Win Server 2003 Web edition) running on server with one core duo/4 CPU generally comparable to the performance of the same application running on the same server with 2/4 physical CPU’s?
Thank you for your ideas!
Jan
View 1 Replies
View Related