Re: Limit server resources per query

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 14:44:50 -0500

There is no option such as the one you describe but you can add MAXDOP hints
to the sql statements that will limit the number of processors used by the
query. So if you have 4 procs you can set it to 2 and leave 2 for the other
users. It may take longer but should be more respectful of the other users. 

-- 
Andrew J. Kelly  SQL MVP
"Weston Weems" <anonymous@discussions.microsoft.com> wrote in message 
news:0ae401c51848$8b06fc90$a501280a@phx.gbl...
> Hello,
>
> I've got a huge query that takes a fair amount of time to
> run, and ideally this query will be run in the middle of
> the night, so I wont have any issues with any customer
> facing applications...
>
> However in testing, I need to develop this report in the
> daytime, and dont have the liberty of having a development
> server. I was curious if in a sql statement, I could
> specify that I'd rather have a query take longer, than
> prevent other applications from being able to process data
> in a timely fashion. (I get timeouts etc in the other apps)
>
> As it sits this query takes about 4 minutes on a quite
> fast sql server, and I dont mind it so much, but it seems
> in that 4 minutes, other services are really hurting.
>
> Thanks in advance,
> Weston Weems

Relevant Pages

  • Re: SELECT * or list fields?
    ... SELECT * is used in a query. ... As reagards maintenance, adding columns to the table is not so bad but ... As regards SQL statements ('query' is often used in the ...
    (microsoft.public.access.queries)
  • Re: max_allowed_packet in PostgreSQL
    ... can be determined with the following query: ... Is there a similar limit for PostgreSQL or any other DBMSs? ... if your SQL statements are long because of long character strings, ... Note that MySQL has another tuning parameter that affects bulk inserts. ...
    (comp.databases)
  • Re: SELECT * or list fields?
    ... As reagards maintenance, adding columns to the table is not so bad but ... Issues range from having to change code that consumes the query ... As regards SQL statements ('query' is often used in the ...
    (microsoft.public.access.queries)
  • Re: Query will not populate with data
    ... Consider posting the SQL statements of your three queries... ... I then created a query that combined the two mentioned above. ... query does not populate properly. ... I need to connect to the Client table via the NFS_Data table and the ...
    (microsoft.public.access.queries)
  • RE: run SQL SELECT query in vba
    ... > can not construct & run simple SELECT SQL statements ... > checkmark the "Microsoft DAO 3.6 Object Library"? ... > selects criteria to query my tables by. ... > So I was thinking about writing vba code ...
    (microsoft.public.access.queries)