Re: query Execution time-out settings

Of course you can make such a change.

Please recognize that several activities, including reporting, usually
require longer running queries, and your proposed change may cause those
other activities and reports to mal-function.

Using Profiler, you should be able to identify the blocking queries
relatively easily.

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"James" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11D15332-D7BC-4694-A3BB-15EB8F428406@xxxxxxxxxxxxxxxx
In order to stop some occasional blocking issues could I set the "query
execution time-out settings" to 30 seconds for example. I understand it
will
kill the queries that exceed 30 seconds, but I would rather have that then
to
have everyone "lockup". I also understand that blocking is caused by some
ineffecient queries, however untill we identify the problematic queries I
would like to kill the blocking automatically.

Thanks for any help.
James


.

Relevant Pages

  • Re: Indexing Star Schemas
    ... Are you reporting directly from the data warehouse or building ... If you will be building cubes and reporting from them, ... > b) common queries don't always a particular other dimension, which> would mean the index would only be useful to the Time level anyway. ... > c) common queries on product and store are not very selective> ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: ow to simplify what im doing (AS the solution?)
    ... The star schema structure is relational as well ... but far more intuitive and better suited for reporting. ... by this speed up queries by actually querying your cubes, ... > experience with warehouses - and know little about analysis services ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Performance Improvements: Hardware vs. DB Design
    ... >>database with a substantial amount of data, ... I think many companies are inclined to add more server ... > the queries, revise the indexes if necessary, and verify the reporting ... Does the reporting tool bring back large result sets ...
    (microsoft.public.sqlserver.server)
  • Re: Import data from ODBC
    ... You could have a process that runs Make Table Queries that pulls the ... system just doesn't have the tools to provide the kind of reporting we need. ... my plan is to use access in order to import the data from the system ... database and then make our own reports, ...
    (microsoft.public.access.externaldata)
  • RE: Default for unbound "Month" combobox
    ... Amount - Number ... Reporting Date - Date/Time ... I would be happy to reduce the number of queries but don't know how. ... retrieve all records from "Received" for this month ...
    (microsoft.public.access.forms)
Loading