Procedure Time out: install

Showing posts with label install. Show all posts

Friday, March 30, 2012

Profiler and SQL Express

I'm just wondering if I install SQL Express + Express Manger will this
include SQL Server profiler ?
If not is there any way to get SQL Server profiler without purchase a
complete version of SQL Server 2005 Standared or Entreprise editions ?
Thank you"SM" <sauvemark@.yahoo.com> wrote in message
news:%23fGkDyH8FHA.956@.TK2MSFTNGP10.phx.gbl...
> I'm just wondering if I install SQL Express + Express Manger will this
> include SQL Server profiler ?
> If not is there any way to get SQL Server profiler without purchase a
> complete version of SQL Server 2005 Standared or Entreprise editions ?
>
For development and testing purposes you can use SQL Server Developer
Edition which has the full compliment of tools.
David|||SQL Express Edition does not ship with SQL Profiler.
In order to use Profiler you need to have a license of SQL Server 2005.
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT Community Leader]
SQL Server Technologist
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"SM" <sauvemark@.yahoo.com> wrote in message
news:%23fGkDyH8FHA.956@.TK2MSFTNGP10.phx.gbl...
> I'm just wondering if I install SQL Express + Express Manger will this
> include SQL Server profiler ?
> If not is there any way to get SQL Server profiler without purchase a
> complete version of SQL Server 2005 Standared or Entreprise editions ?
> Thank you
>

Monday, March 26, 2012

Product error installs

I have a couple third part applications that I'm trying to install that
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:
> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.|||Yes
"Brad Feaker" wrote:
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
> > I have a couple third part applications that I'm trying to install that
> > install SQL databases. However I get similar errors during both for the
> > install.
> >
> > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > name again.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > (NULL), (NULL), (NULL).
> >
> >
> > I've talked to a couple other users and they haven't experienced the same
> > issues. My server is set to mixed mode and the SA account does have a
> > password. I've tried installing using the SA account as well as a domain
> > admin account and neither worked.|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
> Yes
> "Brad Feaker" wrote:
> > Is the NT account you are using to install a member of the local server
> > Administrator group?
> >
> > Brad Feaker
> > Ex nihilo, nihil fit
> >
> > "Mike" wrote:
> >
> > > I have a couple third part applications that I'm trying to install that
> > > install SQL databases. However I get similar errors during both for the
> > > install.
> > >
> > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > name again.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > (NULL), (NULL), (NULL).
> > >
> > >
> > > I've talked to a couple other users and they haven't experienced the same
> > > issues. My server is set to mixed mode and the SA account does have a
> > > password. I've tried installing using the SA account as well as a domain
> > > admin account and neither worked.|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
> > Yes
> >
> > "Brad Feaker" wrote:
> >
> > > Is the NT account you are using to install a member of the local server
> > > Administrator group?
> > >
> > > Brad Feaker
> > > Ex nihilo, nihil fit
> > >
> > > "Mike" wrote:
> > >
> > > > I have a couple third part applications that I'm trying to install that
> > > > install SQL databases. However I get similar errors during both for the
> > > > install.
> > > >
> > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > name again.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > (NULL), (NULL), (NULL).
> > > >
> > > >
> > > > I've talked to a couple other users and they haven't experienced the same
> > > > issues. My server is set to mixed mode and the SA account does have a
> > > > password. I've tried installing using the SA account as well as a domain
> > > > admin account and neither worked.|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
> > Try installing using a local system account and then changing the service
> > accounts after the install is complete.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Yes
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Is the NT account you are using to install a member of the local server
> > > > Administrator group?
> > > >
> > > > Brad Feaker
> > > > Ex nihilo, nihil fit
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > I have a couple third part applications that I'm trying to install that
> > > > > install SQL databases. However I get similar errors during both for the
> > > > > install.
> > > > >
> > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > name again.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > (NULL), (NULL), (NULL).
> > > > >
> > > > >
> > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > password. I've tried installing using the SA account as well as a domain
> > > > > admin account and neither worked.|||this is an interactive application that i'm trying to install so I'm not sure
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
> Instead of using a windows account at all, choose the 'Local System Account'
> option during the install.
> Brad
> "Mike" wrote:
> > Tried using the Administrator account on the local machine. Same problem.
> >
> > "Brad Feaker" wrote:
> >
> > > Try installing using a local system account and then changing the service
> > > accounts after the install is complete.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Yes
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Is the NT account you are using to install a member of the local server
> > > > > Administrator group?
> > > > >
> > > > > Brad Feaker
> > > > > Ex nihilo, nihil fit
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > install.
> > > > > >
> > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > name again.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > (NULL), (NULL), (NULL).
> > > > > >
> > > > > >
> > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > admin account and neither worked.|||At this point you may want to toss the problem back to the vendor....sorry I
could not be of any assistance...
Brad
"Mike" wrote:
> this is an interactive application that i'm trying to install so I'm not sure
> there is a way to do what your asking. i'm assuming it comes to this error
> some point where it's creating the db in sql. it's funny though the the db
> and tables appear to be created fine.
> "Brad Feaker" wrote:
> > Instead of using a windows account at all, choose the 'Local System Account'
> > option during the install.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Tried using the Administrator account on the local machine. Same problem.
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Try installing using a local system account and then changing the service
> > > > accounts after the install is complete.
> > > >
> > > > Brad
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > Yes
> > > > >
> > > > > "Brad Feaker" wrote:
> > > > >
> > > > > > Is the NT account you are using to install a member of the local server
> > > > > > Administrator group?
> > > > > >
> > > > > > Brad Feaker
> > > > > > Ex nihilo, nihil fit
> > > > > >
> > > > > > "Mike" wrote:
> > > > > >
> > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > install.
> > > > > > >
> > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > name again.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > (NULL), (NULL), (NULL).
> > > > > > >
> > > > > > >
> > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > admin account and neither worked.|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
> At this point you may want to toss the problem back to the vendor....sorry I
> could not be of any assistance...
> Brad
> "Mike" wrote:
> > this is an interactive application that i'm trying to install so I'm not sure
> > there is a way to do what your asking. i'm assuming it comes to this error
> > some point where it's creating the db in sql. it's funny though the the db
> > and tables appear to be created fine.
> >
> > "Brad Feaker" wrote:
> >
> > > Instead of using a windows account at all, choose the 'Local System Account'
> > > option during the install.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Tried using the Administrator account on the local machine. Same problem.
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Try installing using a local system account and then changing the service
> > > > > accounts after the install is complete.
> > > > >
> > > > > Brad
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > Yes
> > > > > >
> > > > > > "Brad Feaker" wrote:
> > > > > >
> > > > > > > Is the NT account you are using to install a member of the local server
> > > > > > > Administrator group?
> > > > > > >
> > > > > > > Brad Feaker
> > > > > > > Ex nihilo, nihil fit
> > > > > > >
> > > > > > > "Mike" wrote:
> > > > > > >
> > > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > > install.
> > > > > > > >
> > > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > > name again.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > > (NULL), (NULL), (NULL).
> > > > > > > >
> > > > > > > >
> > > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > > admin account and neither worked.sql

Product error installs

Friday, March 23, 2012

Proclarity Installation using SQL Server 2005

Hi,

I'm attempting to install Proclarity 6 on a Win2003 Virtual PC, using SQL Server 2005 as my DB platform.

The installation continually fails with the error: "The SQL Serve Selected is not in Mixed Mode...". This occurs even if i specify the 'sa' account during the installation.

My SQL Sever is definitely set to Mixed Mode authentication!

Has anyone come accross this before and is there a fix?

Thanks in advance,

Leigh.

just run this statement and see whether its returning 0 or not

select SERVERPROPERTY('IsIntegratedSecurityOnly')

Madhu

|||

Hi Madhu,

I ran that statement and got 0 back from the server suggesting that i am indeed running in "Mixed Mode".

Cheers,

Leigh

|||

Well, i'm not sure why, but i've applied SQL 2005 SP2 and created a new user which i specified to run the ProClarity installation and hey-presto, suddenly everything works!

Cheers,
Leigh

Wednesday, March 21, 2012

Processor model

I have a server with 4 dual core processors.
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.
> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the bios
>> level to be legal?
> Yes.
>> If I don't disable it, will it use all 4 processors even though I only
>> bought license for one processor?
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I have a server with 4 dual core processors.
>> If I install SQL Server 2005 Express edition on it (which is free), I do
>> not have to disable other 3 processors because by default express edition
>> will use at most 1 processor?
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the bios
>> level to be legal? If I don't disable it, will it use all 4 processors
>> even though I only bought license for one processor?
>> Help would be appreciated.
>|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the
>> bios level to be legal?
>> Yes.
>> If I don't disable it, will it use all 4 processors even though I only
>> bought license for one processor?
>> SQL Server will use the lesser of either the number of supported or
>> installed processors. Workgroup supports up to 2 CPUs and Standard up to
>> 4. However you will be violating the license agreement unless you have
>> processor licenses for each processor socket available to the OS. See
>> http://www.microsoft.com/sql/howtobuy/faq.mspx
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "JJ" <nospam@.nospam.com> wrote in message
>> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I have a server with 4 dual core processors.
>> If I install SQL Server 2005 Express edition on it (which is free), I do
>> not have to disable other 3 processors because by default express
>> edition will use at most 1 processor?
>> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
>> processor license, I would have to disable other 3 processors at the
>> bios level to be legal? If I don't disable it, will it use all 4
>> processors even though I only bought license for one processor?
>> Help would be appreciated.
>>
>

Processor Licensing question

I have a dual processor system. One processor is used for boot operations
and the other is used for Applications. If I were to install SQL Single
Processior License on this machine would that be within the Licensing
restrictions as there is the one processor for Applications or would I need
another license? Thanks.
--
George Hester
_________________________________If I remember correctly, SQL will automatically limit itself when using
the per processor license. If not, you can set the CPU affinity to 1
to make sure it only uses 1.
George Hester wrote:
> I have a dual processor system. One processor is used for boot operations
> and the other is used for Applications. If I were to install SQL Single
> Processior License on this machine would that be within the Licensing
> restrictions as there is the one processor for Applications or would I need
> another license? Thanks.
> --
> George Hester
> _________________________________|||"PSPDBA" <DissendiumDBA@.gmail.com> wrote in message
news:1150209890.143128.128400@.f14g2000cwb.googlegroups.com...
> If I remember correctly, SQL will automatically limit itself when using
> the per processor license. If not, you can set the CPU affinity to 1
> to make sure it only uses 1.
>
With Per-Proc licensing you must license SQL Server on all processers
visible to the OS instance where SQL is running.
If you want to run a single proc of SQL on a multi-proc box that is used for
multiple different workloads, you can use Virtual Server 2003 R2, install a
new OS that can only see one processor, and install a single-proc license of
SQL Server on that OS instance.
From:
Virtualization and Multiple Instances
http://www.microsoft.com/sql/howtobuy/multipleinstances.mspx
Each virtual operating environment running SQL Sever 2005 must have a
processor license for each processor that the virtual machine accesses. If a
copy of SQL Server is running on a physical operating environment, then
processor licenses are required for all of the processors on that physical
server.
David

Processor License

I am going to have to install a web based application on a SQL server that
has 4 processors. The web application will integrate with SQL. I do not
have any control over the users that access this system. I am assuming I
will need to but a 4 processor license for SQL. Is there anyway I can run
SQL on just the 1 processor and buy a single processor license?Here is an article on Microsoft's site. It suggests that you would need to
make the processor unavailable to the OS as well.
http://www.microsoft.com/sql/howtobuy/processor.asp
As always. Contact your reseller for an official answer.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
news:%23c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> I am going to have to install a web based application on a SQL server that
> has 4 processors. The web application will integrate with SQL. I do not
> have any control over the users that access this system. I am assuming I
> will need to but a 4 processor license for SQL. Is there anyway I can run
> SQL on just the 1 processor and buy a single processor license?
>|||In addition to Allan's answer, the general rule by MS has been that IF the
procs are on the motherboard (whether or not you have them disabled for SQL
Server use), you must buy licenses for that proc - or take the proc off of
the motherboard...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> I am going to have to install a web based application on a SQL server that
> has 4 processors. The web application will integrate with SQL. I do not
> have any control over the users that access this system. I am assuming I
> will need to but a 4 processor license for SQL. Is there anyway I can run
> SQL on just the 1 processor and buy a single processor license?
>|||Hi Wayne!
> In addition to Allan's answer, the general rule by MS has been that IF the
> procs are on the motherboard (whether or not you have them disabled for SQL
> Server use), you must buy licenses for that proc - or take the proc off of
> the motherboard...
In the word doc released in May, MS softened down this a bit. Here's a quote:
You must acquire licenses for only those processors that are accessible to any operating system copy
upon which the Server Software is set up to run
· Microsoft is enhancing its server licensing to make it more cost-effective for customers
to utilize Server Software licensed in the Per Processor model when the software, through
partitioning or other similar technology, does not utilize all of the processors in a server.
The URL is:
http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%20Guide.doc
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> In addition to Allan's answer, the general rule by MS has been that IF the
> procs are on the motherboard (whether or not you have them disabled for SQL
> Server use), you must buy licenses for that proc - or take the proc off of
> the motherboard...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > I am going to have to install a web based application on a SQL server that
> > has 4 processors. The web application will integrate with SQL. I do not
> > have any control over the users that access this system. I am assuming I
> > will need to but a 4 processor license for SQL. Is there anyway I can run
> > SQL on just the 1 processor and buy a single processor license?
> >
> >
>|||Hi Tibor...
How have you been doing?
Does that mean that SQL enabled to use 2 procs on an 8 proc machine only
requires 2 proc licenses?
thanks bud, I didn't know that...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:eRxFjtwlDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Hi Wayne!
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> In the word doc released in May, MS softened down this a bit. Here's a
quote:
> You must acquire licenses for only those processors that are accessible to
any operating system copy
> upon which the Server Software is set up to run
> · Microsoft is enhancing its server licensing to make it more
cost-effective for customers
> to utilize Server Software licensed in the Per Processor model when the
software, through
> partitioning or other similar technology, does not utilize all of the
processors in a server.
>
>
> The URL is:
>
http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%2
0Guide.doc
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> >
> >
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Computer Education Services Corporation (CESC), Charlotte, NC
> > www.computeredservices.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> >
> > "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> > news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > > I am going to have to install a web based application on a SQL server
that
> > > has 4 processors. The web application will integrate with SQL. I do
not
> > > have any control over the users that access this system. I am
assuming I
> > > will need to but a 4 processor license for SQL. Is there anyway I can
run
> > > SQL on just the 1 processor and buy a single processor license?
> > >
> > >
> >
> >
>|||My reading of the doc - If the processor is available to the OS, you have to
pay... I'll ask someone at PASS next month... Are you coming?...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:eRxFjtwlDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Hi Wayne!
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> In the word doc released in May, MS softened down this a bit. Here's a
quote:
> You must acquire licenses for only those processors that are accessible to
any operating system copy
> upon which the Server Software is set up to run
> · Microsoft is enhancing its server licensing to make it more
cost-effective for customers
> to utilize Server Software licensed in the Per Processor model when the
software, through
> partitioning or other similar technology, does not utilize all of the
processors in a server.
>
>
> The URL is:
>
http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%2
0Guide.doc
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> >
> >
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Computer Education Services Corporation (CESC), Charlotte, NC
> > www.computeredservices.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> >
> > "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> > news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > > I am going to have to install a web based application on a SQL server
that
> > > has 4 processors. The web application will integrate with SQL. I do
not
> > > have any control over the users that access this system. I am
assuming I
> > > will need to but a 4 processor license for SQL. Is there anyway I can
run
> > > SQL on just the 1 processor and buy a single processor license?
> > >
> > >
> >
> >
>|||Hi Wayne,
> How have you been doing?
I'm good, thanks! Hope you are too :-)
> Does that mean that SQL enabled to use 2 procs on an 8 proc machine only
> requires 2 proc licenses?
Just trimming affinity mask doesn't help, need to be restricted at the OS level (as you posted in
the other post).
> My reading of the doc - If the processor is available to the OS, you have to
> pay... I'll ask someone at PASS next month...
Yep, that is my interpretation as well. Let us know of you get some conflicting info.
> I'll ask someone at PASS next month... Are you coming?...
I'm afraid not. Too much going on here... :-)
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23H5Hq$zlDHA.1764@.tk2msftngp13.phx.gbl...
> Hi Tibor...
> How have you been doing?
> Does that mean that SQL enabled to use 2 procs on an 8 proc machine only
> requires 2 proc licenses?
> thanks bud, I didn't know that...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:eRxFjtwlDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > Hi Wayne!
> >
> > > In addition to Allan's answer, the general rule by MS has been that IF
> the
> > > procs are on the motherboard (whether or not you have them disabled for
> SQL
> > > Server use), you must buy licenses for that proc - or take the proc off
> of
> > > the motherboard...
> >
> > In the word doc released in May, MS softened down this a bit. Here's a
> quote:
> > You must acquire licenses for only those processors that are accessible to
> any operating system copy
> > upon which the Server Software is set up to run
> > · Microsoft is enhancing its server licensing to make it more
> cost-effective for customers
> > to utilize Server Software licensed in the Per Processor model when the
> software, through
> > partitioning or other similar technology, does not utilize all of the
> processors in a server.
> >
> >
> >
> >
> >
> > The URL is:
> >
> http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%2
> 0Guide.doc
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> > news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> > > In addition to Allan's answer, the general rule by MS has been that IF
> the
> > > procs are on the motherboard (whether or not you have them disabled for
> SQL
> > > Server use), you must buy licenses for that proc - or take the proc off
> of
> > > the motherboard...
> > >
> > >
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Computer Education Services Corporation (CESC), Charlotte, NC
> > > www.computeredservices.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > >
> > > "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> > > news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > > > I am going to have to install a web based application on a SQL server
> that
> > > > has 4 processors. The web application will integrate with SQL. I do
> not
> > > > have any control over the users that access this system. I am
> assuming I
> > > > will need to but a 4 processor license for SQL. Is there anyway I can
> run
> > > > SQL on just the 1 processor and buy a single processor license?
> > > >
> > > >
> > >
> > >
> >
> >
>

Wednesday, March 7, 2012

Process only running at 25%

Anyone know why the process on our SQL server only ever gets as high as 25%?
It is a default SQL server 2000 install so Im not sure why it is being
restricted?
Thanks,
GrantA single query will use no more than one CPU unless it involves a parallel
plan. On a quad processor box (or dual hypterthreaded), 25% total CPU is
expected for a CPU-bound query.
SQL Server will use all processors (including virtual ones) by default.
Multiple processors can be used by concurrent queries and/or parallel plans.
Hope this helps.
Dan Guzman
SQL Server MVP
"Grant" <gpsnett@.hotmail.com> wrote in message
news:%23dHcrdD9DHA.2316@.TK2MSFTNGP11.phx.gbl...
> Anyone know why the process on our SQL server only ever gets as high as
25%?
> It is a default SQL server 2000 install so Im not sure why it is being
> restricted?
> Thanks,
> Grant
>|||Dan - That SQl server is running on a dual hyperthreaded machine, does that
mean the 25% maximum usage is normal behaviour even for large queries? Would
it ever get larger than that? What explanation do I give to a user that is
worried that the system is only running at 25% capacity?
If there was one hyperthreaded CPU then maximum CPU usage would be 50%
because it is splitting usage bewtween actual CPU and virtual CPU? Is that
right? If it is right then that would mean 2 hyperthreaded CPU's at maximum
use would also push out 50% (2 real CPUs and 2 virtual ones).
Thanks Dan,
Grant
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:u$8T7lD9DHA.2168@.TK2MSFTNGP12.phx.gbl...
> A single query will use no more than one CPU unless it involves a parallel
> plan. On a quad processor box (or dual hypterthreaded), 25% total CPU is
> expected for a CPU-bound query.
> SQL Server will use all processors (including virtual ones) by default.
> Multiple processors can be used by concurrent queries and/or parallel
plans.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Grant" <gpsnett@.hotmail.com> wrote in message
> news:%23dHcrdD9DHA.2316@.TK2MSFTNGP11.phx.gbl...
> 25%?
>|||> Dan - That SQl server is running on a dual hyperthreaded machine, does
that
> mean the 25% maximum usage is normal behaviour even for large queries?
Yes.

> Would it ever get larger than that?
Yes. If you have 4 concurrent cpu-bound queries running, I'd expect you to
average around 100%. You may also exceed 25 with a fewer number of queries
and parallel plans.

> What explanation do I give to a user that is
> worried that the system is only running at 25% capacity?
Ask the user how many lanes they believe a single car on a 4-lane highway
should use. Would the car arrive at the destination faster by using more
than one lane? This does not mean that the additional capacity is wasted.
There may be other times when all lanes are needed and used.

> If there was one hyperthreaded CPU then maximum CPU usage would be 50%
> because it is splitting usage bewtween actual CPU and virtual CPU? Is that
> right? If it is right then that would mean 2 hyperthreaded CPU's at
maximum
> use would also push out 50% (2 real CPUs and 2 virtual ones).
A single thread (e.g. non-oparallel query) can use only one processor
(virtual or physical) - period. A multi-threaded application like SQL
Server can take advantage of multiple (logical or physical) CPUs by doing
concurrent work when appropriate. So it you have a single HT CPU, one
thread can use up to 50% and 2 threads can use up to 100%. In the case of
dual HT CPUs, 1=25%, 2=50%, 75%, 4 = 100%.
Hope this helps.
Dan Guzman
SQL Server MVP
"Grant" <gpsnett@.hotmail.com> wrote in message
news:%23EwRu2D9DHA.2404@.TK2MSFTNGP11.phx.gbl...
> Dan - That SQl server is running on a dual hyperthreaded machine, does
that
> mean the 25% maximum usage is normal behaviour even for large queries?
Would
> it ever get larger than that? What explanation do I give to a user that is
> worried that the system is only running at 25% capacity?
> If there was one hyperthreaded CPU then maximum CPU usage would be 50%
> because it is splitting usage bewtween actual CPU and virtual CPU? Is that
> right? If it is right then that would mean 2 hyperthreaded CPU's at
maximum
> use would also push out 50% (2 real CPUs and 2 virtual ones).
> Thanks Dan,
> Grant
>
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:u$8T7lD9DHA.2168@.TK2MSFTNGP12.phx.gbl...
parallel
is
> plans.
as
>

Process only running at 25%

Anyone know why the process on our SQL server only ever gets as high as 25%?
It is a default SQL server 2000 install so Im not sure why it is being
restricted?
Thanks,
GrantA single query will use no more than one CPU unless it involves a parallel
plan. On a quad processor box (or dual hypterthreaded), 25% total CPU is
expected for a CPU-bound query.
SQL Server will use all processors (including virtual ones) by default.
Multiple processors can be used by concurrent queries and/or parallel plans.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Grant" <gpsnett@.hotmail.com> wrote in message
news:%23dHcrdD9DHA.2316@.TK2MSFTNGP11.phx.gbl...
> Anyone know why the process on our SQL server only ever gets as high as
25%?
> It is a default SQL server 2000 install so Im not sure why it is being
> restricted?
> Thanks,
> Grant
>|||Dan - That SQl server is running on a dual hyperthreaded machine, does that
mean the 25% maximum usage is normal behaviour even for large queries? Would
it ever get larger than that? What explanation do I give to a user that is
worried that the system is only running at 25% capacity?
If there was one hyperthreaded CPU then maximum CPU usage would be 50%
because it is splitting usage bewtween actual CPU and virtual CPU? Is that
right? If it is right then that would mean 2 hyperthreaded CPU's at maximum
use would also push out 50% (2 real CPUs and 2 virtual ones).
Thanks Dan,
Grant
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:u$8T7lD9DHA.2168@.TK2MSFTNGP12.phx.gbl...
> A single query will use no more than one CPU unless it involves a parallel
> plan. On a quad processor box (or dual hypterthreaded), 25% total CPU is
> expected for a CPU-bound query.
> SQL Server will use all processors (including virtual ones) by default.
> Multiple processors can be used by concurrent queries and/or parallel
plans.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Grant" <gpsnett@.hotmail.com> wrote in message
> news:%23dHcrdD9DHA.2316@.TK2MSFTNGP11.phx.gbl...
> > Anyone know why the process on our SQL server only ever gets as high as
> 25%?
> > It is a default SQL server 2000 install so Im not sure why it is being
> > restricted?
> >
> > Thanks,
> > Grant
> >
> >
>|||> Dan - That SQl server is running on a dual hyperthreaded machine, does
that
> mean the 25% maximum usage is normal behaviour even for large queries?
Yes.
> Would it ever get larger than that?
Yes. If you have 4 concurrent cpu-bound queries running, I'd expect you to
average around 100%. You may also exceed 25 with a fewer number of queries
and parallel plans.
> What explanation do I give to a user that is
> worried that the system is only running at 25% capacity?
Ask the user how many lanes they believe a single car on a 4-lane highway
should use. Would the car arrive at the destination faster by using more
than one lane? This does not mean that the additional capacity is wasted.
There may be other times when all lanes are needed and used.
> If there was one hyperthreaded CPU then maximum CPU usage would be 50%
> because it is splitting usage bewtween actual CPU and virtual CPU? Is that
> right? If it is right then that would mean 2 hyperthreaded CPU's at
maximum
> use would also push out 50% (2 real CPUs and 2 virtual ones).
A single thread (e.g. non-oparallel query) can use only one processor
(virtual or physical) - period. A multi-threaded application like SQL
Server can take advantage of multiple (logical or physical) CPUs by doing
concurrent work when appropriate. So it you have a single HT CPU, one
thread can use up to 50% and 2 threads can use up to 100%. In the case of
dual HT CPUs, 1=25%, 2=50%, 75%, 4 = 100%.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Grant" <gpsnett@.hotmail.com> wrote in message
news:%23EwRu2D9DHA.2404@.TK2MSFTNGP11.phx.gbl...
> Dan - That SQl server is running on a dual hyperthreaded machine, does
that
> mean the 25% maximum usage is normal behaviour even for large queries?
Would
> it ever get larger than that? What explanation do I give to a user that is
> worried that the system is only running at 25% capacity?
> If there was one hyperthreaded CPU then maximum CPU usage would be 50%
> because it is splitting usage bewtween actual CPU and virtual CPU? Is that
> right? If it is right then that would mean 2 hyperthreaded CPU's at
maximum
> use would also push out 50% (2 real CPUs and 2 virtual ones).
> Thanks Dan,
> Grant
>
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:u$8T7lD9DHA.2168@.TK2MSFTNGP12.phx.gbl...
> > A single query will use no more than one CPU unless it involves a
parallel
> > plan. On a quad processor box (or dual hypterthreaded), 25% total CPU
is
> > expected for a CPU-bound query.
> >
> > SQL Server will use all processors (including virtual ones) by default.
> > Multiple processors can be used by concurrent queries and/or parallel
> plans.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Grant" <gpsnett@.hotmail.com> wrote in message
> > news:%23dHcrdD9DHA.2316@.TK2MSFTNGP11.phx.gbl...
> > > Anyone know why the process on our SQL server only ever gets as high
as
> > 25%?
> > > It is a default SQL server 2000 install so Im not sure why it is being
> > > restricted?
> > >
> > > Thanks,
> > > Grant
> > >
> > >
> >
> >
>

Friday, March 30, 2012

Profiler and SQL Express

Monday, March 26, 2012

Product error installs

Product error installs

Product error installs

Friday, March 23, 2012

Proclarity Installation using SQL Server 2005

Wednesday, March 21, 2012

Processor model

Processor model

Processor model

Processor Licensing question

Processor License

Wednesday, March 7, 2012

Process only running at 25%

Process only running at 25%

Procedure Time out

Blog Archive

About Me