Raid for DB server

Hi guys,
quick question. i have a DELL Poweredge 6850, 4 dual core processor. my
problem is what raid configuration would be best suited for my server? I'm
thinking of raid 10.
Will wait for your response.
Thanks,
LouieHello,
My suggestion will be to go for RAID10 if your DB doing a lot of WRITE and
RAID 5 if lots of reads.
Usually system drive [C] will be mirrored. It is a good if you separate
.mdf
and .ldf files into 2 controllers
if you have enough space and multiple controllers.
Read this URL:-
http://searchstorage.techtarget.com...x298728,00.html
Thanks
Hari
"Louie Lubangco" <llubangco@.iti-consulting.com> wrote in message
news:OP5qQy99GHA.2408@.TK2MSFTNGP05.phx.gbl...
> Hi guys,
> quick question. i have a DELL Poweredge 6850, 4 dual core processor. my
> problem is what raid configuration would be best suited for my server? I'm
> thinking of raid 10.
> Will wait for your response.
> Thanks,
> Louie
>|||Thanks for the fast reply. another question. i'm not sure if this raid
controller can handle raid 10. does the internal and external count as
separate controller?
PERC4DC-PCI Express, 128MB Cache, 1-Internal 1-External Channel
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ep$$3299GHA.3860@.TK2MSFTNGP02.phx.gbl...
> Hello,
> My suggestion will be to go for RAID10 if your DB doing a lot of WRITE and
> RAID 5 if lots of reads.
> Usually system drive [C] will be mirrored. It is a good if you separat
e
> .mdf and .ldf files into 2 controllers
> if you have enough space and multiple controllers.
> Read this URL:-
> http://searchstorage.techtarget.com...x298728,00.html
> Thanks
> Hari
> "Louie Lubangco" <llubangco@.iti-consulting.com> wrote in message
> news:OP5qQy99GHA.2408@.TK2MSFTNGP05.phx.gbl...
>

Raid for DB server

Hi guys,
quick question. i have a DELL Poweredge 6850, 4 dual core processor. my
problem is what raid configuration would be best suited for my server? I'm
thinking of raid 10.
Will wait for your response.
Thanks,
LouieHello,
My suggestion will be to go for RAID10 if your DB doing a lot of WRITE and
RAID 5 if lots of reads.
Usually system drive [C] will be mirrored. It is a good if you separate .mdf
and .ldf files into 2 controllers
if you have enough space and multiple controllers.
Read this URL:-
http://searchstorage.techtarget.com/ateQuestionNResponse/0,289625,sid5_cid619546_tax298728,00.html
Thanks
Hari
"Louie Lubangco" <llubangco@.iti-consulting.com> wrote in message
news:OP5qQy99GHA.2408@.TK2MSFTNGP05.phx.gbl...
> Hi guys,
> quick question. i have a DELL Poweredge 6850, 4 dual core processor. my
> problem is what raid configuration would be best suited for my server? I'm
> thinking of raid 10.
> Will wait for your response.
> Thanks,
> Louie
>|||Thanks for the fast reply. another question. i'm not sure if this raid
controller can handle raid 10. does the internal and external count as
separate controller?
PERC4DC-PCI Express, 128MB Cache, 1-Internal 1-External Channel
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ep$$3299GHA.3860@.TK2MSFTNGP02.phx.gbl...
> Hello,
> My suggestion will be to go for RAID10 if your DB doing a lot of WRITE and
> RAID 5 if lots of reads.
> Usually system drive [C] will be mirrored. It is a good if you separate
> .mdf and .ldf files into 2 controllers
> if you have enough space and multiple controllers.
> Read this URL:-
> http://searchstorage.techtarget.com/ateQuestionNResponse/0,289625,sid5_cid619546_tax298728,00.html
> Thanks
> Hari
> "Louie Lubangco" <llubangco@.iti-consulting.com> wrote in message
> news:OP5qQy99GHA.2408@.TK2MSFTNGP05.phx.gbl...
>> Hi guys,
>> quick question. i have a DELL Poweredge 6850, 4 dual core processor. my
>> problem is what raid configuration would be best suited for my server?
>> I'm thinking of raid 10.
>> Will wait for your response.
>> Thanks,
>> Louie
>

R

Hi,

I am using Sql Server 2005 64bit on a quad processor server with 6GB memory. When I run a some TSQL that uses a cusor the average processor never goes too much above 25%. Memory using is about 300-400K for sql server.

Using perfmon it appears the disk queue length is 0 (or very close to it), can anyone suggest some perfcounters that would help me identify why my sql box isn't flying?

Thanks for your help

Graham

I highly recommend you read this excellent whitepaper.
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

Quick Licensing Question

Hello,
If I have a SQL Server set for Per Processor Licensing can I install
Personal Edition on a number of Laptops/ PC's without purchasing a license
for them? We have laptop users that travel and use a local copy of a
database. I want to move to Per Processor licensing for our main server but
an unsure if these users will fall under the per processor licensing model o
r
will still require a license to use Personal edition. From what I understan
d
they fall under per processor but I want to make sure.
Thanks for your time.The short answer is no, sorry.
Have a look at
http://www.microsoft.com/resources/...r />
0461.mspx
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain
"DM" wrote:

> Hello,
> If I have a SQL Server set for Per Processor Licensing can I install
> Personal Edition on a number of Laptops/ PC's without purchasing a license
> for them? We have laptop users that travel and use a local copy of a
> database. I want to move to Per Processor licensing for our main server b
ut
> an unsure if these users will fall under the per processor licensing model
or
> will still require a license to use Personal edition. From what I underst
and
> they fall under per processor but I want to make sure.
> Thanks for your time.|||That is not how I understand it. Can you be a bit more specific, Peter? Belo
w, for instance,
indicates to me that PE is applicable in a Per Processor environment:
http://www.microsoft.com/sql/howtobuy/faq.asp
(Search for "Personal" in above page.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.
microsoft.com> wrote in
message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...[vbcol=seagreen]
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/.../>
/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
>|||Thanks for that. Big misunderstanding on my part.
"Peter 'Not Peter The Spate' Nolan" wrote:
[vbcol=seagreen]
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/.../>
/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
>|||I read Tibor's link and I remember reading that document a while ago and
thinking the using Per Processor would cover Personal editions. But I've no
idea what the licensing is now. Any one know for sure if Per Processing wil
l
cover Personal Edition?
Thanks again
"Peter 'Not Peter The Spate' Nolan" wrote:
[vbcol=seagreen]
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/.../>
/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
>|||Thanks Tibor,
Well you learn something new every day, DM, I got the answer totally wrong
(again), Tibor, thank you for pointing it out.
Peter
"Adam and Eve had many advantages but the principal one was that they
escaped teething."
Mark Twain
Q. What type of license do I need to install and run SQL Server Personal
Edition?
A. SQL Server Personal Edition is not a separate product, but instead a
component of SQL Server that is designed to bring SQL Server functionality t
o
desktop applications. It can be installed and used on any Microsoft
Windows–based device within an organization provided it is properly licens
ed
with a CAL or connects to servers that are properly licensed according to th
e
Per Processor licensing model.
If SQL Server Personal Edition interfaces with an instance of SQL Server,
and then distributes that data to other devices, SQL Server Personal Edition
is acting as a mutliplexer and SQL Server device CALs are required for all
devices accessing it. If you have licensed SQL Server according to the Per
Processor licensing model, you can have an unlimited number of connections t
o
that server, whether it is through SQL Server Personal Edition or through
direct connections.
"Tibor Karaszi" wrote:

> That is not how I understand it. Can you be a bit more specific, Peter? Be
low, for instance,
> indicates to me that PE is applicable in a Per Processor environment:
> http://www.microsoft.com/sql/howtobuy/faq.asp
> (Search for "Personal" in above page.)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussion
s.microsoft.com> wrote in
> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
>
>|||I believe that DM should contact a sales rep as MS about this. Especially co
nsidering the last part
of below sentence:
"It can be installed and used on any Microsoft
Windows-based device within an organization provided it is properly licensed
with a CAL or connects to servers that are properly licensed according to th
e
Per Processor licensing model."
Note:
*It* can be installed... or connects to servers.. properly licensed accordin
g to the
Per Processor...
Seems to me like PE need to connect to the server, somehow, perhaps replicat
ion...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.
microsoft.com> wrote in
message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor,
> Well you learn something new every day, DM, I got the answer totally wrong
> (again), Tibor, thank you for pointing it out.
> Peter
> "Adam and Eve had many advantages but the principal one was that they
> escaped teething."
> Mark Twain
>
> Q. What type of license do I need to install and run SQL Server Personal
> Edition?
> A. SQL Server Personal Edition is not a separate product, but instead a
> component of SQL Server that is designed to bring SQL Server functionality
to
> desktop applications. It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licens
ed
> with a CAL or connects to servers that are properly licensed according to
the
> Per Processor licensing model.
> If SQL Server Personal Edition interfaces with an instance of SQL Server,
> and then distributes that data to other devices, SQL Server Personal Editi
on
> is acting as a mutliplexer and SQL Server device CALs are required for all
> devices accessing it. If you have licensed SQL Server according to the Per
> Processor licensing model, you can have an unlimited number of connections
to
> that server, whether it is through SQL Server Personal Edition or through
> direct connections.
>
>
>
> "Tibor Karaszi" wrote:
>|||I've sent an email off to Microsoft for a little clarity.
Thanks for you help.
"Tibor Karaszi" wrote:

> I believe that DM should contact a sales rep as MS about this. Especially
considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licens
ed
> with a CAL or connects to servers that are properly licensed according to
the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed accord
ing to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replic
ation...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussion
s.microsoft.com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
>
>|||Hello,
For those interested I have an answer from Microsoft regarding licenses for
Personal Edition. See below...
I understand your confusion over the statement quoted, but you are correct
in your assumption on the licensing requirements of SQL Personal Edition.
SQL PE is a component of the main SQL server itself, and the licensing is
dependent how you licence the server. If you decide to licence SQL with
CALs, for each CAL purchased you are entitled to install one copy of SQL PE.
If you go the processor route, as this allows for an unlimited number of
connections, you can install SQL PE on an unlimited number of PCs as well.
easy when you know how...
"Tibor Karaszi" wrote:

> I believe that DM should contact a sales rep as MS about this. Especially
considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licens
ed
> with a CAL or connects to servers that are properly licensed according to
the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed accord
ing to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replic
ation...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussion
s.microsoft.com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
>
>|||Thanks for posting the response. It's always best to get the official
answer from Microsoft on licensing questions.
Hope this helps.
Dan Guzman
SQL Server MVP
"DM" <DM@.discussions.microsoft.com> wrote in message
news:91581106-922D-4F43-99DC-37842F86E635@.microsoft.com...[vbcol=seagreen]
> Hello,
> For those interested I have an answer from Microsoft regarding licenses
> for
> Personal Edition. See below...
> I understand your confusion over the statement quoted, but you are correct
> in your assumption on the licensing requirements of SQL Personal Edition.
> SQL PE is a component of the main SQL server itself, and the licensing is
> dependent how you licence the server. If you decide to licence SQL with
> CALs, for each CAL purchased you are entitled to install one copy of SQL
> PE.
> If you go the processor route, as this allows for an unlimited number of
> connections, you can install SQL PE on an unlimited number of PCs as well.
> easy when you know how...
> "Tibor Karaszi" wrote:
>

Quick Licensing Question

Hello,
If I have a SQL Server set for Per Processor Licensing can I install
Personal Edition on a number of Laptops/ PC's without purchasing a license
for them? We have laptop users that travel and use a local copy of a
database. I want to move to Per Processor licensing for our main server but
an unsure if these users will fall under the per processor licensing model or
will still require a license to use Personal edition. From what I understand
they fall under per processor but I want to make sure.
Thanks for your time.The short answer is no, sorry.
Have a look at
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain
"DM" wrote:
> Hello,
> If I have a SQL Server set for Per Processor Licensing can I install
> Personal Edition on a number of Laptops/ PC's without purchasing a license
> for them? We have laptop users that travel and use a local copy of a
> database. I want to move to Per Processor licensing for our main server but
> an unsure if these users will fall under the per processor licensing model or
> will still require a license to use Personal edition. From what I understand
> they fall under per processor but I want to make sure.
> Thanks for your time.|||That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
indicates to me that PE is applicable in a Per Processor environment:
http://www.microsoft.com/sql/howtobuy/faq.asp
(Search for "Personal" in above page.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
>> Hello,
>> If I have a SQL Server set for Per Processor Licensing can I install
>> Personal Edition on a number of Laptops/ PC's without purchasing a license
>> for them? We have laptop users that travel and use a local copy of a
>> database. I want to move to Per Processor licensing for our main server but
>> an unsure if these users will fall under the per processor licensing model or
>> will still require a license to use Personal edition. From what I understand
>> they fall under per processor but I want to make sure.
>> Thanks for your time.|||Thanks for that. Big misunderstanding on my part.
"Peter 'Not Peter The Spate' Nolan" wrote:
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
> > Hello,
> >
> > If I have a SQL Server set for Per Processor Licensing can I install
> > Personal Edition on a number of Laptops/ PC's without purchasing a license
> > for them? We have laptop users that travel and use a local copy of a
> > database. I want to move to Per Processor licensing for our main server but
> > an unsure if these users will fall under the per processor licensing model or
> > will still require a license to use Personal edition. From what I understand
> > they fall under per processor but I want to make sure.
> >
> > Thanks for your time.|||I read Tibor's link and I remember reading that document a while ago and
thinking the using Per Processor would cover Personal editions. But I've no
idea what the licensing is now. Any one know for sure if Per Processing will
cover Personal Edition?
Thanks again
"Peter 'Not Peter The Spate' Nolan" wrote:
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
> > Hello,
> >
> > If I have a SQL Server set for Per Processor Licensing can I install
> > Personal Edition on a number of Laptops/ PC's without purchasing a license
> > for them? We have laptop users that travel and use a local copy of a
> > database. I want to move to Per Processor licensing for our main server but
> > an unsure if these users will fall under the per processor licensing model or
> > will still require a license to use Personal edition. From what I understand
> > they fall under per processor but I want to make sure.
> >
> > Thanks for your time.|||Thanks Tibor,
Well you learn something new every day, DM, I got the answer totally wrong
(again), Tibor, thank you for pointing it out.
Peter
"Adam and Eve had many advantages but the principal one was that they
escaped teething."
Mark Twain
Q. What type of license do I need to install and run SQL Server Personal
Edition?
A. SQL Server Personal Edition is not a separate product, but instead a
component of SQL Server that is designed to bring SQL Server functionality to
desktop applications. It can be installed and used on any Microsoft
Windowsâ'based device within an organization provided it is properly licensed
with a CAL or connects to servers that are properly licensed according to the
Per Processor licensing model.
If SQL Server Personal Edition interfaces with an instance of SQL Server,
and then distributes that data to other devices, SQL Server Personal Edition
is acting as a mutliplexer and SQL Server device CALs are required for all
devices accessing it. If you have licensed SQL Server according to the Per
Processor licensing model, you can have an unlimited number of connections to
that server, whether it is through SQL Server Personal Edition or through
direct connections.
"Tibor Karaszi" wrote:
> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
> indicates to me that PE is applicable in a Per Processor environment:
> http://www.microsoft.com/sql/howtobuy/faq.asp
> (Search for "Personal" in above page.)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> > The short answer is no, sorry.
> >
> > Have a look at
> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> >
> > Peter
> >
> > "Action speaks louder than words but not nearly as often"
> > Mark Twain
> >
> >
> > "DM" wrote:
> >
> >> Hello,
> >>
> >> If I have a SQL Server set for Per Processor Licensing can I install
> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
> >> for them? We have laptop users that travel and use a local copy of a
> >> database. I want to move to Per Processor licensing for our main server but
> >> an unsure if these users will fall under the per processor licensing model or
> >> will still require a license to use Personal edition. From what I understand
> >> they fall under per processor but I want to make sure.
> >>
> >> Thanks for your time.
>
>|||I believe that DM should contact a sales rep as MS about this. Especially considering the last part
of below sentence:
"It can be installed and used on any Microsoft
Windows-based device within an organization provided it is properly licensed
with a CAL or connects to servers that are properly licensed according to the
Per Processor licensing model."
Note:
*It* can be installed... or connects to servers.. properly licensed according to the
Per Processor...
Seems to me like PE need to connect to the server, somehow, perhaps replication...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
> Thanks Tibor,
> Well you learn something new every day, DM, I got the answer totally wrong
> (again), Tibor, thank you for pointing it out.
> Peter
> "Adam and Eve had many advantages but the principal one was that they
> escaped teething."
> Mark Twain
>
> Q. What type of license do I need to install and run SQL Server Personal
> Edition?
> A. SQL Server Personal Edition is not a separate product, but instead a
> component of SQL Server that is designed to bring SQL Server functionality to
> desktop applications. It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model.
> If SQL Server Personal Edition interfaces with an instance of SQL Server,
> and then distributes that data to other devices, SQL Server Personal Edition
> is acting as a mutliplexer and SQL Server device CALs are required for all
> devices accessing it. If you have licensed SQL Server according to the Per
> Processor licensing model, you can have an unlimited number of connections to
> that server, whether it is through SQL Server Personal Edition or through
> direct connections.
>
>
>
> "Tibor Karaszi" wrote:
>> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
>> indicates to me that PE is applicable in a Per Processor environment:
>> http://www.microsoft.com/sql/howtobuy/faq.asp
>> (Search for "Personal" in above page.)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
>> in
>> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
>> > The short answer is no, sorry.
>> >
>> > Have a look at
>> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
>> >
>> > Peter
>> >
>> > "Action speaks louder than words but not nearly as often"
>> > Mark Twain
>> >
>> >
>> > "DM" wrote:
>> >
>> >> Hello,
>> >>
>> >> If I have a SQL Server set for Per Processor Licensing can I install
>> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
>> >> for them? We have laptop users that travel and use a local copy of a
>> >> database. I want to move to Per Processor licensing for our main server but
>> >> an unsure if these users will fall under the per processor licensing model or
>> >> will still require a license to use Personal edition. From what I understand
>> >> they fall under per processor but I want to make sure.
>> >>
>> >> Thanks for your time.
>>|||I've sent an email off to Microsoft for a little clarity.
Thanks for you help.
"Tibor Karaszi" wrote:
> I believe that DM should contact a sales rep as MS about this. Especially considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed according to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replication...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
> > Thanks Tibor,
> >
> > Well you learn something new every day, DM, I got the answer totally wrong
> > (again), Tibor, thank you for pointing it out.
> >
> > Peter
> > "Adam and Eve had many advantages but the principal one was that they
> > escaped teething."
> > Mark Twain
> >
> >
> > Q. What type of license do I need to install and run SQL Server Personal
> > Edition?
> >
> > A. SQL Server Personal Edition is not a separate product, but instead a
> > component of SQL Server that is designed to bring SQL Server functionality to
> > desktop applications. It can be installed and used on any Microsoft
> > Windows-based device within an organization provided it is properly licensed
> > with a CAL or connects to servers that are properly licensed according to the
> > Per Processor licensing model.
> >
> > If SQL Server Personal Edition interfaces with an instance of SQL Server,
> > and then distributes that data to other devices, SQL Server Personal Edition
> > is acting as a mutliplexer and SQL Server device CALs are required for all
> > devices accessing it. If you have licensed SQL Server according to the Per
> > Processor licensing model, you can have an unlimited number of connections to
> > that server, whether it is through SQL Server Personal Edition or through
> > direct connections.
> >
> >
> >
> >
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
> >> indicates to me that PE is applicable in a Per Processor environment:
> >>
> >> http://www.microsoft.com/sql/howtobuy/faq.asp
> >>
> >> (Search for "Personal" in above page.)
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> http://www.sqlug.se/
> >>
> >>
> >> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
> >> in
> >> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> >> > The short answer is no, sorry.
> >> >
> >> > Have a look at
> >> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> >> >
> >> > Peter
> >> >
> >> > "Action speaks louder than words but not nearly as often"
> >> > Mark Twain
> >> >
> >> >
> >> > "DM" wrote:
> >> >
> >> >> Hello,
> >> >>
> >> >> If I have a SQL Server set for Per Processor Licensing can I install
> >> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
> >> >> for them? We have laptop users that travel and use a local copy of a
> >> >> database. I want to move to Per Processor licensing for our main server but
> >> >> an unsure if these users will fall under the per processor licensing model or
> >> >> will still require a license to use Personal edition. From what I understand
> >> >> they fall under per processor but I want to make sure.
> >> >>
> >> >> Thanks for your time.
> >>
> >>
> >>
>
>|||Hello,
For those interested I have an answer from Microsoft regarding licenses for
Personal Edition. See below...
I understand your confusion over the statement quoted, but you are correct
in your assumption on the licensing requirements of SQL Personal Edition.
SQL PE is a component of the main SQL server itself, and the licensing is
dependent how you licence the server. If you decide to licence SQL with
CALs, for each CAL purchased you are entitled to install one copy of SQL PE.
If you go the processor route, as this allows for an unlimited number of
connections, you can install SQL PE on an unlimited number of PCs as well.
easy when you know how...
"Tibor Karaszi" wrote:
> I believe that DM should contact a sales rep as MS about this. Especially considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed according to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replication...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
> > Thanks Tibor,
> >
> > Well you learn something new every day, DM, I got the answer totally wrong
> > (again), Tibor, thank you for pointing it out.
> >
> > Peter
> > "Adam and Eve had many advantages but the principal one was that they
> > escaped teething."
> > Mark Twain
> >
> >
> > Q. What type of license do I need to install and run SQL Server Personal
> > Edition?
> >
> > A. SQL Server Personal Edition is not a separate product, but instead a
> > component of SQL Server that is designed to bring SQL Server functionality to
> > desktop applications. It can be installed and used on any Microsoft
> > Windows-based device within an organization provided it is properly licensed
> > with a CAL or connects to servers that are properly licensed according to the
> > Per Processor licensing model.
> >
> > If SQL Server Personal Edition interfaces with an instance of SQL Server,
> > and then distributes that data to other devices, SQL Server Personal Edition
> > is acting as a mutliplexer and SQL Server device CALs are required for all
> > devices accessing it. If you have licensed SQL Server according to the Per
> > Processor licensing model, you can have an unlimited number of connections to
> > that server, whether it is through SQL Server Personal Edition or through
> > direct connections.
> >
> >
> >
> >
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
> >> indicates to me that PE is applicable in a Per Processor environment:
> >>
> >> http://www.microsoft.com/sql/howtobuy/faq.asp
> >>
> >> (Search for "Personal" in above page.)
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> http://www.sqlug.se/
> >>
> >>
> >> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
> >> in
> >> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> >> > The short answer is no, sorry.
> >> >
> >> > Have a look at
> >> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> >> >
> >> > Peter
> >> >
> >> > "Action speaks louder than words but not nearly as often"
> >> > Mark Twain
> >> >
> >> >
> >> > "DM" wrote:
> >> >
> >> >> Hello,
> >> >>
> >> >> If I have a SQL Server set for Per Processor Licensing can I install
> >> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
> >> >> for them? We have laptop users that travel and use a local copy of a
> >> >> database. I want to move to Per Processor licensing for our main server but
> >> >> an unsure if these users will fall under the per processor licensing model or
> >> >> will still require a license to use Personal edition. From what I understand
> >> >> they fall under per processor but I want to make sure.
> >> >>
> >> >> Thanks for your time.
> >>
> >>
> >>
>
>|||Thanks for posting the response. It's always best to get the official
answer from Microsoft on licensing questions.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"DM" <DM@.discussions.microsoft.com> wrote in message
news:91581106-922D-4F43-99DC-37842F86E635@.microsoft.com...
> Hello,
> For those interested I have an answer from Microsoft regarding licenses
> for
> Personal Edition. See below...
> I understand your confusion over the statement quoted, but you are correct
> in your assumption on the licensing requirements of SQL Personal Edition.
> SQL PE is a component of the main SQL server itself, and the licensing is
> dependent how you licence the server. If you decide to licence SQL with
> CALs, for each CAL purchased you are entitled to install one copy of SQL
> PE.
> If you go the processor route, as this allows for an unlimited number of
> connections, you can install SQL PE on an unlimited number of PCs as well.
> easy when you know how...
> "Tibor Karaszi" wrote:
>> I believe that DM should contact a sales rep as MS about this. Especially
>> considering the last part
>> of below sentence:
>> "It can be installed and used on any Microsoft
>> Windows-based device within an organization provided it is properly
>> licensed
>> with a CAL or connects to servers that are properly licensed according to
>> the
>> Per Processor licensing model."
>> Note:
>> *It* can be installed... or connects to servers.. properly licensed
>> according to the
>> Per Processor...
>> Seems to me like PE need to connect to the server, somehow, perhaps
>> replication...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter 'Not Peter The Spate' Nolan"
>> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
>> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
>> > Thanks Tibor,
>> >
>> > Well you learn something new every day, DM, I got the answer totally
>> > wrong
>> > (again), Tibor, thank you for pointing it out.
>> >
>> > Peter
>> > "Adam and Eve had many advantages but the principal one was that they
>> > escaped teething."
>> > Mark Twain
>> >
>> >
>> > Q. What type of license do I need to install and run SQL Server
>> > Personal
>> > Edition?
>> >
>> > A. SQL Server Personal Edition is not a separate product, but instead
>> > a
>> > component of SQL Server that is designed to bring SQL Server
>> > functionality to
>> > desktop applications. It can be installed and used on any Microsoft
>> > Windows-based device within an organization provided it is properly
>> > licensed
>> > with a CAL or connects to servers that are properly licensed according
>> > to the
>> > Per Processor licensing model.
>> >
>> > If SQL Server Personal Edition interfaces with an instance of SQL
>> > Server,
>> > and then distributes that data to other devices, SQL Server Personal
>> > Edition
>> > is acting as a mutliplexer and SQL Server device CALs are required for
>> > all
>> > devices accessing it. If you have licensed SQL Server according to the
>> > Per
>> > Processor licensing model, you can have an unlimited number of
>> > connections to
>> > that server, whether it is through SQL Server Personal Edition or
>> > through
>> > direct connections.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> That is not how I understand it. Can you be a bit more specific,
>> >> Peter? Below, for instance,
>> >> indicates to me that PE is applicable in a Per Processor environment:
>> >>
>> >> http://www.microsoft.com/sql/howtobuy/faq.asp
>> >>
>> >> (Search for "Personal" in above page.)
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> http://www.sqlug.se/
>> >>
>> >>
>> >> "Peter 'Not Peter The Spate' Nolan"
>> >> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
>> >> in
>> >> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
>> >> > The short answer is no, sorry.
>> >> >
>> >> > Have a look at
>> >> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
>> >> >
>> >> > Peter
>> >> >
>> >> > "Action speaks louder than words but not nearly as often"
>> >> > Mark Twain
>> >> >
>> >> >
>> >> > "DM" wrote:
>> >> >
>> >> >> Hello,
>> >> >>
>> >> >> If I have a SQL Server set for Per Processor Licensing can I
>> >> >> install
>> >> >> Personal Edition on a number of Laptops/ PC's without purchasing a
>> >> >> license
>> >> >> for them? We have laptop users that travel and use a local copy of
>> >> >> a
>> >> >> database. I want to move to Per Processor licensing for our main
>> >> >> server but
>> >> >> an unsure if these users will fall under the per processor
>> >> >> licensing model or
>> >> >> will still require a license to use Personal edition. From what I
>> >> >> understand
>> >> >> they fall under per processor but I want to make sure.
>> >> >>
>> >> >> Thanks for your time.
>> >>
>> >>
>> >>
>>

Quick Licensing Question

Hello,
If I have a SQL Server set for Per Processor Licensing can I install
Personal Edition on a number of Laptops/ PC's without purchasing a license
for them? We have laptop users that travel and use a local copy of a
database. I want to move to Per Processor licensing for our main server but
an unsure if these users will fall under the per processor licensing model or
will still require a license to use Personal edition. From what I understand
they fall under per processor but I want to make sure.
Thanks for your time.
The short answer is no, sorry.
Have a look at
http://www.microsoft.com/resources/d...rt2/c0461.mspx
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain
"DM" wrote:

> Hello,
> If I have a SQL Server set for Per Processor Licensing can I install
> Personal Edition on a number of Laptops/ PC's without purchasing a license
> for them? We have laptop users that travel and use a local copy of a
> database. I want to move to Per Processor licensing for our main server but
> an unsure if these users will fall under the per processor licensing model or
> will still require a license to use Personal edition. From what I understand
> they fall under per processor but I want to make sure.
> Thanks for your time.
|||That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
indicates to me that PE is applicable in a Per Processor environment:
http://www.microsoft.com/sql/howtobuy/faq.asp
(Search for "Personal" in above page.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft. com> wrote in
message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...[vbcol=seagreen]
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/d...rt2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
|||Thanks for that. Big misunderstanding on my part.
"Peter 'Not Peter The Spate' Nolan" wrote:
[vbcol=seagreen]
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/d...rt2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
|||I read Tibor's link and I remember reading that document a while ago and
thinking the using Per Processor would cover Personal editions. But I've no
idea what the licensing is now. Any one know for sure if Per Processing will
cover Personal Edition?
Thanks again
"Peter 'Not Peter The Spate' Nolan" wrote:
[vbcol=seagreen]
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/d...rt2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
|||Thanks Tibor,
Well you learn something new every day, DM, I got the answer totally wrong
(again), Tibor, thank you for pointing it out.
Peter
"Adam and Eve had many advantages but the principal one was that they
escaped teething."
Mark Twain
Q. What type of license do I need to install and run SQL Server Personal
Edition?
A. SQL Server Personal Edition is not a separate product, but instead a
component of SQL Server that is designed to bring SQL Server functionality to
desktop applications. It can be installed and used on any Microsoft
Windows–based device within an organization provided it is properly licensed
with a CAL or connects to servers that are properly licensed according to the
Per Processor licensing model.
If SQL Server Personal Edition interfaces with an instance of SQL Server,
and then distributes that data to other devices, SQL Server Personal Edition
is acting as a mutliplexer and SQL Server device CALs are required for all
devices accessing it. If you have licensed SQL Server according to the Per
Processor licensing model, you can have an unlimited number of connections to
that server, whether it is through SQL Server Personal Edition or through
direct connections.
"Tibor Karaszi" wrote:

> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
> indicates to me that PE is applicable in a Per Processor environment:
> http://www.microsoft.com/sql/howtobuy/faq.asp
> (Search for "Personal" in above page.)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft. com> wrote in
> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
>
>
|||I believe that DM should contact a sales rep as MS about this. Especially considering the last part
of below sentence:
"It can be installed and used on any Microsoft
Windows-based device within an organization provided it is properly licensed
with a CAL or connects to servers that are properly licensed according to the
Per Processor licensing model."
Note:
*It* can be installed... or connects to servers.. properly licensed according to the
Per Processor...
Seems to me like PE need to connect to the server, somehow, perhaps replication...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft. com> wrote in
message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor,
> Well you learn something new every day, DM, I got the answer totally wrong
> (again), Tibor, thank you for pointing it out.
> Peter
> "Adam and Eve had many advantages but the principal one was that they
> escaped teething."
> Mark Twain
>
> Q. What type of license do I need to install and run SQL Server Personal
> Edition?
> A. SQL Server Personal Edition is not a separate product, but instead a
> component of SQL Server that is designed to bring SQL Server functionality to
> desktop applications. It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model.
> If SQL Server Personal Edition interfaces with an instance of SQL Server,
> and then distributes that data to other devices, SQL Server Personal Edition
> is acting as a mutliplexer and SQL Server device CALs are required for all
> devices accessing it. If you have licensed SQL Server according to the Per
> Processor licensing model, you can have an unlimited number of connections to
> that server, whether it is through SQL Server Personal Edition or through
> direct connections.
>
>
>
> "Tibor Karaszi" wrote:
|||I've sent an email off to Microsoft for a little clarity.
Thanks for you help.
"Tibor Karaszi" wrote:

> I believe that DM should contact a sales rep as MS about this. Especially considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed according to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replication...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft. com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
>
>
|||Hello,
For those interested I have an answer from Microsoft regarding licenses for
Personal Edition. See below...
I understand your confusion over the statement quoted, but you are correct
in your assumption on the licensing requirements of SQL Personal Edition.
SQL PE is a component of the main SQL server itself, and the licensing is
dependent how you licence the server. If you decide to licence SQL with
CALs, for each CAL purchased you are entitled to install one copy of SQL PE.
If you go the processor route, as this allows for an unlimited number of
connections, you can install SQL PE on an unlimited number of PCs as well.
easy when you know how...
"Tibor Karaszi" wrote:

> I believe that DM should contact a sales rep as MS about this. Especially considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed according to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replication...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft. com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
>
>
|||Thanks for posting the response. It's always best to get the official
answer from Microsoft on licensing questions.
Hope this helps.
Dan Guzman
SQL Server MVP
"DM" <DM@.discussions.microsoft.com> wrote in message
news:91581106-922D-4F43-99DC-37842F86E635@.microsoft.com...[vbcol=seagreen]
> Hello,
> For those interested I have an answer from Microsoft regarding licenses
> for
> Personal Edition. See below...
> I understand your confusion over the statement quoted, but you are correct
> in your assumption on the licensing requirements of SQL Personal Edition.
> SQL PE is a component of the main SQL server itself, and the licensing is
> dependent how you licence the server. If you decide to licence SQL with
> CALs, for each CAL purchased you are entitled to install one copy of SQL
> PE.
> If you go the processor route, as this allows for an unlimited number of
> connections, you can install SQL PE on an unlimited number of PCs as well.
> easy when you know how...
> "Tibor Karaszi" wrote: