.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Processor Licensing on VSphere

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server


We just have  VMWare,   we are looking at installing a one VM with 4 procesors using the per processor model and SQL 2008 R2.   We cant work out if we need one license or 4 for the server.

We know we have 2 hosts with 2 Processors & 6 Cores and HHT Enabled = 48 Processors but cant make sense of microsofts licensing docs.

Can Anyone Assist


View Complete Post

More Related Resource Links

'mscorlib.dll' targets a different processor/.net calling a native dll

I  have a vb.net that calls a dll in native cpp.  Works fine in 32bit.  Now I want to upgrade to 64 bit.  I've done this before and it worked but now get a runtime error.  Compiles ok but with the error noted in the subject line. Also, when I try to debug, the ide tells me that it can't debug managed and native.  Yes it can, I just forgot how. platform is win7, intel 64 bit.  any suggestion to the forum/whitepaper or ideas are greatly appreciated. Thanks in advance! Robert.

Maximum Number of Processor Cores in CLR

Is the maximum number of processors (cores) supported by different versions of the CLR documented somewhere?  I'm working on an application hang problem and I can see in dumps that a thread is waiting in mscorwks!ThreadpoolMgr::RecycleMemory for a flag whose address was calculated by using the processor number as an index.  I can't see the index in the dump, but the machine has 48 processors and it looks as though the array containing the flags can accomodate only 32 processors, so the thread might be waiting on something beyond the array. Another clue is that there are only 32 GC threads, so I'm suspicious that this CLR will only scale to 32 cores. The CLR in use is the 32-bit version of 2.0 running on 64-bit Windows 2008 SP2.  I'd like to see whether there is a restriction on the number of processors in that version and, if so, whether there is another version that would support more.

SSMS 2008 & Activity Monitor's Processor Time graph is disabled

Hi,I just upgraded one of my SQL 2005 clusters to SQL 2008 with CU9.  Now, when I connect to it with SSMS, either from my workstation or directly on a cluster node, the % Processor Time graph in the Activity Monitor screen is disabled.  The other three graphs are fine.  If I connect to a different SQL 2008 server, the % Processor Graph is fine.  I don't see any errors in any app event log.  Has anyone else seen this behavior?Thanks!

SQL Server 2008 Licensing and VMWARE

Hi, We are currently running a vmware environment with 10 physical machines and we are thinking of running SQL Server 2008 Std Edition in one virtual operating environment. We already have SQL 2008 user cal's, am I correct in assuming that we only now need one SQL Server 2008 Std Edition Server license, or do we need to licence each of the 10 machine the VOE could be running on. Thanks Adam Sankey

Downgrading from Sharepoint 2010 Internet Enterprise to Standard (Purely a licensing rights question

My company already owns a license for Sharepoint 2010 Internet Enterprise.  We are planning a two server Internet farm.  We need to buy one more license and we only need the standard version which is significantly cheaper.  Is it allowed to use Standard when we own a license for Enterprise?

using pre-processor directives to turn off console.writeline statements?

I have a DOS console application that when processing files will output information to the screen.This is a nice feature when I run the program. But when in production it would somehow be niceto turn of all of my Console.WriteLine statements.  Because unlike my test environment, in production,several hundred files will be processed, and printing out console information will slow my console applicationdown. (I think. You see the console application is set up to run as a scheduled task everyday at 12 noon) So here is my question. Can the console.writilines be turned off in production using C# pre-processor directives?I have read about the Pre-Processor directives, but something is not clicking in regards to how I can apply it.So I am hoping I can apply it in the situation I just described.

MS SQL 2000 The query processor ran out of stack space during query optimization.

On an insert statement with an image field I get the following error when the data to go into the image field is over a certain size. Lots of special characters. The query processor ran out of stack space during query optimization. Please help on how to fix.

Login by FBA and Licensing problem

My sharepoint 2010 server will use FBA for login ,do I need buy any user Cal ? Thx  

Will .NET 4 run and install on a Intel Atom Processor N450 netbook?

Not sure where else to find this info... Does it matter if the netbook is running Windows 7 vs XP sp3? TIA, George

Error in SQL server 2000 after the migration (internal query processor error)

I just moved a couple of databases from one instance of SQL 2000 from different hardware to SQL 2000 instance of other hardware and after the move from the application side the app team gets an error -2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X. Does any one have any idea about this. I took a trace while they were testing and I found out this in the trace. exec usp_DlyPrc_LogProcessEvent '-2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X An idea or direction on this will be greatly appreciated. Thanks hash

SQL Server Licensing in a VMWare Environment with hyperthreading turned on.

Question:   If we have a 2 - quad core host server with hyper-threading turned on so that we see 16 virtual cpu's how are the SQL licenses (per processor) used ? I know that a single  per processor SQL License will cover 4 virtual cpu's on a QUAD cord processor but with hyper-threading turned on does that translate to a single processor SQL license covering 8 virtual cpu's ? Thanks

Security processor was unable to find a security header in the message



Recently on one of my machines, my client (WCF client) is having problem talking to WCF server. Both server and client are running on the same machine. The machine is Windows7 64 bit machine. It used to work fine until recently. The same software is working fine on all other machines with exactly same configuration. I am really confused here. Could someone please let me know what could be the problem?

Exception Type:

System.ServiceModel.Security.MessageSecurityException, System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089


Security processor was unable to find a security header in the message. This might be because the message is an unsecured fault or because there is a binding mismatch between the communicating parties. This can occur if the service is configured for security and the client is not using security.

Stack Trace: System.ServiceModel.Security.TransportSecurityProtocol.VerifyIncomingMessageCore(Message& message, TimeSpan timeout) System.ServiceModel.Security.TransportSecurityProtocol.VerifyIncomingMessage(Message& message, TimeSpan timeout) System.ServiceModel.Security.SecurityProtocol.VerifyIncomingMessage(Message& message, TimeSpan timeout, SecurityProtocolCorrelationState[] correlationStates) System.ServiceModel.Channels.SecurityChannelListener

SQL licensing Question


Do any of the following require additional SQL licensing(ie will i have to upgrade to a SQL 2008 database license)?


Using SQL 2008 reporting services with SQL 2005 database on the same physical server.

Using SQL 2008 reporting services with SQL 2005 database on same physical computer but in a virtual server environment.

Using SQL 2008 reporting services with SQL 2005 database with reporting services installed on a separate physical server.

SQL Server 2008 R2 and MSDN Licensing


I am creating a VM for the development team of an upcoming project and have a question around licensing.

The MSDN download for SQL Server 2008 R2 now comes pre-pidded.  Does this mean that I can download and install the full server install on the VM using the pre-pidded product key?  All the developers have their own MSDN subscriptions so they would have legitimate licenses.  I just don't want them to have to install SQL on the VM before they start work.

Ideally I will sysprep the images using the new prepared image functionality in R2.

My thought was to download the MSDN iso and then extract it to a folder on the VM.  Then I can run a prepared image install and sysprep the image.  I can then script up the final part of the install to run when the VM is first fired up.  The only issue here is if the license key would have to change.  Hopefully I can confirm that the pre-pidded download will be fine for all developers with a valid MSDN subscription.


Licensing a SDK



I've written an SDK/Toolset, that I'd like to sell by license (i.e. 1 Developer license = x, 3-5 Developer license = y, Unlimited Developer license = z). Anyone have a link to a tutorial/3rd party SDK that does this?


Licensing situation with internet facing website using sharepoint foundation

I'm considering using wss 4.0 for my internet facing website, with windows 2008, sql server 2008 standard on the same physical server. What is the licensing cost I'm looking at? Sifting through Microsoft's literature gave me a headache, yet no closer to an answer. Can anyone give a ballpark number, the way the total costs are added up, and the kind of licenses(processor, server, CAL, external connector etc.) for each components? Also, can I use sql server express with wss 4.0?

Office Communicator and SharePoint 2010 Licensing


CAL Licensing.

Is office communicator coming with SharePoint 2010? Or do we need to buy Office Communicator separately?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend