Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 slow reports time out

Author  Topic 

backend
Starting Member

8 Posts

Posted - 2013-03-21 : 16:34:34
i have a problem with the front end application that connects to a sqlserver db. we have tons of users in the database. when we click on a user name on the application it displays a report (very complex-just trying to simplify it and give u a picture of it). We found so far 2 users that when we click on the name it wont display a report and it times out after 30 seconds. Any ideas how to troubleshoot it?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-22 : 01:40:41
first thing is to see if you can optimise the query behind report uses to retrieve results quickly
Secondly you could increase timeout value for the server in configuration properties.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2013-03-22 : 12:30:49
query looks good. time out cannot be change cause it's hardcode and it works in a different server very well.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-22 : 13:17:54
then update statistics of the db. that might be a reason.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2013-03-22 : 13:51:21
how come it doesn't work for only 2 users? and works for the rest?
Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2013-03-22 : 13:52:21
i think if statistics are outdated the execution plan will suck. in this case the highest cost is only 2%
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-22 : 14:08:44
quote:
Originally posted by basicconfiguration

how come it doesn't work for only 2 patients? and works for the rest?


is patients a parameter?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2013-03-22 : 16:26:09
quote:
Originally posted by visakh16

quote:
Originally posted by basicconfiguration

how come it doesn't work for only 2 patients? and works for the rest?


is patients a parameter?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





Sorry, users I meant
Go to Top of Page
   

- Advertisement -