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 |
|
binto
Yak Posting Veteran
59 Posts |
 Posted - 2010-04-19 : 07:51:58
|
| Hi All,I am having a table with 1m data.While inserting data using procedurethrough application,I am getting 'Server Time out' error in application.This is not happening everytime.I cannot identify the issue.Hw can I solve the issueThanks & RegardsBinto Thomas |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-04-19 : 08:33:21
|
| it is not related to database issue. u can post in the related appliation forums. |
 |
|
|
binto
Yak Posting Veteran
59 Posts |
Posted - 2010-04-19 : 08:36:15
|
| This is due to Table Lock.I have identified the same.how can I manage Table Lock when insertion and reading are simultaneousely done on a tableThanks & RegardsBinto Thomas |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-04-19 : 08:39:43
|
| while reading the data from the table use with(nolock) select * from tablename with(nolock) in all the sps. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-19 : 08:43:12
|
| You should NOT use "NOLOCK" hint unless you are fully aware of the potentially disastrous consequences that might occur.If you are using SQL2005, or later, then use READ_COMMITTED_SNAPSHOT which will help where READs are blocking WRITES, but without the side effects of NOLOCK. |
|
|
|
|
|
|
Server Time Out Issue