Wednesday, March 28, 2012
RAID FOR SQL
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en...tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en...tun_1_79pv.asp
|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>
|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> must
>
RAID FOR SQL
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_79pv.asp|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
>> Hi. I've to install a server with SQL server and a RAID system. We've
>> installed servers
>> with SQL but without RAID systems. I want to know wich is the best
>> configuration and how many disks
>> to install RAID on a server wich only has to run SQL server. The RAID,
> must
>> be only for data or for
>> data and the operating system at time?. Thanks a lot.
>>
>
RAID FOR SQL
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/e..._tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/e..._tun_1_79pv.asp|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> must
>sql
Tuesday, March 20, 2012
Quorum & MSDTC Cluster Questions
We are trying to setup a Windows Server 2003 Cluster with 2 systems and a DAV. We intend to install SQL 2005 on this Cluster. We purchased a DAV with 3 physical disk arrays as follows.
73GB RAID 1 (our plan is to use this to store sql transaction logs)
146GB RAID 1 (sql backups, temp database & other temp files)
420GB RAID 10 (sql databases)
Now as we are setting all this up we find out we need a shared physical drive on the DAV to store the Quorom. It is my understanding we cannot partition the physical drives and use one of the partitions to store the Quorum because when you create the resource for the Quorum the resource is the phsyical disk not the partition.
So my question is, is it in our best interest to buy a seperate physical disk for the Quorom?
My next question is, with regards to the MSDTC, is it in our best interest to buy a seperate physical disk for the MSDTC or can we store it on the 146GB RAID 1 and still use the drive for its original purpose?
Any guidance is much appreciated.
- Nick
It's best to have each device on its own physical device, but this isn't required. Each does have to be its own partition (drive letter), though. Here's a white paper that goes into a lot more depth:
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Buck Woody
|||Actually, the quorum does need to be in a different device than the database files, since it is part of a different cluster Resource Group. It needs to be able to fail over between the nodes independantly of the SQL service. Since the underlying SCSI protocols will attach an entire drive to one system or the other, you can't split partitions.
If your definition of DAV is the one I'm familiar with, you should verify that this storage can be used in a Windows cluster. My understanding is that clusters will only use SCSI, iSCSI, or SAN storage.
|||That's a good point - when I said that it doesn't need to be on a separate device I should have been more clear. Many times clusters are set up on a SAN configuration. In that case you do want to present a separate LUN for the quorum drive, but you can use the same SAN/HBA. The whitepaper I have referenced there should help with the layout - if not, just re-post and we'll help out where we can.
Buck
|||Thanks for your responses.
My apologies, I meant to say DAS not DAV. Sorry for the confusion.
It is a clusterable storage device that acts similarily to a SAN. We purchased it from DELL and they assured us it was certified to work in a Windows Cluster environment. Unfortunately for us we cannot split the drive arrays into multiple virtual drives. So we're stuck with 3 drive arrays and we cannot take one drive array and split it into 3 so the one drive array is presented to Windows as 3 seperate drives.
It does seem like a waste to have a seperate drive dedicated to the Quorum, especially since it only uses 4MB and the smallest HD you can find is 36GB.
What are your thoughts on Volume Mount Points? Does that work for the Quorum (or MS DTC for that matter)?
What about the MS DTC ? Does it need a seperate physical disk like the Quorum or can it be placed on drive with other minor usage?
Thanks again.
- Nick
|||When I set up clustering we had this kind of layout:
C Drive: Physical, Local RAID 1, OS and Binaries
Q Drive: Physical, Local RAID 1, Quorum (yes, we cheated and put a few other things on here. But not much, and nothing that we let users get to)
S Drive: LUN, SAN, Shared DB Databases
L Drive: LUN, SAN, Shared DB Logs
I view this as the mininum, with other sets defined like S for high read/write activities and filegroups
Buck
|||
Thanks for your responses again.
Where did you place the MS DTC physical disk required by the SQL Cluster?
If you have a Cluster of 2 or more systems doesn't the Quorum drive have to be on a shared drive not local?
Thanks!
- Nick
|||The issue isn't usage or volume of data. The issue is that the storage must be able to move from node to node independantly of any other resource group.
So, if you put MSDTC and the quorum on the same physical drive (even in separate partitions), then if you moved the cluster service from node A to node B, MSDTC would die because its disk would disappear out from under it. Worse, if MSDTC failed and took the disk offline, the cluster service would die.
For those reasons, MSCS won't let you configure two resource groups that depend on the same physical drive.
Can you give the model of the Dell array? That sounds interesting, and I'd like to read up on it. From your description, each array forms one virtual drive, but can't be divided into LUNs? That seems strange. With a device where you can form virtual disks (LUNs), you can set up a very small LUN for Quorum.
|||Kevin
The DAS is a Dell PowerVault 220S DAS. Click here for more info.
The 2 servers we're setting this up on are "Dell 2950's running Server 2003 and SQL 2005".
We were going to arrange the drives like this:
On board *each* Dell PE2950:
(2) 73GB drives mirrored w/RAID 1 holding OS, Apps (C:) and Win Swap files (G:)
On DAS (220S):
Virtual Disk 0 - (2) 73GB drives mirrored w/RAID 1 for SQL Transaction Log files (D:)
Virtual Disk 1 - (2) 146 GB drives mirrored w/RAID 1 for a variety of temp jobs, SQL temp files, etc.(E:)
Virtual Disk 2 - (6) 146 GB drives mirrored and striped w/RAID 10 for the SQL database (F:)
We can't slice the paired drive sets using the SCSI controller as DELL disables 'slicing' virtual drives (sets) when you are in cluster config.
Thanks for your curiousity Kevin!
- Nick
|||We're purchasing a 4th drive array for the DAS for the Quorum to reside. That said would it be wise to setup the clustering like this:
[Cluster Group]
Cluster IP Address
Cluster Name
SQL Network Name
SQL IP Address
SQL Server (With dependencies of Disk D:, E: & F:)
DTC Network Name
DTC IP Address
DTC Service (With dependencies of Disk E:)
Disk D: (Shared Drive, SQL Transaction Logs)
Disk E: (Shared Drive, SQL Temp Files, MS DTC)
Disk F: (Shared Drive, SQL Databases)
Disk Q: (Quorum)
I think this looks good to me - you've got a C drive for local, obviously, so I'm assuming that's local to the system and a RAID 1 or similar.
Buck
|||Almost.
Each Resource Group must be independant and not depend on any resource in any other group.
I'd lay it out as:
[Cluster Group]
Cluster IP Address
Cluster Name
Disk Q: (Quorum)
[SQL Group]
SQL Network Name
SQL IP Address
SQL Server (With dependencies of Disk D:, E: & F:)
Disk D: (Shared Drive, SQL Transaction Logs)
Disk E: (Shared Drive, SQL Temp Files)
Disk F: (Shared Drive, SQL Databases)
[DTC Group]
DTC Network Name
DTC IP Address
DTC Service (With dependencies of Disk G:)
Disk G:(DTC)
You could possibly combine SQL and DTC, but ideally they should be separate.
quistion about sqlserver
do you recommend me to install exchange server with sql
server?
please tell me .
best regards
soheila zolfaghari> do you recommend me to install exchange server with sql
> server?
Both servers (Exchange and SQL Server) are memory-intensive, so you should
double check your current or estimated memory needs for your environment and
configure an upper limit for SQL Server manually. They will also compete for
CPU and I/O.
If you plan for previous versions of Exchange and SQL Server, SQL Server 7.0
and Exchange 5.5You must explicitly configure memory usage in SQL Server if
you run both a SQL Server 7.0 and a Microsoft Exchange version 5.5 server on
the same computer. SQL Server will not operate properly if you leave the SQL
Server minimum dynamic memory option set at the default value of 0.
I addition to this, I am not a fan of installing SQL Server together with
anything else, but on a tight budget and in a small environment, there are
no big obstacles for such configuration AFAIK.
sincerely,
--
your Software Submit.NET Team
http://www.softwaresubmit.net
mailto:info@.softwaresubmit.net
quistion about sqlserver
do you recommend me to install exchange server with sql
server?
please tell me .
best regards
soheila zolfaghari> do you recommend me to install exchange server with sql
> server?
Both servers (Exchange and SQL Server) are memory-intensive, so you should
double check your current or estimated memory needs for your environment and
configure an upper limit for SQL Server manually. They will also compete for
CPU and I/O.
If you plan for previous versions of Exchange and SQL Server, SQL Server 7.0
and Exchange 5.5You must explicitly configure memory usage in SQL Server if
you run both a SQL Server 7.0 and a Microsoft Exchange version 5.5 server on
the same computer. SQL Server will not operate properly if you leave the SQL
Server minimum dynamic memory option set at the default value of 0.
I addition to this, I am not a fan of installing SQL Server together with
anything else, but on a tight budget and in a small environment, there are
no big obstacles for such configuration AFAIK.
sincerely,
--
your Software Submit.NET Team
http://www.softwaresubmit.net
mailto:info@.softwaresubmit.net
Quiescing Replication
to Server B and vice versa. From what I understand (but correct me if I'm
wrong), I'll need to "Quiesce" the servers and install the service packs
simultaneously. But what does that mean. I looked at a KB article, but
didn't really understand when it said stop all activity on published tables.
Does that mean the agent jobs? or does that mean to make sure noone
accesses the database from the application?
Thanks!
It means boot all your users off the box.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sandra" <skong@.ap.org> wrote in message
news:OpfU9j7OGHA.740@.TK2MSFTNGP12.phx.gbl...
>I need to install a service pack on replicated servers. Server A
>replicates to Server B and vice versa. From what I understand (but correct
>me if I'm wrong), I'll need to "Quiesce" the servers and install the
>service packs simultaneously. But what does that mean. I looked at a KB
>article, but didn't really understand when it said stop all activity on
>published tables. Does that mean the agent jobs? or does that mean to make
>sure noone accesses the database from the application?
> Thanks!
>
|||Sandra,
you can use this type of statement to get the databases into a correct
state:
alter database mydb set single_user with rollback immediate.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Wednesday, March 7, 2012
Quick Licensing Question
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.
>> >>
>> >>
>> >>
>>
Saturday, February 25, 2012
quick and easy install question
where to find the install file? Is it on the SQL Server Enterprise cd? Is
it on its own cd?
Thanks,
KeithOn its own CD, which you need to find somewhere. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Keith" <Keith@.noemail.com> wrote in message
news:eMJuLpEDEHA.3348@.TK2MSFTNGP11.phx.gbl...
> I would like to install SQL Server 2000 Personal Edition, but I don't know
> where to find the install file? Is it on the SQL Server Enterprise cd?
Is
> it on its own cd?
> Thanks,
> Keith
>