Tuning and viewing SQL Server reports
Home > IT Answers > SQL Server > Tuning and viewing SQL Server reports
SQL Server Ask the Experts
2445 pts.
0
Q:
Tuning and viewing SQL Server reports
SQL Server Reports, SQL Server performance tuning, SQL Server performance
I have developed several reports and deployed on the remote server. While running reports on a browser, it takes about 20 to 30 seconds, but when i browse the same on the remote server, reports get displayed in 5-8 seconds. Do I need to tune my server to enhance its performance, and how should I do so?
ASKED: May 1 2009  7:23 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: May 1 2009  7:23 PM GMT by SQL Server Ask the Experts   2445 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46765 pts.  |   May 2 2009  8:22PM GMT

My first question becomes how much data is in the report, and how fast is the network between you and the report server?

My second becomes does the report take the same amount of time to run every time, or just some times?

 
0