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 |
|
curiousxavier
Starting Member
1 Post |
 Posted - 2013-01-24 : 11:46:52
|
| I am facing performance issue.when i try to run a query it throws "Time out " but records are there in DB. It seems it is not able to delete/ or do the necessary action. please do give suggestions . |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-01-24 : 12:42:04
|
| Where are you running the query from? If it is from .Net code, there is a query timeout (and a connection timeout) that can cause this. The default value is 15 seconds if I am not mistaken. To see if that is the problem, you can try to run the same query from SSMS. Even so, if it takes 15 seconds or more, investigate why it is taking so long. It could be that the number of rows affected is very large (in which case, you could delete in smaller chunks), or may be that the rows/table is locked by some other process. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-05 : 07:44:18
|
| If the query is expected to give in more than the time out period, increase the default timeout and try firing the query again; this will work. |
|
|
|
|
|
|
Time out error