• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Giving a Sql Query a Priority

We are running an app, that uses a lot of the CPU. While that app is running we want to run reports that hit the database hard as well.  Is there a way to put the Reports at a lower priority, so the app isn't affected so much?
1 Solution
Gustavo Perez BuenrostroCommented:
Unfortunately there is no way to do what you want. You can try using WAITFOR statement in the code of Reports.To get more detail see “Using WAITFOR” topic in BOL.

PD: Let me know if you need a better advice.


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now