Config changes on SQL 2k don't stick.

We have a SQL 2k server and we are trying change the file size to
increase its self by Mbytes as opposed to percent.
But the setting won't stick. You can select it, "OK" close the config
manager and open it back up and its set back to "Percent".
Yes, I have rights and I did select OK and we booted the machine
several times.
Any help is appreciated.
Thanks
Sid.1) What account are you using to make this change?
2) What release of SQL Server are you using?
3) How are you trying to implement this change (EM, QA?)
4) Are there any messages in either the SQL Server or server event
logs that suggest anything?
5) Was this database originally created on the server or was it
transferred from another server or a different version of SQL Server
(e.g. 7.0)?
On 1 Nov 2006 14:08:56 -0800, "sid" <sidwelle@.alexian.net> wrote:
>We have a SQL 2k server and we are trying change the file size to
>increase its self by Mbytes as opposed to percent.
>But the setting won't stick. You can select it, "OK" close the config
>manager and open it back up and its set back to "Percent".
>Yes, I have rights and I did select OK and we booted the machine
>several times.
>Any help is appreciated.
>Thanks
>Sid.|||Hello, sid
A related bug is being discussed on Microsoft Connect:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
Razvan
sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.|||sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
>
Try setting the growth options using ALTER DATABASE instead of the GUI...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We did find that on one of our test servers we were experiencing the
same problem that we could make the change stick through the GUI by
just selecting the "growth by Mbytes" and not changing the amount
setting away from "1 meg" until after a boot. It just shouldn't be that
way ...
We'll try it on the live server today.
I'll try the "Alter " command next.
Thanks
Sid.
Tracy McKibben wrote:
> sid wrote:
> > We have a SQL 2k server and we are trying change the file size to
> > increase its self by Mbytes as opposed to percent.
> >
> > But the setting won't stick. You can select it, "OK" close the config
> > manager and open it back up and its set back to "Percent".
> >
> > Yes, I have rights and I did select OK and we booted the machine
> > several times.
> >
> > Any help is appreciated.
> >
> > Thanks
> >
> > Sid.
> >
> Try setting the growth options using ALTER DATABASE instead of the GUI...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

concurrent query limit

i am getting this message in the SQL server logs. But i dont know where to
make the changes to increase the limit...
"This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected."
thanks
You are running either MSDE or Personal Edition. These has a performance throttling mechanism that you have
hit. Evaluate whether you want to install a "proper" SQL Server (Standard or Enterprise edition).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"harun" <kazi[remove]@.wideopenwest.com> wrote in message news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>
|||Hi
This may help if you are using MSDE
http://msdn.microsoft.com/library/de...r_sa2_5fs6.asp
John
"harun" <kazi[remove]@.wideopenwest.com> wrote in message
news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>
|||Folks--
Has anyone gotten this message when they have installed SQL Server Standard
Edition ? I installed Standard Edition from original media purchased from
CDW, and am now seeing this error message very frequently in the Event Viewer
logs.
"John Bell" wrote:

> Hi
> This may help if you are using MSDE
> http://msdn.microsoft.com/library/de...r_sa2_5fs6.asp
> John
> "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> has
>
>
|||My guess is that you have two instances or more of SQL Server and an MSDE instance is giving you the
messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mxnova" <mxnova@.discussions.microsoft.com> wrote in message
news:AE404F97-2F1B-4F73-9C3B-A322A6E24677@.microsoft.com...[vbcol=seagreen]
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standard
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Viewer
> logs.
>
> "John Bell" wrote:

concurrent query limit

i am getting this message in the SQL server logs. But i dont know where to
make the changes to increase the limit...
"This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected."
thanksYou are running either MSDE or Personal Edition. These has a performance thr
ottling mechanism that you have
hit. Evaluate whether you want to install a "proper" SQL Server (Standard or
Enterprise edition).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"harun" <kazi[remove]@.wideopenwest.com> wrote in message news:ea4O43tUEHA.1604@.TK2MSFTNG
P12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit h
as
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||Hi
This may help if you are using MSDE
_5fs6.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_5fs6.asp
John
"harun" <kazi[remove]@.wideopenwest.com> wrote in message
news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||Folks--
Has anyone gotten this message when they have installed SQL Server Standard
Edition ? I installed Standard Edition from original media purchased from
CDW, and am now seeing this error message very frequently in the Event Viewe
r
logs.
"John Bell" wrote:

> Hi
> This may help if you are using MSDE
> a2_5fs6.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
a2_5fs6.asp
> John
> "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> has
>
>|||My guess is that you have two instances or more of SQL Server and an MSDE in
stance is giving you the
messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mxnova" <mxnova@.discussions.microsoft.com> wrote in message
news:AE404F97-2F1B-4F73-9C3B-A322A6E24677@.microsoft.com...[vbcol=seagreen]
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standar
d
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Vie
wer
> logs.
>
> "John Bell" wrote:
>

concurrent query limit

i am getting this message in the SQL server logs. But i dont know where to
make the changes to increase the limit...
"This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected."
thanksYou are running either MSDE or Personal Edition. These has a performance throttling mechanism that you have
hit. Evaluate whether you want to install a "proper" SQL Server (Standard or Enterprise edition).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"harun" <kazi[remove]@.wideopenwest.com> wrote in message news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||From BOL:
"SQL Server 2000 Desktop Engine and SQL Server 2000
Personal Edition have a concurrent workload governor that
limits performance when more than eight operations are run
concurrently". Have a look at DBCC CONCURRENCYVIOLATION to
get more info, but as far as I understand this limit is
not configurable (unless you upgrade to another edition of
course).
HTH,
Paul Ibison|||Hi
This may help if you are using MSDE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
John
"harun" <kazi[remove]@.wideopenwest.com> wrote in message
news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||My guess is that you have two instances or more of SQL Server and an MSDE instance is giving you the
messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mxnova" <mxnova@.discussions.microsoft.com> wrote in message
news:AE404F97-2F1B-4F73-9C3B-A322A6E24677@.microsoft.com...
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standard
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Viewer
> logs.
>
> "John Bell" wrote:
> > Hi
> >
> > This may help if you are using MSDE
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
> >
> > John
> > "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> > news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> > > i am getting this message in the SQL server logs. But i dont know where to
> > > make the changes to increase the limit...
> > >
> > > "This SQL Server has been optimized for 8 concurrent queries. This limit
> > has
> > > been exceeded by 1 queries and performance may be adversely affected."
> > >
> > > thanks
> > >
> > >
> >
> >
> >