Multiple Server CPU
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).
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).
This discussion has been closed.
Comments
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