SQL Server Performance Forum – Threads Archive

licensing per processor

I have a question regarding the licensing of MSSQL 2005. If I license SQL for only one processor and I’m actually using more than that does SQL still run normally or does it detect that I’m running it incorrectly? We’re running SQL 2000 now and we are looking at putting 2005 into the test environment and the server that we want to test has multiple processors. Any insight would be appreciated.

You may need to configure sql server to use only one processor, sql uses all processors if you don’t configure it to use one irrespective of your licencing model… Check with MS sales team about how licencing model works in this scenarion…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

More indepth information fromhttp://www.developer.com/db/article.php/3502746 this article about licensing. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Thanks for the help. My boss is paranoid. He is worried that if we install it on a server with multiple processors it will shut off if it’s not licensed properly.

Double- check if your boss checks the threads in the forum here…[<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />]

Bosses are too busy going to meetings to frequent internet forums.

In SQL 2005 you need not worry about how many or licensing information to input, only if in case any audit is performed you need to have valid number of licenses, ask your boss to take a break and look to arrange paper licenses for the number of adopted. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Check the following… http://www.microsoft.com/sql/howtobuy/default.mspx</a> http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc</a> or ownload.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc+sql+server+2005+licensing+information&hl=en&ct=clnk&cd=3&gl=us>http://64.233.167.104/search?q=cache:6TOs8c3bJyoJ<img src=’/community/emoticons/emotion-2.gif’ alt=’:d’ />ownload.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc+sql+server+2005+licensing+information&hl=en&ct=clnk&cd=3&gl=us</a> MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>