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 |
|
roypython
Starting Member
7 Posts |
 Posted - 2007-01-15 : 00:09:37
|
| Hello.Your help is very much appreciated.I have SQL SERVER 7.0 running about 10 databases.Only 1 database is problematic.When running quries on the two largest tables on this database(one has 2.4 million records, the other one has 3 million records), it stops responding/times out, even if the query is run on the server itself.We do have another table(in other database, on the same server) with 15 million records, which runs slow but keeps on working.(in the past,rebooting every few days solved the probelm)It might be indexing or maybe table/record locks?What is your recommendation regarding how to find where (and later, what) the problem is? Thank youCheersRoy |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-15 : 06:13:15
|
| Sounds like something may be locking the table.Try adding this sp to master and running it to see what is happening.http://www.nigelrivett.net/SQLAdmin/sp_nrInfo.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Performane problem