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 2000 Forums
 MSDE (2000)
 MSDE Slow

Author  Topic 

FragTop
Starting Member

1 Post

Posted - 2003-08-07 : 19:23:36
I just started using MSDE and am using the setup.exe that came with MSDE (from the SQL 2000 CD) to perform the installation. When I use the database on the client machine it is PAINFULLY slow. However, if I then install the SQL Client tools on that same PC the database speeds up incredibly. It even appears that then uninstalling the client tools still leaves the database running great.

Did I miss something in the setup of MSDE that would cause it to run slowly? I have rebooted, made sure all services are running, etc ,etc to no avail.

ANY help is greatly appreciated.

Thanks,
Brad

nr
SQLTeam MVY

12543 Posts

Posted - 2003-08-07 : 19:30:19
Bit weird.
Does a different version of mdac get installed with the client tools?
Are you installing sp3 for msde? (you should)

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -