| Author |
Topic |
|
knockyo
Yak Posting Veteran
83 Posts |
 Posted - 2008-11-11 : 04:49:13
|
Hi all,I have a .net application that run at the production 24hrs. 1st case: When i run the application around 2 days, next day i walk in to the production, i noticed that my application is "Out of responding". After that I closed all the application and tried to manual insert/update into the database server, it prompt me the picture below.2nd case:When I tried it on the next day again, my application available to grab the data and no more "Out of responding". I started the application from 10am, until 1pm my all application happened the same issue "Out of responding" and the database display the error below again. **Question**May I know my program/coding problem or the database server issue?Kindly help me on these.Thanks very much! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-11 : 05:12:39
|
| have you had a look at db server when this error occured see if there was some blocking happening? sp_who2 will help you to detect blocking in server. |
 |
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2008-11-11 : 05:16:26
|
quote:
Originally posted by visakh16
have you had a look at db server when this error occured see if there was some blocking happening? sp_who2 will help you to detect blocking in server.
**Questions**(1) How to check on the db server whether have blocking or not?(2) sp_who2 is what kinds of stored procedure?can you mention a bit?Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-11 : 05:25:32
|
| sp_who2 lists all the processes that are on db server . It has a column Blkby which shows detail in case process is blocked by some other process |
|
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2008-11-11 : 05:29:39
|
quote:
Originally posted by visakh16
sp_who2 lists all the processes that are on db server . It has a column Blkby which shows detail in case process is blocked by some other process
Ya i get ur means i get all the data.You need me execute it when the database faced out the problem "Timeout Expired"? Is that means? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-11 : 05:54:44
|
| yup and find out any instances of blocking |
|
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2008-11-11 : 06:15:38
|
quote:
Originally posted by visakh16
yup and find out any instances of blocking
normally if there happened any blocking, it will display what name of that particular columns.Since now my application is running as normal, i need to wait the timeout expired i only can trace it.By the way, this is the database or program issues? How can i resolve it without waiting the issue happen? |
|
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2008-11-11 : 11:56:08
|
| just now, my problem appear again, i tried your method for sp_who2, but no info is display on the blkby column.any advice? |
|
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2008-11-12 : 01:59:38
|
| can anyone have the help? :| |
|
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2008-11-12 : 17:23:12
|
| Anyone :( ? |
|
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2008-11-13 : 05:46:10
|
| if the log size is huge, will affect the timeout expired?Please advice somebody, really need help here. :| |
|
|
|
|
[URGENT] SQL Server 2005: Timeout Expired