>Approximately once a week for the past 3 weeks we have had some issues with
>the custome web content management system sql database that have caused
>signification problems with the editorial tool and/or live site rendering.
>The primary symptoms have been extreme sluggishness in the tool, the publish
>process very slow or not moving at all and slow rendering on the live
>site.When the issues have occurred we have noticed a couple of things on the
>sql database. The user connections on the database take a significant and
>fairly sudden jump from about 350 to 2000 or more, the server itself becomes
>very slow, in 2 of the 3 cases it became totally unresponsive, unable to
>connect via QA. A sql restart has fixed the problem in all cases. Any suggest
>to look at appreciated..... We have custome built CMS app to push contents to
>live site. All contents stored in sql database. But for some reason we have
>this issue with connetion jump..with any indication.

"Roy Harvey" <roy_har***@snet.net> wrote in message
news:rui8a2dbfo5qu01gcgiu1ntobifvhd8cta@4ax.com...
> When I have seen a sudden increase in connections it has resulted from
> a buggy client application that kept opening new connections rather
> than re-using the existing one.  On the other hand, with a web based
> client I would have to consider the possibility of some sort of
> deliberate attack.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Thu, 29 Jun 2006 14:04:02 -0700, andrew007 <gah***@yahoo.com>
> wrote:
>
>>Approximately once a week for the past 3 weeks we have had some issues
>>with
>>the custome web content management system sql database that have caused
>>signification problems with the editorial tool and/or live site rendering.
>>The primary symptoms have been extreme sluggishness in the tool, the
>>publish
>>process very slow or not moving at all and slow rendering on the live
>>site.When the issues have occurred we have noticed a couple of things on
>>the
>>sql database. The user connections on the database take a significant and
>>fairly sudden jump from about 350 to 2000 or more, the server itself
>>becomes
>>very slow, in 2 of the 3 cases it became totally unresponsive, unable to
>>connect via QA. A sql restart has fixed the problem in all cases. Any
>>suggest
>>to look at appreciated..... We have custome built CMS app to push contents
>>to
>>live site. All contents stored in sql database. But for some reason we
>>have
>>this issue with connetion jump..with any indication.

"Roger Wolter[MSFT]" <rwol***@online.microsoft.com> wrote in message
news:uUimOh8mGHA.3376@TK2MSFTNGP05.phx.gbl...
> It's also possible that this is an effect rather than a cause.  If the
> database gets really slow because of a blocking issue or something, a lot
> more users are going to get backed up waiting to a response so the number
> of open requests goes up.  This has a tendency to escalate because things
> get slow and all the users keep retrying their requests.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Roy Harvey" <roy_har***@snet.net> wrote in message
> news:rui8a2dbfo5qu01gcgiu1ntobifvhd8cta@4ax.com...
>> When I have seen a sudden increase in connections it has resulted from
>> a buggy client application that kept opening new connections rather
>> than re-using the existing one.  On the other hand, with a web based
>> client I would have to consider the possibility of some sort of
>> deliberate attack.
>>
>> Roy Harvey
>> Beacon Falls, CT
>>
>> On Thu, 29 Jun 2006 14:04:02 -0700, andrew007 <gah***@yahoo.com>
>> wrote:
>>
>>>Approximately once a week for the past 3 weeks we have had some issues
>>>with
>>>the custome web content management system sql database that have caused
>>>signification problems with the editorial tool and/or live site
>>>rendering.
>>>The primary symptoms have been extreme sluggishness in the tool, the
>>>publish
>>>process very slow or not moving at all and slow rendering on the live
>>>site.When the issues have occurred we have noticed a couple of things on
>>>the
>>>sql database. The user connections on the database take a significant and
>>>fairly sudden jump from about 350 to 2000 or more, the server itself
>>>becomes
>>>very slow, in 2 of the 3 cases it became totally unresponsive, unable to
>>>connect via QA. A sql restart has fixed the problem in all cases. Any
>>>suggest
>>>to look at appreciated..... We have custome built CMS app to push
>>>contents to
>>>live site. All contents stored in sql database. But for some reason we
>>>have
>>>this issue with connetion jump..with any indication.
>
>

"Andrew J. Kelly" wrote:

> I agree with Roger on that part. Often a sudden jump in connections is due
> to the fact something is preventing the current connections from completing.
> A rouge query etc can do a lot of harm. What is your MAXDOP set to? With
> that many users and requests you may want to set it to 1.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Roger Wolter[MSFT]" <rwol***@online.microsoft.com> wrote in message
> news:uUimOh8mGHA.3376@TK2MSFTNGP05.phx.gbl...
> > It's also possible that this is an effect rather than a cause.  If the
> > database gets really slow because of a blocking issue or something, a lot
> > more users are going to get backed up waiting to a response so the number
> > of open requests goes up.  This has a tendency to escalate because things
> > get slow and all the users keep retrying their requests.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > Use of included script samples are subject to the terms specified at
> > http://www.microsoft.com/info/cpyright.htm
> >
> > "Roy Harvey" <roy_har***@snet.net> wrote in message
> > news:rui8a2dbfo5qu01gcgiu1ntobifvhd8cta@4ax.com...
> >> When I have seen a sudden increase in connections it has resulted from
> >> a buggy client application that kept opening new connections rather
> >> than re-using the existing one.  On the other hand, with a web based
> >> client I would have to consider the possibility of some sort of
> >> deliberate attack.
> >>
> >> Roy Harvey
> >> Beacon Falls, CT
> >>
> >> On Thu, 29 Jun 2006 14:04:02 -0700, andrew007 <gah***@yahoo.com>
> >> wrote:
> >>
> >>>Approximately once a week for the past 3 weeks we have had some issues
> >>>with
> >>>the custome web content management system sql database that have caused
> >>>signification problems with the editorial tool and/or live site
> >>>rendering.
> >>>The primary symptoms have been extreme sluggishness in the tool, the
> >>>publish
> >>>process very slow or not moving at all and slow rendering on the live
> >>>site.When the issues have occurred we have noticed a couple of things on
> >>>the
> >>>sql database. The user connections on the database take a significant and
> >>>fairly sudden jump from about 350 to 2000 or more, the server itself
> >>>becomes
> >>>very slow, in 2 of the 3 cases it became totally unresponsive, unable to
> >>>connect via QA. A sql restart has fixed the problem in all cases. Any
> >>>suggest
> >>>to look at appreciated..... We have custome built CMS app to push
> >>>contents to
> >>>live site. All contents stored in sql database. But for some reason we
> >>>have
> >>>this issue with connetion jump..with any indication.
> >
> >
>
>
>

"andrew007" wrote:

> We have a default value 0 set to MAXDOP.
>
> "Andrew J. Kelly" wrote:
>
> > I agree with Roger on that part. Often a sudden jump in connections is due
> > to the fact something is preventing the current connections from completing.
> > A rouge query etc can do a lot of harm. What is your MAXDOP set to? With
> > that many users and requests you may want to set it to 1.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> > "Roger Wolter[MSFT]" <rwol***@online.microsoft.com> wrote in message
> > news:uUimOh8mGHA.3376@TK2MSFTNGP05.phx.gbl...
> > > It's also possible that this is an effect rather than a cause.  If the
> > > database gets really slow because of a blocking issue or something, a lot
> > > more users are going to get backed up waiting to a response so the number
> > > of open requests goes up.  This has a tendency to escalate because things
> > > get slow and all the users keep retrying their requests.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > Use of included script samples are subject to the terms specified at
> > > http://www.microsoft.com/info/cpyright.htm
> > >
> > > "Roy Harvey" <roy_har***@snet.net> wrote in message
> > > news:rui8a2dbfo5qu01gcgiu1ntobifvhd8cta@4ax.com...
> > >> When I have seen a sudden increase in connections it has resulted from
> > >> a buggy client application that kept opening new connections rather
> > >> than re-using the existing one.  On the other hand, with a web based
> > >> client I would have to consider the possibility of some sort of
> > >> deliberate attack.
> > >>
> > >> Roy Harvey
> > >> Beacon Falls, CT
> > >>
> > >> On Thu, 29 Jun 2006 14:04:02 -0700, andrew007 <gah***@yahoo.com>
> > >> wrote:
> > >>
> > >>>Approximately once a week for the past 3 weeks we have had some issues
> > >>>with
> > >>>the custome web content management system sql database that have caused
> > >>>signification problems with the editorial tool and/or live site
> > >>>rendering.
> > >>>The primary symptoms have been extreme sluggishness in the tool, the
> > >>>publish
> > >>>process very slow or not moving at all and slow rendering on the live
> > >>>site.When the issues have occurred we have noticed a couple of things on
> > >>>the
> > >>>sql database. The user connections on the database take a significant and
> > >>>fairly sudden jump from about 350 to 2000 or more, the server itself
> > >>>becomes
> > >>>very slow, in 2 of the 3 cases it became totally unresponsive, unable to
> > >>>connect via QA. A sql restart has fixed the problem in all cases. Any
> > >>>suggest
> > >>>to look at appreciated..... We have custome built CMS app to push
> > >>>contents to
> > >>>live site. All contents stored in sql database. But for some reason we
> > >>>have
> > >>>this issue with connetion jump..with any indication.
> > >
> > >
> >
> >
> >

"andrew007" <gah***@yahoo.com> wrote in message
news:80D9183F-8720-47C3-BF39-916671852F14@microsoft.com...
> chanign MAXDOP to 1  helpful in this scenario?
>
> "andrew007" wrote:
>
>> We have a default value 0 set to MAXDOP.
>>
>> "Andrew J. Kelly" wrote:
>>
>> > I agree with Roger on that part. Often a sudden jump in connections is
>> > due
>> > to the fact something is preventing the current connections from
>> > completing.
>> > A rouge query etc can do a lot of harm. What is your MAXDOP set to?
>> > With
>> > that many users and requests you may want to set it to 1.
>> >
>> > --
>> > Andrew J. Kelly SQL MVP
>> >
>> > "Roger Wolter[MSFT]" <rwol***@online.microsoft.com> wrote in message
>> > news:uUimOh8mGHA.3376@TK2MSFTNGP05.phx.gbl...
>> > > It's also possible that this is an effect rather than a cause.  If
>> > > the
>> > > database gets really slow because of a blocking issue or something, a
>> > > lot
>> > > more users are going to get backed up waiting to a response so the
>> > > number
>> > > of open requests goes up.  This has a tendency to escalate because
>> > > things
>> > > get slow and all the users keep retrying their requests.
>> > >
>> > > --
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > > Use of included script samples are subject to the terms specified at
>> > > http://www.microsoft.com/info/cpyright.htm
>> > >
>> > > "Roy Harvey" <roy_har***@snet.net> wrote in message
>> > > news:rui8a2dbfo5qu01gcgiu1ntobifvhd8cta@4ax.com...
>> > >> When I have seen a sudden increase in connections it has resulted
>> > >> from
>> > >> a buggy client application that kept opening new connections rather
>> > >> than re-using the existing one.  On the other hand, with a web based
>> > >> client I would have to consider the possibility of some sort of
>> > >> deliberate attack.
>> > >>
>> > >> Roy Harvey
>> > >> Beacon Falls, CT
>> > >>
>> > >> On Thu, 29 Jun 2006 14:04:02 -0700, andrew007 <gah***@yahoo.com>
>> > >> wrote:
>> > >>
>> > >>>Approximately once a week for the past 3 weeks we have had some
>> > >>>issues
>> > >>>with
>> > >>>the custome web content management system sql database that have
>> > >>>caused
>> > >>>signification problems with the editorial tool and/or live site
>> > >>>rendering.
>> > >>>The primary symptoms have been extreme sluggishness in the tool, the
>> > >>>publish
>> > >>>process very slow or not moving at all and slow rendering on the
>> > >>>live
>> > >>>site.When the issues have occurred we have noticed a couple of
>> > >>>things on
>> > >>>the
>> > >>>sql database. The user connections on the database take a
>> > >>>significant and
>> > >>>fairly sudden jump from about 350 to 2000 or more, the server itself
>> > >>>becomes
>> > >>>very slow, in 2 of the 3 cases it became totally unresponsive,
>> > >>>unable to
>> > >>>connect via QA. A sql restart has fixed the problem in all cases.
>> > >>>Any
>> > >>>suggest
>> > >>>to look at appreciated..... We have custome built CMS app to push
>> > >>>contents to
>> > >>>live site. All contents stored in sql database. But for some reason
>> > >>>we
>> > >>>have
>> > >>>this issue with connetion jump..with any indication.
>> > >
>> > >
>> >
>> >
>> >