Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Multiple Server CPU

edited July 2005 in Server
Hello,

Our server app is running on a 4 processor machine with 8Gig internal
Memory.
The database is a SqlServer Enterprise Edition.

Even that the machine still has sufficient power we encounter from time to
time that our Reportbuilder server (running as a service) is 'hanging' on 1
report that has a very slow query. This report only runs once a month and
give fex output but the queries are 'heavy'.
While this report runs no other users can access the server.

Is this normal or is there somethign we can/should do to avoid this ??

(Server accessed by a WebTier on the same machine).

Comments

  • edited July 2005

    The Server is multi-threaded, there should not be anything that is blocking
    other reports from running. Each report should have its own database
    connection and its own thread safe environment.

    From a database development perspective, I have seen very high powered unix
    machines brought to a hault by a single runaway query. I never understood
    why this happens.

    One solution might be to generate the report to archive (.raf file) during
    off-peak hours - at night. Then make the report archive available to the
    users.



    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.