| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-04-11 : 10:37:35
|
| Guys,In simple terms, our system is as such: We have a website. As someone clicks a button on the website, a stored procedure is executed against our database. Every single day, between 12:15AM and 12:45AM we have a few stored procedures timing out, with the following message, for example:2007-04-10 00:37:03,268 [3632] ERROR Service - caught exception Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)I checked and saw that although there are jobs running at that time, all of these jobs are running periodically (e.g. every 30 minutes) and would cause timeouts at other times as well, if they were to blame. Other jobs are running at far away times and checking their history I know that their duraion in no way intersects the time-out times. I also ran profiler during peak hours and know that no stored procedure of ours has a duration anywhere near 30 seconds (which is the currently set timeout period, although all of our sps run within milliseconds).I am really puzzled as to what exactly is causing these timeouts. Would anyone suggest any approach to identify the problem. For example, I thought about running profiler (server side tracing) between 12AM and 1AM, but am not sure which counters are best to capture. Any suggestion on this?Thanks a lot! |
|
|
pootle_flump
1064 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 13:34:24
|
| sql_er,Pick one site to post at. Until you do that, I will not be posting answers to your questions. I am not going to register at different sites to figure out if your question has been answered already or if other posters have asked the same questions.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-04-11 : 14:23:05
|
| Hmm ... I thought the idea is to share knowledge and learn. I am registered at different places, and post questions here and there and answer questions at all the different places. Why do we have to choose a single source? Is this a requirement of any forum?Every time I got a satisfactory answer for some question from any place, I tried to post a reply anywhere I asked the question, so that others could learn as well. I thought that this way poeple would learn from other people. Isn't that the idea? What am I missing here?I apologize if this approach seems improper to some folks here.Thanks a lot! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 14:30:17
|
| It is considered bad forum netiquette.I'm all for sharing knowledge and learning, however I'm not for wasting my time on a question that possibly a few other people are already working on. Since you are a notorious cross-poster, that means we have to figure out where else you posted your questions, then check all of those links to see if they've already answered back with the same solution or asked the same questions to you. We do this for free. I don't have the time to check out your other same posts at different sites.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-04-11 : 15:43:56
|
| Tara,I respectively disagree with this point of view. I might not know as much as you, but I help as much as I can to all, in all the different places. I do this for free too. And I don't mind at all if someone posts somewhere else - I'd be glad if others are working on this problem, so that we can share our thoughts and solutions.Thank you for all your help in the past (you have been very helpful). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 15:48:17
|
| But you haven't shared with us what the other people have said yet in your other posts! So this goes against what you are saying. I'm not going to register with these sites to find out what's been done yet. So please inform us.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-04-11 : 16:03:22
|
| Tara,As mentioned earlier, I tried my best to share - not every single thing - but useful information, once the conclusion was reached [i.e. satisfactory result was found], as long as I saw that people were still thinking about it. Those registered in other places can confirm that. In case I missed out in some cases, I apologize - intentions were good though. And I don't just ask questions, I try to give back as well, as you can see yourself.Thank you |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 16:41:34
|
| You missed my last point. Please tell us what the other sites have told you so far for your current problem. I don't want repeat anything that they've already asked or had you do.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-04-11 : 17:23:58
|
| Tara,I would prefer not to continue this discussion. It is wasting my time, as well as yours, as well as of those who will be reading this thread. I don't think the results of this discussion are adding any value to the knowledge of this forum.Please re-read what I have written above in regards as to when I would normally post the information I gained somewhere else.Thank you very much and apologies to all for talking off the topic here ... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 17:53:43
|
| I can offer no help on this topic then as you are unwilling to tell us what has been discussed in your other posts for your current problem. I am not going to register at those other sites just to figure out what has been discussed already.Good luck.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
Stored Procedure timeout mystery ...