I have a database server that has is acting very sluggish. Using the performance monitor, I can see that disk use is steadily at 100% usage.
The system is so overburdened that attempting to do even basic tasks (open folders, look in Enterprise Manager, get screen repaints) has become impractical.
Even if I could get to the Enterprise Manager "Process Info" display, what would I look for to tell me what is wrong?From a remote PC, use Profiler to monitor all queries with over say 1000 reads. Copy those queries out to Query Analyzer, and see if you can get some indexes on the underlying tables to speed them up.
Another thing to check is how much memory is in the box? SQL Server will default to taking all it wants, but if you have only 64MB in your box, then you are in for a world-o-hurt.|||Originally posted by MCrowley
From a remote PC, use Profiler to monitor all queries with over say 1000 reads.
How do I do this? What is Profiler?
thanks for the feedback!|||Originally posted by RogerWilco
How do I do this? What is Profiler?
thanks for the feedback!
Found it. This is definitely helping.
Thankfully, we just hired a real DBA who starts Thursday.
Thanks again!
Showing posts with label usage. Show all posts
Showing posts with label usage. Show all posts
Friday, March 9, 2012
Diagnosing Memory Problems?
I am consistantly getting Physical Memory Usage High errors. My Buffer Cache
is running at 99% and the Server Memory is at 87%. Any thoughts on what's c
ausing this?I am consistantly getting Physical Memory Usage High errors. My Buffer Cache
is running at 99% and the Server Memory is at 87%. Any thoughts on what's c
ausing this?
is running at 99% and the Server Memory is at 87%. Any thoughts on what's c
ausing this?I am consistantly getting Physical Memory Usage High errors. My Buffer Cache
is running at 99% and the Server Memory is at 87%. Any thoughts on what's c
ausing this?
Wednesday, March 7, 2012
devenv.exe hangs up with alomost 100% cpu usage
For some reason my visual studio with SSIS project hangs up with almost 100% cpu usage sometimes immediately after opening the studio.
Any resolution?
Thanks
I'm having the same problem and it is driving me nuts! I do a lot of BI work and this has disrupted my project timelines significantly.
As best as I can tell. it seems to have start after applying a patch to the .NET framework 2.0. The patch is defined in the KB922770. I'm not sure if this is the culprit by itself or if there are others factors re-enforcing the problem.
Let me know if you come up with a resolution.
Thanks, Darryl
darryl_jewett@.msn.com
|||We were able to reduce the occurrence of hangup by 90% with two settings... particulary with the first one.
1. Project property -> Configuration Manger - > Build = UNCHECK (This gets checked mysteriously even though we Uncheck and save in TFS - so we verify for this setting frequently when we open the project). If it is checked - all packages in the project are built/compiled irrespective of package you are working on and if there are 100's of packages - compiling all of them takes hell of time.
2. Tools->Options->Environment->AutoRecovery - Save autorecovery information... = UNCHECK. (I did this bz I saw in the status bar of VS the message: Saving autorecovery details.. when it gets stuck)
Hope it helps you as well (if above setting are not important to you ).
But the problem has not gone altogether.... it still hangs up once in a while.
Thanks
Sunday, February 19, 2012
Developer Edition
Hi All,
I have a question regarding the usage of SQL Server 2005 Developer Edition.
Can I use it in a client - server architecture say I install Developer
edition on a server and install client tools(Management studio / profiler)
on desktops and acess as we use Enterprise Edition? The purpose is only
Development (no production work). I am asking this because ours is a small
Organization with major work is done on SQL Server 2000. Only 1 team is
gonna use 2005.
Thanks,
PradThe license for Developer Edition allows you to install the client tools on
any development computer you desire, and to have as many SQL Servers
installed as you might need, for example, a dev server, a test server, a QA
server, etc.
However, each person (developer or tester -or whoever) accessing the servers
covered with the Developer Edition license MUST have a proper license. (I
think that is currently about $50 (US) each.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question regarding the usage of SQL Server 2005 Developer
> Edition.
> Can I use it in a client - server architecture say I install Developer
> edition on a server and install client tools(Management studio / profiler)
> on desktops and acess as we use Enterprise Edition? The purpose is only
> Development (no production work). I am asking this because ours is a small
> Organization with major work is done on SQL Server 2000. Only 1 team is
> gonna use 2005.
> Thanks,
> Prad
>|||Arnie,
Thanks for replying soon.
I know that we can install Dev Edn on Desktops as you said.
My doubt is whether I can install it on only one server and the
clients(desktop mc/) access it. So that I need to update (run build) only on
the Server rather than updating every m/c.
If not possible, I will have to go for Standard Edn right? Hope you
understud my requirement.
Thanks,
Prad
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
> The license for Developer Edition allows you to install the client tools
> on any development computer you desire, and to have as many SQL Servers
> installed as you might need, for example, a dev server, a test server, a
> QA server, etc.
> However, each person (developer or tester -or whoever) accessing the
> servers covered with the Developer Edition license MUST have a proper
> license. (I think that is currently about $50 (US) each.)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>|||You can install SQL Server Developer Edition on any computer you desire. You
can install it on one or more servers to be accessed by other computers
acting as clients.
Each client that accesses the Developer Edition MUST have a Developer
Edition license. (And of course, they must properly qualify for the
Developer Edition license.)
No Cost for one or more Servers, Developer Edition license for each client
(user).
AS long as ALL the usage qualifies for the Developer Edition license.
Licensing -Developer Edition
My understanding of the Developers Edition license is that you are covered
for a Development server, an Integration/Staging server, even a QA/Test
server, local servers on the developers computer, etc. -as long as no one
except developers access those SQL Servers, and as long as each developer
and/or Tester has a Developer Edition License.
For a more definitive answer, check with the VL folks at: (800) 426-9400.
From: http://www.microsoft.com/sql/editio...er/default.mspx
Each license of SQL Server 2005 Developer Edition entitles one developer to
use the software on as many systems as necessary and additional developers
can use the software by purchasing additional licenses.
From:
http://download.microsoft.com/downl...censingv1.1.doc
DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for
development and testing purposes only. It is licensed per developer or
tester (person).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
> Arnie,
> Thanks for replying soon.
> I know that we can install Dev Edn on Desktops as you said.
> My doubt is whether I can install it on only one server and the
> clients(desktop mc/) access it. So that I need to update (run build) only
> on the Server rather than updating every m/c.
> If not possible, I will have to go for Standard Edn right? Hope you
> understud my requirement.
> Thanks,
> Prad
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>|||Thanks a lot. Ive got my doubt cleared...
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eyyhfLZ%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> You can install SQL Server Developer Edition on any computer you desire.
> You can install it on one or more servers to be accessed by other
> computers acting as clients.
> Each client that accesses the Developer Edition MUST have a Developer
> Edition license. (And of course, they must properly qualify for the
> Developer Edition license.)
> No Cost for one or more Servers, Developer Edition license for each client
> (user).
> AS long as ALL the usage qualifies for the Developer Edition license.
> Licensing -Developer Edition
> My understanding of the Developers Edition license is that you are covered
> for a Development server, an Integration/Staging server, even a QA/Test
> server, local servers on the developers computer, etc. -as long as no one
> except developers access those SQL Servers, and as long as each developer
> and/or Tester has a Developer Edition License.
> For a more definitive answer, check with the VL folks at: (800) 426-9400.
> From: http://www.microsoft.com/sql/editio...er/default.mspx
> Each license of SQL Server 2005 Developer Edition entitles one developer
> to
> use the software on as many systems as necessary and additional developers
> can use the software by purchasing additional licenses.
> From:
> http://download.microsoft.com/downl...censingv1.1.doc
> DEVELOPER EDITION
> SQL Server Developer Edition is a separate product and is used for
> development and testing purposes only. It is licensed per developer or
> tester (person).
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
>
I have a question regarding the usage of SQL Server 2005 Developer Edition.
Can I use it in a client - server architecture say I install Developer
edition on a server and install client tools(Management studio / profiler)
on desktops and acess as we use Enterprise Edition? The purpose is only
Development (no production work). I am asking this because ours is a small
Organization with major work is done on SQL Server 2000. Only 1 team is
gonna use 2005.
Thanks,
PradThe license for Developer Edition allows you to install the client tools on
any development computer you desire, and to have as many SQL Servers
installed as you might need, for example, a dev server, a test server, a QA
server, etc.
However, each person (developer or tester -or whoever) accessing the servers
covered with the Developer Edition license MUST have a proper license. (I
think that is currently about $50 (US) each.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question regarding the usage of SQL Server 2005 Developer
> Edition.
> Can I use it in a client - server architecture say I install Developer
> edition on a server and install client tools(Management studio / profiler)
> on desktops and acess as we use Enterprise Edition? The purpose is only
> Development (no production work). I am asking this because ours is a small
> Organization with major work is done on SQL Server 2000. Only 1 team is
> gonna use 2005.
> Thanks,
> Prad
>|||Arnie,
Thanks for replying soon.
I know that we can install Dev Edn on Desktops as you said.
My doubt is whether I can install it on only one server and the
clients(desktop mc/) access it. So that I need to update (run build) only on
the Server rather than updating every m/c.
If not possible, I will have to go for Standard Edn right? Hope you
understud my requirement.
Thanks,
Prad
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
> The license for Developer Edition allows you to install the client tools
> on any development computer you desire, and to have as many SQL Servers
> installed as you might need, for example, a dev server, a test server, a
> QA server, etc.
> However, each person (developer or tester -or whoever) accessing the
> servers covered with the Developer Edition license MUST have a proper
> license. (I think that is currently about $50 (US) each.)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>|||You can install SQL Server Developer Edition on any computer you desire. You
can install it on one or more servers to be accessed by other computers
acting as clients.
Each client that accesses the Developer Edition MUST have a Developer
Edition license. (And of course, they must properly qualify for the
Developer Edition license.)
No Cost for one or more Servers, Developer Edition license for each client
(user).
AS long as ALL the usage qualifies for the Developer Edition license.
Licensing -Developer Edition
My understanding of the Developers Edition license is that you are covered
for a Development server, an Integration/Staging server, even a QA/Test
server, local servers on the developers computer, etc. -as long as no one
except developers access those SQL Servers, and as long as each developer
and/or Tester has a Developer Edition License.
For a more definitive answer, check with the VL folks at: (800) 426-9400.
From: http://www.microsoft.com/sql/editio...er/default.mspx
Each license of SQL Server 2005 Developer Edition entitles one developer to
use the software on as many systems as necessary and additional developers
can use the software by purchasing additional licenses.
From:
http://download.microsoft.com/downl...censingv1.1.doc
DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for
development and testing purposes only. It is licensed per developer or
tester (person).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
> Arnie,
> Thanks for replying soon.
> I know that we can install Dev Edn on Desktops as you said.
> My doubt is whether I can install it on only one server and the
> clients(desktop mc/) access it. So that I need to update (run build) only
> on the Server rather than updating every m/c.
> If not possible, I will have to go for Standard Edn right? Hope you
> understud my requirement.
> Thanks,
> Prad
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>|||Thanks a lot. Ive got my doubt cleared...
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eyyhfLZ%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> You can install SQL Server Developer Edition on any computer you desire.
> You can install it on one or more servers to be accessed by other
> computers acting as clients.
> Each client that accesses the Developer Edition MUST have a Developer
> Edition license. (And of course, they must properly qualify for the
> Developer Edition license.)
> No Cost for one or more Servers, Developer Edition license for each client
> (user).
> AS long as ALL the usage qualifies for the Developer Edition license.
> Licensing -Developer Edition
> My understanding of the Developers Edition license is that you are covered
> for a Development server, an Integration/Staging server, even a QA/Test
> server, local servers on the developers computer, etc. -as long as no one
> except developers access those SQL Servers, and as long as each developer
> and/or Tester has a Developer Edition License.
> For a more definitive answer, check with the VL folks at: (800) 426-9400.
> From: http://www.microsoft.com/sql/editio...er/default.mspx
> Each license of SQL Server 2005 Developer Edition entitles one developer
> to
> use the software on as many systems as necessary and additional developers
> can use the software by purchasing additional licenses.
> From:
> http://download.microsoft.com/downl...censingv1.1.doc
> DEVELOPER EDITION
> SQL Server Developer Edition is a separate product and is used for
> development and testing purposes only. It is licensed per developer or
> tester (person).
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
>
Developer Edition
Hi All,
I have a question regarding the usage of SQL Server 2005 Developer Edition.
Can I use it in a client - server architecture say I install Developer
edition on a server and install client tools(Management studio / profiler)
on desktops and acess as we use Enterprise Edition? The purpose is only
Development (no production work). I am asking this because ours is a small
Organization with major work is done on SQL Server 2000. Only 1 team is
gonna use 2005.
Thanks,
PradThe license for Developer Edition allows you to install the client tools on
any development computer you desire, and to have as many SQL Servers
installed as you might need, for example, a dev server, a test server, a QA
server, etc.
However, each person (developer or tester -or whoever) accessing the servers
covered with the Developer Edition license MUST have a proper license. (I
think that is currently about $50 (US) each.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question regarding the usage of SQL Server 2005 Developer
> Edition.
> Can I use it in a client - server architecture say I install Developer
> edition on a server and install client tools(Management studio / profiler)
> on desktops and acess as we use Enterprise Edition? The purpose is only
> Development (no production work). I am asking this because ours is a small
> Organization with major work is done on SQL Server 2000. Only 1 team is
> gonna use 2005.
> Thanks,
> Prad
>|||Arnie,
Thanks for replying soon.
I know that we can install Dev Edn on Desktops as you said.
My doubt is whether I can install it on only one server and the
clients(desktop mc/) access it. So that I need to update (run build) only on
the Server rather than updating every m/c.
If not possible, I will have to go for Standard Edn right? Hope you
understud my requirement.
Thanks,
Prad
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
> The license for Developer Edition allows you to install the client tools
> on any development computer you desire, and to have as many SQL Servers
> installed as you might need, for example, a dev server, a test server, a
> QA server, etc.
> However, each person (developer or tester -or whoever) accessing the
> servers covered with the Developer Edition license MUST have a proper
> license. (I think that is currently about $50 (US) each.)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The purpose
>> is only Development (no production work). I am asking this because ours
>> is a small Organization with major work is done on SQL Server 2000. Only
>> 1 team is gonna use 2005.
>> Thanks,
>> Prad
>|||You can install SQL Server Developer Edition on any computer you desire. You
can install it on one or more servers to be accessed by other computers
acting as clients.
Each client that accesses the Developer Edition MUST have a Developer
Edition license. (And of course, they must properly qualify for the
Developer Edition license.)
No Cost for one or more Servers, Developer Edition license for each client
(user).
AS long as ALL the usage qualifies for the Developer Edition license.
Licensing -Developer Edition
My understanding of the Developers Edition license is that you are covered
for a Development server, an Integration/Staging server, even a QA/Test
server, local servers on the developers computer, etc. -as long as no one
except developers access those SQL Servers, and as long as each developer
and/or Tester has a Developer Edition License.
For a more definitive answer, check with the VL folks at: (800) 426-9400.
From: http://www.microsoft.com/sql/editions/developer/default.mspx
Each license of SQL Server 2005 Developer Edition entitles one developer to
use the software on as many systems as necessary and additional developers
can use the software by purchasing additional licenses.
From:
http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for
development and testing purposes only. It is licensed per developer or
tester (person).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
> Arnie,
> Thanks for replying soon.
> I know that we can install Dev Edn on Desktops as you said.
> My doubt is whether I can install it on only one server and the
> clients(desktop mc/) access it. So that I need to update (run build) only
> on the Server rather than updating every m/c.
> If not possible, I will have to go for Standard Edn right? Hope you
> understud my requirement.
> Thanks,
> Prad
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>> The license for Developer Edition allows you to install the client tools
>> on any development computer you desire, and to have as many SQL Servers
>> installed as you might need, for example, a dev server, a test server, a
>> QA server, etc.
>> However, each person (developer or tester -or whoever) accessing the
>> servers covered with the Developer Edition license MUST have a proper
>> license. (I think that is currently about $50 (US) each.)
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Prad" <pradeepk@.healthasyst.com> wrote in message
>> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The
>> purpose is only Development (no production work). I am asking this
>> because ours is a small Organization with major work is done on SQL
>> Server 2000. Only 1 team is gonna use 2005.
>> Thanks,
>> Prad
>>
>|||Thanks a lot. Ive got my doubt cleared...
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eyyhfLZ%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> You can install SQL Server Developer Edition on any computer you desire.
> You can install it on one or more servers to be accessed by other
> computers acting as clients.
> Each client that accesses the Developer Edition MUST have a Developer
> Edition license. (And of course, they must properly qualify for the
> Developer Edition license.)
> No Cost for one or more Servers, Developer Edition license for each client
> (user).
> AS long as ALL the usage qualifies for the Developer Edition license.
> Licensing -Developer Edition
> My understanding of the Developers Edition license is that you are covered
> for a Development server, an Integration/Staging server, even a QA/Test
> server, local servers on the developers computer, etc. -as long as no one
> except developers access those SQL Servers, and as long as each developer
> and/or Tester has a Developer Edition License.
> For a more definitive answer, check with the VL folks at: (800) 426-9400.
> From: http://www.microsoft.com/sql/editions/developer/default.mspx
> Each license of SQL Server 2005 Developer Edition entitles one developer
> to
> use the software on as many systems as necessary and additional developers
> can use the software by purchasing additional licenses.
> From:
> http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
> DEVELOPER EDITION
> SQL Server Developer Edition is a separate product and is used for
> development and testing purposes only. It is licensed per developer or
> tester (person).
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
>> Arnie,
>> Thanks for replying soon.
>> I know that we can install Dev Edn on Desktops as you said.
>> My doubt is whether I can install it on only one server and the
>> clients(desktop mc/) access it. So that I need to update (run build) only
>> on the Server rather than updating every m/c.
>> If not possible, I will have to go for Standard Edn right? Hope you
>> understud my requirement.
>> Thanks,
>> Prad
>> "Arnie Rowland" <arnie@.1568.com> wrote in message
>> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>> The license for Developer Edition allows you to install the client tools
>> on any development computer you desire, and to have as many SQL Servers
>> installed as you might need, for example, a dev server, a test server, a
>> QA server, etc.
>> However, each person (developer or tester -or whoever) accessing the
>> servers covered with the Developer Edition license MUST have a proper
>> license. (I think that is currently about $50 (US) each.)
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Prad" <pradeepk@.healthasyst.com> wrote in message
>> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The
>> purpose is only Development (no production work). I am asking this
>> because ours is a small Organization with major work is done on SQL
>> Server 2000. Only 1 team is gonna use 2005.
>> Thanks,
>> Prad
>>
>>
>
I have a question regarding the usage of SQL Server 2005 Developer Edition.
Can I use it in a client - server architecture say I install Developer
edition on a server and install client tools(Management studio / profiler)
on desktops and acess as we use Enterprise Edition? The purpose is only
Development (no production work). I am asking this because ours is a small
Organization with major work is done on SQL Server 2000. Only 1 team is
gonna use 2005.
Thanks,
PradThe license for Developer Edition allows you to install the client tools on
any development computer you desire, and to have as many SQL Servers
installed as you might need, for example, a dev server, a test server, a QA
server, etc.
However, each person (developer or tester -or whoever) accessing the servers
covered with the Developer Edition license MUST have a proper license. (I
think that is currently about $50 (US) each.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question regarding the usage of SQL Server 2005 Developer
> Edition.
> Can I use it in a client - server architecture say I install Developer
> edition on a server and install client tools(Management studio / profiler)
> on desktops and acess as we use Enterprise Edition? The purpose is only
> Development (no production work). I am asking this because ours is a small
> Organization with major work is done on SQL Server 2000. Only 1 team is
> gonna use 2005.
> Thanks,
> Prad
>|||Arnie,
Thanks for replying soon.
I know that we can install Dev Edn on Desktops as you said.
My doubt is whether I can install it on only one server and the
clients(desktop mc/) access it. So that I need to update (run build) only on
the Server rather than updating every m/c.
If not possible, I will have to go for Standard Edn right? Hope you
understud my requirement.
Thanks,
Prad
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
> The license for Developer Edition allows you to install the client tools
> on any development computer you desire, and to have as many SQL Servers
> installed as you might need, for example, a dev server, a test server, a
> QA server, etc.
> However, each person (developer or tester -or whoever) accessing the
> servers covered with the Developer Edition license MUST have a proper
> license. (I think that is currently about $50 (US) each.)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The purpose
>> is only Development (no production work). I am asking this because ours
>> is a small Organization with major work is done on SQL Server 2000. Only
>> 1 team is gonna use 2005.
>> Thanks,
>> Prad
>|||You can install SQL Server Developer Edition on any computer you desire. You
can install it on one or more servers to be accessed by other computers
acting as clients.
Each client that accesses the Developer Edition MUST have a Developer
Edition license. (And of course, they must properly qualify for the
Developer Edition license.)
No Cost for one or more Servers, Developer Edition license for each client
(user).
AS long as ALL the usage qualifies for the Developer Edition license.
Licensing -Developer Edition
My understanding of the Developers Edition license is that you are covered
for a Development server, an Integration/Staging server, even a QA/Test
server, local servers on the developers computer, etc. -as long as no one
except developers access those SQL Servers, and as long as each developer
and/or Tester has a Developer Edition License.
For a more definitive answer, check with the VL folks at: (800) 426-9400.
From: http://www.microsoft.com/sql/editions/developer/default.mspx
Each license of SQL Server 2005 Developer Edition entitles one developer to
use the software on as many systems as necessary and additional developers
can use the software by purchasing additional licenses.
From:
http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for
development and testing purposes only. It is licensed per developer or
tester (person).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Prad" <pradeepk@.healthasyst.com> wrote in message
news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
> Arnie,
> Thanks for replying soon.
> I know that we can install Dev Edn on Desktops as you said.
> My doubt is whether I can install it on only one server and the
> clients(desktop mc/) access it. So that I need to update (run build) only
> on the Server rather than updating every m/c.
> If not possible, I will have to go for Standard Edn right? Hope you
> understud my requirement.
> Thanks,
> Prad
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>> The license for Developer Edition allows you to install the client tools
>> on any development computer you desire, and to have as many SQL Servers
>> installed as you might need, for example, a dev server, a test server, a
>> QA server, etc.
>> However, each person (developer or tester -or whoever) accessing the
>> servers covered with the Developer Edition license MUST have a proper
>> license. (I think that is currently about $50 (US) each.)
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Prad" <pradeepk@.healthasyst.com> wrote in message
>> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The
>> purpose is only Development (no production work). I am asking this
>> because ours is a small Organization with major work is done on SQL
>> Server 2000. Only 1 team is gonna use 2005.
>> Thanks,
>> Prad
>>
>|||Thanks a lot. Ive got my doubt cleared...
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eyyhfLZ%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> You can install SQL Server Developer Edition on any computer you desire.
> You can install it on one or more servers to be accessed by other
> computers acting as clients.
> Each client that accesses the Developer Edition MUST have a Developer
> Edition license. (And of course, they must properly qualify for the
> Developer Edition license.)
> No Cost for one or more Servers, Developer Edition license for each client
> (user).
> AS long as ALL the usage qualifies for the Developer Edition license.
> Licensing -Developer Edition
> My understanding of the Developers Edition license is that you are covered
> for a Development server, an Integration/Staging server, even a QA/Test
> server, local servers on the developers computer, etc. -as long as no one
> except developers access those SQL Servers, and as long as each developer
> and/or Tester has a Developer Edition License.
> For a more definitive answer, check with the VL folks at: (800) 426-9400.
> From: http://www.microsoft.com/sql/editions/developer/default.mspx
> Each license of SQL Server 2005 Developer Edition entitles one developer
> to
> use the software on as many systems as necessary and additional developers
> can use the software by purchasing additional licenses.
> From:
> http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
> DEVELOPER EDITION
> SQL Server Developer Edition is a separate product and is used for
> development and testing purposes only. It is licensed per developer or
> tester (person).
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Prad" <pradeepk@.healthasyst.com> wrote in message
> news:OA6SOtY%23GHA.4888@.TK2MSFTNGP04.phx.gbl...
>> Arnie,
>> Thanks for replying soon.
>> I know that we can install Dev Edn on Desktops as you said.
>> My doubt is whether I can install it on only one server and the
>> clients(desktop mc/) access it. So that I need to update (run build) only
>> on the Server rather than updating every m/c.
>> If not possible, I will have to go for Standard Edn right? Hope you
>> understud my requirement.
>> Thanks,
>> Prad
>> "Arnie Rowland" <arnie@.1568.com> wrote in message
>> news:eywEjVY%23GHA.3348@.TK2MSFTNGP03.phx.gbl...
>> The license for Developer Edition allows you to install the client tools
>> on any development computer you desire, and to have as many SQL Servers
>> installed as you might need, for example, a dev server, a test server, a
>> QA server, etc.
>> However, each person (developer or tester -or whoever) accessing the
>> servers covered with the Developer Edition license MUST have a proper
>> license. (I think that is currently about $50 (US) each.)
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Prad" <pradeepk@.healthasyst.com> wrote in message
>> news:%239TXiSY%23GHA.4320@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a question regarding the usage of SQL Server 2005 Developer
>> Edition.
>> Can I use it in a client - server architecture say I install Developer
>> edition on a server and install client tools(Management studio /
>> profiler) on desktops and acess as we use Enterprise Edition? The
>> purpose is only Development (no production work). I am asking this
>> because ours is a small Organization with major work is done on SQL
>> Server 2000. Only 1 team is gonna use 2005.
>> Thanks,
>> Prad
>>
>>
>
Subscribe to:
Posts (Atom)