Re: MS SQL 7.0 HANGS

SQL Server does use resource management, in 7.0 there is also a query governor - this is available in enterprise manager, right click on the server, select properties, server settings .. 'user query governor to prevent queries exceeding specified cost'.

--
Tony Rogerson MCP,SQL Server MVP
Torver Computer Consultants Ltd.

Home page: www.sql-server.co.uk (under construction)

Steve Cogorno <cogorno_at_netcom.com> wrote in message news:7l93po$jo5_at_dfw-ixnews9.ix.netcom.com...
> In article <930607826.300.90_at_news.remarQ.com>,
> An Unhappy Microsoft Customer <unhappy_at_microsoft.com> wrote:
> > 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?
>
> Well, it isn't a bug. Microsoft never claimed to have resource controls.
> But, I agree with you that resource management is essential if you want to
be
> able to provide a guaranteed level of service.
>
> Sybase Adaptive Server has this feature. It is called the Resource
> Governor. If you consider this essential functionality, perhaps you should
> look at changing database engines.
> --
>
> Steve
> cogorno_at_netcom.com
Received on Tue Jun 29 1999 - 07:07:30 CDT