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 |
|
patrick1140
Starting Member
1 Post |
 Posted - 2008-03-10 : 05:12:38
|
| Hello,I've migrated an DB from SQL2000 to SQL2005, all it's working, but i've a "strange" problem, during the night, the transactions become very slow (no specific load) and if i restart service or I change the Degree of parallelims or Cost Threshold for parallelims to another value, it's solve the problem.In the server logs (W2003) and SQL logs I can't see an warning or error...In the old SQL 2000 server i've no problem...If anybody can help me .. :-) |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-10 : 05:37:17
|
Did you reindex all indexes?Did you update your statistics?Have you set the compatibility level to 90?Which edition and version of SQL Server did you use before?Which edition and version of SQL Server do you use now?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 19:37:46
|
| Looks like you are changing server properties.Donot change it ,it will affect performance. How much memory is allocated in new server? Are there any applications running beside SQL server in that box? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-09 : 22:37:04
|
| Did you see blocking? |
|
|
|
|
|
|
Sql2005 transaction become very slow