OOPS... i meant PERSONAL and not professional edition.
Personal Edition has the same performance delimiter as MSDE, i.e. 25
concurrent users is really pushing it. It has no limit on the database size
though, but you need a full SQL Server license to actually be allowed to use
Personal Edition on a separate machine. You can't use personal Edition
separately. I.e. what you are doing probably violates the licensing
agreement.
Jacco Schalkwijk
SQL Server MVP
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:23137F31-435A-4FF0-9AAB-9ACC5190E48B@.microsoft.com...
> OOPS... i meant PERSONAL and not professional edition.
Showing posts with label edition. Show all posts
Showing posts with label edition. Show all posts
Wednesday, March 28, 2012
Professional edition vs. SQL Server
Hi
i am using the professional edition (since i'm running it on a windows 2000 pro machine), but i wanted to know what performance gains there are between the pro. edition vs. the real sql server that would be run on a windows 2000 advanced server machine
currently i'm trying to write/query an enormous amount of data. the bottleneck is now the database, but before i go through the trouble of rebuilding a maching with 2000 server, i wanted to know what the "gains" were and if it would even be worth the time to do this
Thanks
mikeOOPS... i meant PERSONAL and not professional edition.|||Personal Edition has the same performance delimiter as MSDE, i.e. 25
concurrent users is really pushing it. It has no limit on the database size
though, but you need a full SQL Server license to actually be allowed to use
Personal Edition on a separate machine. You can't use personal Edition
separately. I.e. what you are doing probably violates the licensing
agreement.
--
Jacco Schalkwijk
SQL Server MVP
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:23137F31-435A-4FF0-9AAB-9ACC5190E48B@.microsoft.com...
> OOPS... i meant PERSONAL and not professional edition.
i am using the professional edition (since i'm running it on a windows 2000 pro machine), but i wanted to know what performance gains there are between the pro. edition vs. the real sql server that would be run on a windows 2000 advanced server machine
currently i'm trying to write/query an enormous amount of data. the bottleneck is now the database, but before i go through the trouble of rebuilding a maching with 2000 server, i wanted to know what the "gains" were and if it would even be worth the time to do this
Thanks
mikeOOPS... i meant PERSONAL and not professional edition.|||Personal Edition has the same performance delimiter as MSDE, i.e. 25
concurrent users is really pushing it. It has no limit on the database size
though, but you need a full SQL Server license to actually be allowed to use
Personal Edition on a separate machine. You can't use personal Edition
separately. I.e. what you are doing probably violates the licensing
agreement.
--
Jacco Schalkwijk
SQL Server MVP
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:23137F31-435A-4FF0-9AAB-9ACC5190E48B@.microsoft.com...
> OOPS... i meant PERSONAL and not professional edition.
Friday, March 23, 2012
ProClarity and Windows Vista
I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?
Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/details.aspx?FamilyID=7a65e401-b298-46c6-a370-ce9d65d4fb21&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issues
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?
sql
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?
Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/details.aspx?FamilyID=7a65e401-b298-46c6-a370-ce9d65d4fb21&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issues
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?
sql
ProClarity and Windows Vista
I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/...&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issu
es
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is
a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/...&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issu
es
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is
a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?
Wednesday, March 21, 2012
Processor model
I have a server with 4 dual core processors.
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.
JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>
|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.
> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>
|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
> Yes.
>
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>
|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>
sql
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.
JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>
|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.
> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>
|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
> Yes.
>
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>
|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>
sql
Processor model
I have a server with 4 dual core processors.
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.
> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
> Yes.
>
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.
> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
> Yes.
>
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>
Processor model
I have a server with 4 dual core processors.
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.
> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the bios
>> level to be legal?
> Yes.
>> If I don't disable it, will it use all 4 processors even though I only
>> bought license for one processor?
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I have a server with 4 dual core processors.
>> If I install SQL Server 2005 Express edition on it (which is free), I do
>> not have to disable other 3 processors because by default express edition
>> will use at most 1 processor?
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the bios
>> level to be legal? If I don't disable it, will it use all 4 processors
>> even though I only bought license for one processor?
>> Help would be appreciated.
>|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the
>> bios level to be legal?
>> Yes.
>> If I don't disable it, will it use all 4 processors even though I only
>> bought license for one processor?
>> SQL Server will use the lesser of either the number of supported or
>> installed processors. Workgroup supports up to 2 CPUs and Standard up to
>> 4. However you will be violating the license agreement unless you have
>> processor licenses for each processor socket available to the OS. See
>> http://www.microsoft.com/sql/howtobuy/faq.mspx
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "JJ" <nospam@.nospam.com> wrote in message
>> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I have a server with 4 dual core processors.
>> If I install SQL Server 2005 Express edition on it (which is free), I do
>> not have to disable other 3 processors because by default express
>> edition will use at most 1 processor?
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the
>> bios level to be legal? If I don't disable it, will it use all 4
>> processors even though I only bought license for one processor?
>> Help would be appreciated.
>>
>
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.
> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the bios
>> level to be legal?
> Yes.
>> If I don't disable it, will it use all 4 processors even though I only
>> bought license for one processor?
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I have a server with 4 dual core processors.
>> If I install SQL Server 2005 Express edition on it (which is free), I do
>> not have to disable other 3 processors because by default express edition
>> will use at most 1 processor?
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the bios
>> level to be legal? If I don't disable it, will it use all 4 processors
>> even though I only bought license for one processor?
>> Help would be appreciated.
>|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the
>> bios level to be legal?
>> Yes.
>> If I don't disable it, will it use all 4 processors even though I only
>> bought license for one processor?
>> SQL Server will use the lesser of either the number of supported or
>> installed processors. Workgroup supports up to 2 CPUs and Standard up to
>> 4. However you will be violating the license agreement unless you have
>> processor licenses for each processor socket available to the OS. See
>> http://www.microsoft.com/sql/howtobuy/faq.mspx
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "JJ" <nospam@.nospam.com> wrote in message
>> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I have a server with 4 dual core processors.
>> If I install SQL Server 2005 Express edition on it (which is free), I do
>> not have to disable other 3 processors because by default express
>> edition will use at most 1 processor?
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the
>> bios level to be legal? If I don't disable it, will it use all 4
>> processors even though I only bought license for one processor?
>> Help would be appreciated.
>>
>
Wednesday, March 7, 2012
Process in SQL Server 2005
Hi, I am developing an application with vb.net and sql server 2005 express edition. If a user logs in (through the application), I want to query the computer host from sql server 2005 in which the user logs on. Is there any special table or procedure that I can use to achieve this? Thanks.
hi,
ghozan wrote:
Hi, I am developing an application with vb.net and sql server 2005 express edition. If a user logs in (through the application), I want to query the computer host from sql server 2005 in which the user logs on. Is there any special table or procedure that I can use to achieve this? Thanks.
can you please expand on your requirement? I did really not understand what you are looking for..
regards
|||check system sp ... sp_who or
select *from sys.dm_exec_sessions
Madhu
Process in SQL Server 2005
Hi, I am developing an application with vb.net and sql server 2005 express edition. If a user logs in (through the application), I want to query the computer host from sql server 2005 in which the user logs on. Is there any special table or procedure that I can use to achieve this? Thanks.
hi,
Hi, I am developing an application with vb.net and sql server 2005 express edition. If a user logs in (through the application), I want to query the computer host from sql server 2005 in which the user logs on. Is there any special table or procedure that I can use to achieve this? Thanks.
can you please expand on your requirement? I did really not understand what you are looking for..
regards
|||check system sp ... sp_who or
select *from sys.dm_exec_sessions
Madhu
Subscribe to:
Posts (Atom)