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 |
|
tafadzwa
Starting Member
18 Posts |
 Posted - 2008-05-09 : 04:35:30
|
| Hi all We recently upgraded from sql 2000 to sql server 2005. Our system was developed using Microsoft visual Basic. Since we upgraded to sql server 2005 our system has been very slow. I suspect that it was because of the new sql 2005 installation that i made.Does anyone know how to solve this problem for me to be able to increase the perfomance speeed of our system again.It has been stressing me for a while now.Pliz helpThanks! |
|
|
pootle_flump
1064 Posts |
Posted - 2008-05-09 : 08:10:23
|
| Check out the FAQ for upgrade tips. You need to run several routines to get an upgraded instance in tip top shape. |
 |
|
|
tafadzwa
Starting Member
18 Posts |
Posted - 2008-05-09 : 08:44:24
|
| Thanks a lot. I will try that, i hope it will work well for me |
|
|
|
tafadzwa
Starting Member
18 Posts |
Posted - 2008-05-19 : 05:04:33
|
| I rebuild the indexes, it has increased the SQL 2005 perfomance but not to my expectations. It is still rather slow. I dont know if you guys have other suggestions that i can implement.Thanks! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Perfomance speed of SQL 2005