Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 147
  • Last Modified:

Windows Server 2008 r2 -sql server 2008 r2 report server reports too slow

We have a problem.  When we run reports from the sql reporting service, they are very slow. Most of the time we have to cancel them. Besides the amount of data  in the database. Is there any service, or anything else on the server we could check to improve the running of the reports from sql reporting services.
0
Shen
Asked:
Shen
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Reports tends to be slow. What's the configuration of the box and which applications are installed there?
0
 
ShenAuthor Commented:
Microsoft server 2008 r2 enterprise x64 dell Power Edge T610 -Virtual memory12.2gb - page file  6.20gb - physical memory- 6.00 gb.

It has sql server 2008 r2.  There are few applications. Mainly we try to run the reports from the database.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can be a lot of things. I would start to check for any resource bottleneck (CPU, RAM, disk and network) plus if the queries has the necessaries indexes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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