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 |
|
Senthilprakash
Starting Member
1 Post |
 Posted - 2009-03-16 : 22:53:34
|
| Dear All,We are facing a isssue in our PRD environment.when ever i try to execute a query in our Client databse (SQL2000 with SP4) via remote login. The query is in Executing state for long time and still its in the same state.(It has been more than 50 min now). below is the simple query i executed:SELCET TOP 5 * from <table_Name>why the above simple query is taking this much time to execute?is there any issue with the Database?How to rectify the problem and whats causing the problem?Please Advice,Thanks and Regards,Senthilprakash. |
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2009-03-17 : 03:33:00
|
quote:
Originally posted by Senthilprakash
Dear All,We are facing a isssue in our PRD environment.when ever i try to execute a query in our Client databse (SQL2000 with SP4) via remote login. The query is in Executing state for long time and still its in the same state.(It has been more than 50 min now). below is the simple query i executed:SELCET TOP 5 * from <table_Name>why the above simple query is taking this much time to execute?is there any issue with the Database?How to rectify the problem and whats causing the problem?Please Advice,Thanks and Regards,Senthilprakash.
hihow u r connecting the server via odbc or some else...ravi |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-03-17 : 04:00:24
|
| Are you getting this issue only for specific table? Try below:SELCET TOP 5 * from <table_Name> (nolock)Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
SQL Query TimedOut: