I got an error "Setup failed to configure the server". I
have tried to delete the directory "C:\program
files\microsoft sql sever before installation. But I still
get this error. What should i do?
Thank you very much. I spent a week to install this MSDE
but still failed. I am very desperate...
San
hi San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
> I got an error "Setup failed to configure the server". I
> have tried to delete the directory "C:\program
> files\microsoft sql sever before installation. But I still
> get this error. What should i do?
> Thank you very much. I spent a week to install this MSDE
> but still failed. I am very desperate...
in addition to folder delete, try cealning the Windows Registry too, as
reported in
http://support.microsoft.com/default...;EN-US;Q290991
"Remove a Specific Instance of SQL Server" section...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you. However, I am confused. It is because that KB
is for those who have sql sever installed before. My
computer did not contains any sql sever before (I think).
Could you give me more hints on what I should delete?
Furthermore, I found a strange registry. It
is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
Should I delete this?
Thank you for your help.
San
>--Original Message--
>hi San,
>"San" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
still
>in addition to folder delete, try cealning the Windows
Registry too, as
>reported in
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q290991
>"Remove a Specific Instance of SQL Server" section...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>
|||hi San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e59401c45553$1386bba0$a101280a@.phx.gbl...
> Thank you. However, I am confused. It is because that KB
> is for those who have sql sever installed before. My
> computer did not contains any sql sever before (I think).
> Could you give me more hints on what I should delete?
> Furthermore, I found a strange registry. It
> is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
> Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
> Should I delete this?
personally I always and only cleared the registry keys reported in the KB
article... as you already read, this does not clear the Windows Installer
registry entries, but I was quiet happy with this method when a MSDE
instance I installed refused to uninstall... I still have this entry in the
Add/Remove programs applet, but I'll remove it ...perhaps =;-D
the hive you notice shoul'd only point to a Temp folder used by the setup
process...
you wrote[vbcol=seagreen]
uncomplete installations can make the system dirty, so you are supposed to
clear it before re-proceeding with new installs...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql
Showing posts with label ihave. Show all posts
Showing posts with label ihave. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
MSDE Performance Against Concurrent Access
Thx Andrea, Thx William,
Since u told me, I've made some test on the SQL model I
have running and the queries use to take just 1/100 sec (I
use to have up to 10 queries in chain per ASP page) due to
the volume of the info related (this intranet wouldnt
reach 100.000 records total in 38 tables, ever I think)
and the easyness of the queries (it has as maximum 2
subqueries) but there is more inner joins, up to 5 in the
same query, there is also 100's of relations between the
tables (38 total tables).
I think this information make sence to migrate the model
to MSDE and use it without translating the cost of a SQL
licence to my client since it wouldnt worth it.
Any other sugest?
Thx in advance...
>--Original Message--
>Hello,
>Can anybody tell me about your own experience using IIS
>with MSDE as repository?
>Would the concurrent access of the anonymous internet
user
>to the MSDE engine affect its performance if the
>concurrent access reach more than 5 at a time?
>Im planning to deploy an Intranet Application for
>consultant office and Im affraid the MSDE to cause a
>dregradation in performance if it gets more than 5
>concurrent access.
>Thx in Advance.
>Mike.
>.
>
1) MSDE is free
2) JET is not intended for use in a web site for several reasons.
3) JET will outperform MSDE for some queries but it does not scale.
4) See 1.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:b13701c47973$8f7843c0$a501280a@.phx.gbl...[vbcol=seagreen]
> Thx Andrea, Thx William,
> Since u told me, I've made some test on the SQL model I
> have running and the queries use to take just 1/100 sec (I
> use to have up to 10 queries in chain per ASP page) due to
> the volume of the info related (this intranet wouldnt
> reach 100.000 records total in 38 tables, ever I think)
> and the easyness of the queries (it has as maximum 2
> subqueries) but there is more inner joins, up to 5 in the
> same query, there is also 100's of relations between the
> tables (38 total tables).
> I think this information make sence to migrate the model
> to MSDE and use it without translating the cost of a SQL
> licence to my client since it wouldnt worth it.
> Any other sugest?
> Thx in advance...
>
> user
Since u told me, I've made some test on the SQL model I
have running and the queries use to take just 1/100 sec (I
use to have up to 10 queries in chain per ASP page) due to
the volume of the info related (this intranet wouldnt
reach 100.000 records total in 38 tables, ever I think)
and the easyness of the queries (it has as maximum 2
subqueries) but there is more inner joins, up to 5 in the
same query, there is also 100's of relations between the
tables (38 total tables).
I think this information make sence to migrate the model
to MSDE and use it without translating the cost of a SQL
licence to my client since it wouldnt worth it.
Any other sugest?
Thx in advance...
>--Original Message--
>Hello,
>Can anybody tell me about your own experience using IIS
>with MSDE as repository?
>Would the concurrent access of the anonymous internet
user
>to the MSDE engine affect its performance if the
>concurrent access reach more than 5 at a time?
>Im planning to deploy an Intranet Application for
>consultant office and Im affraid the MSDE to cause a
>dregradation in performance if it gets more than 5
>concurrent access.
>Thx in Advance.
>Mike.
>.
>
1) MSDE is free
2) JET is not intended for use in a web site for several reasons.
3) JET will outperform MSDE for some queries but it does not scale.
4) See 1.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:b13701c47973$8f7843c0$a501280a@.phx.gbl...[vbcol=seagreen]
> Thx Andrea, Thx William,
> Since u told me, I've made some test on the SQL model I
> have running and the queries use to take just 1/100 sec (I
> use to have up to 10 queries in chain per ASP page) due to
> the volume of the info related (this intranet wouldnt
> reach 100.000 records total in 38 tables, ever I think)
> and the easyness of the queries (it has as maximum 2
> subqueries) but there is more inner joins, up to 5 in the
> same query, there is also 100's of relations between the
> tables (38 total tables).
> I think this information make sence to migrate the model
> to MSDE and use it without translating the cost of a SQL
> licence to my client since it wouldnt worth it.
> Any other sugest?
> Thx in advance...
>
> user
Monday, March 12, 2012
MSDE limits?
Hej,
Is there a physical limit to how many simultaneous users MSDE can have. I
have read 25... and i have heard 10... what are the limits?
/Richard
Richard,
Well, there are no fixed limit. The governor will slow down when over 8
concurrent (active) connections. I think SQL Server use 3 itself,
leaving 5 for "your" use. These can handle a lot of users, depending on
how "busy" they are... If you have an app where every user is hitting
the database "all the time" with heavy worklooads, then you are "safe"
with 5 users and probabaly 10 will "work". If your app is using the
server less frequently, 25 users is certainly possible.
So the answer is: It depends... (on your app and your users)
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Richard Bibby wrote:
> Hej,
> Is there a physical limit to how many simultaneous users MSDE can have. I
> have read 25... and i have heard 10... what are the limits?
> /Richard
>
|||ok.. what about database size?
"Lars Broberg" <lars.b@.elbe-data.nothing.se> skrev i meddelandet
news:u4hwQweMFHA.1476@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Richard,
> Well, there are no fixed limit. The governor will slow down when over 8
> concurrent (active) connections. I think SQL Server use 3 itself, leaving
> 5 for "your" use. These can handle a lot of users, depending on how "busy"
> they are... If you have an app where every user is hitting the database
> "all the time" with heavy worklooads, then you are "safe" with 5 users and
> probabaly 10 will "work". If your app is using the server less frequently,
> 25 users is certainly possible.
> So the answer is: It depends... (on your app and your users)
> Lars Broberg
> Elbe-Data AB
> http://www.elbe-data.se
> Remove "nothing." when replying to private e-mail!
>
> Richard Bibby wrote:
|||2 GB is max for MSDE.
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Richard Bibby wrote:
> ok.. what about database size?
>
> "Lars Broberg" <lars.b@.elbe-data.nothing.se> skrev i meddelandet
> news:u4hwQweMFHA.1476@.TK2MSFTNGP09.phx.gbl...
>
>
|||The limit is not based upon concurrent connections. It is based upon
concurrent "workloads". There is a big difference. When the system needs to
execute more than 8 concurrent query plans, it inserts a delay in each
logical page access. For small queries, this can have a minor effect. For
larger table scans, this can have a large effect. Use DBCC
CONCURRENCYVIOLATION to investigate if any delays have been inserted and how
often. We have regularly seen more than 20 winform users happy with a single
instance of the MSDE. The 2G database size limit seems to impact most people
before the query governor does.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Lars Broberg" <lars.b@.elbe-data.nothing.se> wrote in message
news:u4hwQweMFHA.1476@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Richard,
> Well, there are no fixed limit. The governor will slow down when over 8
> concurrent (active) connections. I think SQL Server use 3 itself, leaving
> 5 for "your" use. These can handle a lot of users, depending on how "busy"
> they are... If you have an app where every user is hitting the database
> "all the time" with heavy worklooads, then you are "safe" with 5 users and
> probabaly 10 will "work". If your app is using the server less frequently,
> 25 users is certainly possible.
> So the answer is: It depends... (on your app and your users)
> Lars Broberg
> Elbe-Data AB
> http://www.elbe-data.se
> Remove "nothing." when replying to private e-mail!
>
> Richard Bibby wrote:
|||"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23aRti5rMFHA.3336@.TK2MSFTNGP10.phx.gbl...
> The limit is not based upon concurrent connections. It is based upon
> concurrent "workloads". There is a big difference. When the system needs
> to execute more than 8 concurrent query plans, it inserts a delay in each
> logical page access. For small queries, this can have a minor effect. For
> larger table scans, this can have a large effect. Use DBCC
> CONCURRENCYVIOLATION to investigate if any delays have been inserted and
> how often.
So you are saying that MSDE inserts artificial delays just for the purpose
of slowing itself down because it is not the full version of SQL Server?
I'm just wondering. I had always heard that the only differences were the 2
GB limit and 5 connections...but that more connections were allowed, it
would just wait before letting them do anything until a spot opened up.
Then again, I don't know what I'm talking about.
Is there an easy way to tell if I am going to use more than 8 concurrent
query plans?
Matt
|||hi,
YYZ wrote:
> So you are saying that MSDE inserts artificial delays just for the
> purpose of slowing itself down because it is not the full version of
> SQL Server?
loosely speaking, yes
> I'm just wondering. I had always heard that the only differences
> were the 2 GB limit and 5 connections...but that more connections
> were allowed, it would just wait before letting them do anything
> until a spot opened up.
up to 32767 connections are theoretical valid for MSDE too, but you'll go
out of resources long before that
> Then again, I don't know what I'm talking about.
> Is there an easy way to tell if I am going to use more than 8
> concurrent query plans?
it's not about query plans, but, again, concurrent workloads.. please have a
look at
http://msdn.microsoft.com/library/?u...asp?frame=true
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3atbhaF6fc386U1@.individual.net...
> hi,
> YYZ wrote:
> loosely speaking, yes
That's all I was looking for. Thanks!
> it's not about query plans, but, again, concurrent workloads.. please have
> a
> look at
> http://msdn.microsoft.com/library/?u...asp?frame=true
Thanks for the link. That will help tremendously, I think.
Matt
Is there a physical limit to how many simultaneous users MSDE can have. I
have read 25... and i have heard 10... what are the limits?
/Richard
Richard,
Well, there are no fixed limit. The governor will slow down when over 8
concurrent (active) connections. I think SQL Server use 3 itself,
leaving 5 for "your" use. These can handle a lot of users, depending on
how "busy" they are... If you have an app where every user is hitting
the database "all the time" with heavy worklooads, then you are "safe"
with 5 users and probabaly 10 will "work". If your app is using the
server less frequently, 25 users is certainly possible.
So the answer is: It depends... (on your app and your users)
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Richard Bibby wrote:
> Hej,
> Is there a physical limit to how many simultaneous users MSDE can have. I
> have read 25... and i have heard 10... what are the limits?
> /Richard
>
|||ok.. what about database size?
"Lars Broberg" <lars.b@.elbe-data.nothing.se> skrev i meddelandet
news:u4hwQweMFHA.1476@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Richard,
> Well, there are no fixed limit. The governor will slow down when over 8
> concurrent (active) connections. I think SQL Server use 3 itself, leaving
> 5 for "your" use. These can handle a lot of users, depending on how "busy"
> they are... If you have an app where every user is hitting the database
> "all the time" with heavy worklooads, then you are "safe" with 5 users and
> probabaly 10 will "work". If your app is using the server less frequently,
> 25 users is certainly possible.
> So the answer is: It depends... (on your app and your users)
> Lars Broberg
> Elbe-Data AB
> http://www.elbe-data.se
> Remove "nothing." when replying to private e-mail!
>
> Richard Bibby wrote:
|||2 GB is max for MSDE.
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Richard Bibby wrote:
> ok.. what about database size?
>
> "Lars Broberg" <lars.b@.elbe-data.nothing.se> skrev i meddelandet
> news:u4hwQweMFHA.1476@.TK2MSFTNGP09.phx.gbl...
>
>
|||The limit is not based upon concurrent connections. It is based upon
concurrent "workloads". There is a big difference. When the system needs to
execute more than 8 concurrent query plans, it inserts a delay in each
logical page access. For small queries, this can have a minor effect. For
larger table scans, this can have a large effect. Use DBCC
CONCURRENCYVIOLATION to investigate if any delays have been inserted and how
often. We have regularly seen more than 20 winform users happy with a single
instance of the MSDE. The 2G database size limit seems to impact most people
before the query governor does.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Lars Broberg" <lars.b@.elbe-data.nothing.se> wrote in message
news:u4hwQweMFHA.1476@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Richard,
> Well, there are no fixed limit. The governor will slow down when over 8
> concurrent (active) connections. I think SQL Server use 3 itself, leaving
> 5 for "your" use. These can handle a lot of users, depending on how "busy"
> they are... If you have an app where every user is hitting the database
> "all the time" with heavy worklooads, then you are "safe" with 5 users and
> probabaly 10 will "work". If your app is using the server less frequently,
> 25 users is certainly possible.
> So the answer is: It depends... (on your app and your users)
> Lars Broberg
> Elbe-Data AB
> http://www.elbe-data.se
> Remove "nothing." when replying to private e-mail!
>
> Richard Bibby wrote:
|||"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23aRti5rMFHA.3336@.TK2MSFTNGP10.phx.gbl...
> The limit is not based upon concurrent connections. It is based upon
> concurrent "workloads". There is a big difference. When the system needs
> to execute more than 8 concurrent query plans, it inserts a delay in each
> logical page access. For small queries, this can have a minor effect. For
> larger table scans, this can have a large effect. Use DBCC
> CONCURRENCYVIOLATION to investigate if any delays have been inserted and
> how often.
So you are saying that MSDE inserts artificial delays just for the purpose
of slowing itself down because it is not the full version of SQL Server?
I'm just wondering. I had always heard that the only differences were the 2
GB limit and 5 connections...but that more connections were allowed, it
would just wait before letting them do anything until a spot opened up.
Then again, I don't know what I'm talking about.
Is there an easy way to tell if I am going to use more than 8 concurrent
query plans?
Matt
|||hi,
YYZ wrote:
> So you are saying that MSDE inserts artificial delays just for the
> purpose of slowing itself down because it is not the full version of
> SQL Server?
loosely speaking, yes
> I'm just wondering. I had always heard that the only differences
> were the 2 GB limit and 5 connections...but that more connections
> were allowed, it would just wait before letting them do anything
> until a spot opened up.
up to 32767 connections are theoretical valid for MSDE too, but you'll go
out of resources long before that
> Then again, I don't know what I'm talking about.
> Is there an easy way to tell if I am going to use more than 8
> concurrent query plans?
it's not about query plans, but, again, concurrent workloads.. please have a
look at
http://msdn.microsoft.com/library/?u...asp?frame=true
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3atbhaF6fc386U1@.individual.net...
> hi,
> YYZ wrote:
> loosely speaking, yes
That's all I was looking for. Thanks!
> it's not about query plans, but, again, concurrent workloads.. please have
> a
> look at
> http://msdn.microsoft.com/library/?u...asp?frame=true
Thanks for the link. That will help tremendously, I think.
Matt
Wednesday, March 7, 2012
MSDE Installation Confusion
I recently obtained Visual C++ .NET 2003, and am under the impression that I
have to install MSDE to provide SQL support for applications I write.
Do I need to install SQLServer as well? (None of the documentation I have
read so far says so, but some comments I have read make me want
confirmation).
Regards
Dave
Hi Dave,
If you have SQL Server, you have no need to install the MSDE. The MSDE is
basically a cut-down SQL Server mostly used for deployment with apps where
the client doesn't have SQL Server. For development, you should use the
Developer Edition of SQL Server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Dave Bolt" <dave@.NO_SPAM_PLEASE_davebolt.fsnet.co.uk> wrote in message
news:usPPlBk5EHA.2012@.TK2MSFTNGP15.phx.gbl...
>I recently obtained Visual C++ .NET 2003, and am under the impression that
>I have to install MSDE to provide SQL support for applications I write.
> Do I need to install SQLServer as well? (None of the documentation I have
> read so far says so, but some comments I have read make me want
> confirmation).
> Regards
> Dave
>
|||Thanks lots for that clarification.
Regards
Dave
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23wWf3Xl5EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Hi Dave,
> If you have SQL Server, you have no need to install the MSDE. The MSDE is
> basically a cut-down SQL Server mostly used for deployment with apps where
> the client doesn't have SQL Server. For development, you should use the
> Developer Edition of SQL Server.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Dave Bolt" <dave@.NO_SPAM_PLEASE_davebolt.fsnet.co.uk> wrote in message
> news:usPPlBk5EHA.2012@.TK2MSFTNGP15.phx.gbl...
>
have to install MSDE to provide SQL support for applications I write.
Do I need to install SQLServer as well? (None of the documentation I have
read so far says so, but some comments I have read make me want
confirmation).
Regards
Dave
Hi Dave,
If you have SQL Server, you have no need to install the MSDE. The MSDE is
basically a cut-down SQL Server mostly used for deployment with apps where
the client doesn't have SQL Server. For development, you should use the
Developer Edition of SQL Server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Dave Bolt" <dave@.NO_SPAM_PLEASE_davebolt.fsnet.co.uk> wrote in message
news:usPPlBk5EHA.2012@.TK2MSFTNGP15.phx.gbl...
>I recently obtained Visual C++ .NET 2003, and am under the impression that
>I have to install MSDE to provide SQL support for applications I write.
> Do I need to install SQLServer as well? (None of the documentation I have
> read so far says so, but some comments I have read make me want
> confirmation).
> Regards
> Dave
>
|||Thanks lots for that clarification.
Regards
Dave
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23wWf3Xl5EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Hi Dave,
> If you have SQL Server, you have no need to install the MSDE. The MSDE is
> basically a cut-down SQL Server mostly used for deployment with apps where
> the client doesn't have SQL Server. For development, you should use the
> Developer Edition of SQL Server.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Dave Bolt" <dave@.NO_SPAM_PLEASE_davebolt.fsnet.co.uk> wrote in message
> news:usPPlBk5EHA.2012@.TK2MSFTNGP15.phx.gbl...
>
Subscribe to:
Posts (Atom)