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 |
|
sibakl_2001
Starting Member
5 Posts |
 Posted - 2008-03-16 : 22:43:54
|
| Hi i use sqlserver2000 i have 200 records in my database table some times i can access and some time i cannot execute the select query return the timeout error why this happen anybody know solution for this help me |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-16 : 22:49:17
|
| Maybe blocking, double check with 'sp_who2 active'. |
 |
|
|
sibakl_2001
Starting Member
5 Posts |
Posted - 2008-03-16 : 23:14:10
|
| Hi i try select * from service query since today morning it takes long time to execute but not completed but now the same query executed successfully and very fast why this happen any solution |
|
|
|
sibakl_2001
Starting Member
5 Posts |
Posted - 2008-03-16 : 23:15:50
|
quote:
Originally posted by rmiao
Maybe blocking, double check with 'sp_who2 active'.
how to double check with 'sp_who2 active' help me i don't know how to do this don;t mistake me |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-16 : 23:19:52
|
| Just run it in query analyzer when you feel your select is slow, check if any value under blocked by column. |
|
|
|
sibakl_2001
Starting Member
5 Posts |
Posted - 2008-03-16 : 23:33:43
|
quote:
Originally posted by rmiao
Just run it in query analyzer when you feel your select is slow, check if any value under blocked by column.
hi i tried this on sqlquery analyser but it takes long to execute if i stop the execution return only 65 recordsi can't understand this 'check if any value under blocked by column.' |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-16 : 23:51:43
|
| check activity monitor for blocking and find which spid is blocking with DBCC inputbuffer(spidid) |
|
|
|
sibakl_2001
Starting Member
5 Posts |
Posted - 2008-03-17 : 00:48:48
|
quote:
Originally posted by sodeep
check activity monitor for blocking and find which spid is blocking with DBCC inputbuffer(spidid)
how to do this guide me |
|
|
|
|
|
|
sql select