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.
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 quicklySecondly you could increase timeout value for the server in configuration properties.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
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. |
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
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? |
|
|
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% |
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
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 MVPhttp://visakhm.blogspot.com/
Sorry, users I meant |
|
|
|
|
|