performance degradation on data transfer

Hello guys,

Wonder if any of you could help me out here. I have just created an
new empty database and imported data from another database into it.
This was done with the import wizard from MMC.

First thing that I noticed was the size difference, the old database
was well over 1GB, but the new one was only about 400MB.

Second thing I've noticed, and this is the problem, is that accessing
the new (smaller) database instead of the old one causes a huge speed
degradation, about 5 times slower than the old version.

We are using MS SQL Server 7. Any help would be very gratefully
received.

Regards

Gethyn"Gethyn" <geth@.blueyonder.co.uk> wrote in message
news:34b76a2b.0401080147.77d51187@.posting.google.c om...
> Hello guys,
> Wonder if any of you could help me out here. I have just created an
> new empty database and imported data from another database into it.
> This was done with the import wizard from MMC.
> First thing that I noticed was the size difference, the old database
> was well over 1GB, but the new one was only about 400MB.
> Second thing I've noticed, and this is the problem, is that accessing
> the new (smaller) database instead of the old one causes a huge speed
> degradation, about 5 times slower than the old version.

One possibility is that indices were not moved over.

Also, the hardware could be different.

Finally, try a UPDATE STATISICS.

> We are using MS SQL Server 7. Any help would be very gratefully
> received.
> Regards
> Gethyn

Performance

New PE2800 3.2gb Xeon, 2gb ram, sql 2005 workgroup ed.

I have a db that has been imported from access. One of the tables has a 1.8 million records. It takes a couple of minutes to pull this data up from the sql manager whereas in access it only took a couple of seconds. Other tables take longer to pull-up in sql as well. If I use access to connect to the sql server and and pull up this long table, it doesnt take as long as the sql manager but it still takes a lot longer than the access db does to pull up the same info.

Why does this very basic query take so long?

It also utlizes 50-70% of processor time while it trying to return these records.

I cant seem to find a good explaination for this behavior?

Thanks,

How is the table indexed in SQL Server? Is it the same as in Access?