Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQL 7.0 HANGS

Re: MS SQL 7.0 HANGS

From: Davey Boy <davidpet_at_emirates.net.ae>
Date: Tue, 17 Aug 1999 00:39:14 +0400
Message-ID: <7p9t14$5v43@news.emirates.net.ae>


Depends how you define a bug. It may be designed to work that way. Therefore not a bug. But the design is wrong. One user should not hang an enterprise system. Surely end of story. Whatever the query. Disconnect the user even, but don't bring the whole thing to its knees! I'm having similar problems on 6.5 with one global variable! I am sure we made a mistake with its use, but one thing I do know, it should just reject that transaction (or give it much less resources) and be able to supply the other users with a normal service. Coming from an ORACLE background, I was prepared to knock SQL, but now I am impressed, no more blisters on my typing fingers, but these areas surely need looking at Microsoft.

Max Akbar <Maximum2000_at_msn.com> wrote in message news:#rku4Otw#GA.398_at_cpmsnbbsa02...
> I don't think this is a bug!
>
> Common sense tells anyone who is involved in DBA work that if there is any
> task that requires time like your task 30 min adequate time should be
> allocated or the task should be run off hours. If you have to run this
query
> then you should think about multi processor server or a hardware that can
> handle such a query the fault may not be the software (again common
sense).
>
> It would be nice to see a sample of your extreme query so others could
help
> you, or agree with you.
>
> <Cha Ching> that was my two cents,
> -Max
>
>
> An Unhappy Microsoft Customer <unhappy_at_microsoft.com> wrote in message
> news:930607826.300.90_at_news.remarQ.com...
> > Issue--
> > We are experiencing apparent server hangs. Microsoft has traced the
> > problem to a complex query that is being run that uses parallelism and
the
> > result set is being processed slowly (one row every 500 ms or so) The
> total
> > wall time that the query is open could be in excess of 30 minutes.
> >
> > Facts--
> > MS SQL 7.0 allocates various resources, including memory for running
> > queries. This amount of memory is not user configurable and is based on
> > total memory in the server.
> > Complex queries, especially where the query plan indicates
> parallelism,
> > can use up a substantial amount of these resources.
> > If a complex query result is open without leaving sufficient
resources
> > for other queries MS SQL 7.0 will not be able to process additional
> queries.
> > The server will appear "hung" to users until the complex query result
set
> is
> > processed and closed.
> > Microsoft does not believe this is a flaw in MS SQL 7.0. We
strongly
> > believe this is a serious bug.
> > These complex queries were not a problem under MS SQL 6.5 because of
> > it's simpler query engine
> > Microsoft claims the problem is "poorly written queries". We
believe
> no
> > user query, no matter how poorly written, should be able to "hang" an
> > enterprise class database server (if that's what you consider MS SQL
> > Server). We would expect results like this from MS Access, not from MS
> SQL
> > server.
> >
> > Discussion--
> > Is this a bug?
> >
> >
> >
>
>
Received on Mon Aug 16 1999 - 15:39:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US