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 |
|
kseniad
Starting Member
3 Posts |
 Posted - 2012-03-07 : 07:02:26
|
| hello,I have slq server 2005 standart with sp3 on windows xp professional with sp3 too in first computer and sql works well and queries run quickly.second computer is same by hardware and "image" of first but it has another name - that is to say I didn't install the sql on second.I renamed the sql server using:sp_dropserver <old_name>GOsp_addserver <new_name>, localGOnow the sql server on second computer works but very slowly.same simple query runs 0-1 second on first and 17-19 seconds on second.what can I do to improve the performance?or I need reinstall sql? |
|
|
kseniad
Starting Member
3 Posts |
Posted - 2012-03-07 : 09:18:41
|
| ??????? ?????????? ????????? |
 |
|
|
kseniad
Starting Member
3 Posts |
Posted - 2012-03-07 : 09:20:04
|
| solution: update statistics |
|
|
|
|
|
|
slowly running query after rename server