Novice, recently installed sql2005, click to enter soon after installed, see also soon, currently has more than ten thousand rows of data, click on the landing slowly, open the table is very slow, and connect to the database all software today have a few minutes all card dead,

CodePudding user response:

Look at the machine CPU, memory utilization rate is very high, if not, then may be great SQL deadlocks.

CodePudding user response:

Do a rebuild index to try again

CodePudding user response:

May be network problems

CodePudding user response:

More than ten thousand data, use index has little to do,
You the biggest possibility is blocked or deadlock,
https://blog.csdn.net/yenange/article/details/73883915