Upgraded from sql 2000 to 2005

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Upgraded from sql 2000 to 2005

Author

Topic

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-09 : 04:31:19

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 help

Thanks!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-10 : 20:38:38

Did you rebuild indexes after upgrading?

nathans
Aged Yak Warrior

938 Posts

Posted - 2008-05-11 : 00:30:58

yup, update stats post-upgrade

look into

sp_updatestats

and

dbcc updateusage

lots of info here: http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Nathan Skerl

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-12 : 04:33:24

quote:
Originally posted by rmiao

Did you rebuild indexes after upgrading?

No i didnt rebuild my indexes. I will try and do that and see if it works.

Thanks guys, i really appreciate.

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-19 : 04:57:42

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

Posted - 2008-05-19 : 05:08:41

Did you also change hardware? Or did you reinstall on same machine?
And if you did, what is the compatibility level?

E 12°55'05.25"
N 56°04'39.16"

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-05-19 : 06:27:57

Have you installed all servicepacks?

--
Lumbago

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-19 : 08:23:53

I try that and i will let you guys know.

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-19 : 08:24:36

Thanks hey!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-19 : 08:46:17

You're welcome.

E 12°55'05.25"
N 56°04'39.16"

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-26 : 04:29:13

quote:
Originally posted by Lumbago

Have you installed all servicepacks?

--
Lumbago

Hi Lumbago

Which Service Packs must i install to increase the perfomance speed of my MS SQL Server 2005 database (Workgroup Edition)? I only know of SP2.

Thanks!

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-05-26 : 06:22:28

SP2 is the one...

--
Lumbago

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-26 : 06:25:32

quote:
Originally posted by Lumbago

SP2 is the one...

--
Lumbago

Thanks a lot. Really appreciate.

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-26 : 06:33:44

Hi Guys

When i run queries in my SQL Server 2005 database they execute very fast. However since my user interface (system) was written in Microsoft Visual Basic (VBA) which is the one connected to my sql server database, if you try to run queries here they execute very slow. I dont know if this may help to give you a better picture why my SQL 2005 is perfoming very slow.

Thanks guys.

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-27 : 03:01:15

quote:
Originally posted by Peso

Did you also change hardware? Or did you reinstall on same machine?
And if you did, what is the compatibility level?

E 12°55'05.25"
N 56°04'39.16"

Hi Peso

After re-indexing my compatibility level is SQL Server 2000 (80),
but i am working in SQL 2005. I dont know if thats were the problem is.
Please let me know.

Thanks,

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-27 : 03:13:11

Change compatibility level to 90 to make full use of SQL Server 2005.

E 12°55'05.25"
N 56°04'39.16"

tafadzwa
Starting Member

18 Posts

Posted - 2008-05-27 : 03:21:34