SQL Server very slow for just one user

[LScharf]

Hi,

I've been using SQL Server 2000 for over a year with no performance issues. Suddenly for the last week it's been quite slow (even switching databases takes 5 seconds, as opposed to 0), but only when I'm logged in on my PC (Windows 2000) with my profile. My coworker has no trouble on his machine (WinXP) under his profile AND my profile; if I log in as Admin on my machine I have no problem.

Any ideas? Thanks.

 

[drtree]

Hi,


I have an Access database that serves as the database for a website. It is an Online Community type website, where users can update their information, search for other users, etc. Each morning, a data entry person will come in, run some reports (in Access) and get a list of all the changes that were made in the last day to the Community database. This data will then be entered into a SQL Server database. I am supposed to set up a nightly process that exports data from SQL Server to this Access database. I have the export process setup (using DTS) but just have one concern - what if the data entry person is out? My concern is that someone will log on, update their data, and then log out. This data, since the entry person is out, will not get put in the SQL Server system. If someone else went into the SQL Server database and made an edit to the same person’s record, the information in the SQL Server database could be used to update the information in the Access database (possibly losing all the updates the person made). I was thinking about creating another DTS package and retrieving any changed data and placing it in SQL Server - in essence creating a set of change history tables. My question is this - is it worth it? Is there a better way to do this?

Thanks,

Dr Tree

 

[drtree]

Sorry - I meant to post this as a new message.