SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 slow reports time out
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

backend
Starting Member

8 Posts

Posted - 03/21/2013 :  16:34:34  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 03/22/2013 :  01:40:41  Show Profile  Reply with Quote
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

355 Posts

Posted - 03/22/2013 :  12:30:49  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 03/22/2013 :  13:17:54  Show Profile  Reply with Quote
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

355 Posts

Posted - 03/22/2013 :  13:51:21  Show Profile  Reply with Quote
how come it doesn't work for only 2 users? and works for the rest?

Edited by - basicconfiguration on 03/22/2013 16:26:24
Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

355 Posts

Posted - 03/22/2013 :  13:52:21  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 03/22/2013 :  14:08:44  Show Profile  Reply with Quote
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

355 Posts

Posted - 03/22/2013 :  16:26:09  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000