Link to home
Start Free TrialLog in
Avatar of bluetab
bluetab

asked on

TimeMatters 11.1 Performance Issues

We just moved TimeMatters 11.1 to a new server for a client.  Everyone in the office used to login to a Terminal Server and access TimeMatters & Office.  TM was installed locally here and there were no performance issues.  Now that TM is on a new server we have everyone using their own desktop and accessing their programs that way instead of through a Terminal Server.  What is now happening is that the TimeMatters often becomes unresponsive where the users have to wait 5-10 seconds before it will open a file they have clicked on.  

Host Server: SBS 2011 (20 GB memory), SQL 2008 R2
Workstations: XP & Windows 7

I'm guessing that there are some configuration settings I may need to tweak in SQL but I don't know.  Any insight would be appreciated.

Thanks,
Scot
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bluetab
bluetab

ASKER

Sorry I didn't respond sooner.  The problem seemed to resolve itself Tuesday night and we've been checking things to make sure everything remained OK.  The db sits on the SBS server and is only 2GB.  We don't know why everything started to perform betterTuesday night.  The server was rebooted Monday night after installing updates and reindexing the db.  The only thing we can think of is that there was something on the network that was tying up the network.
and reindexing the db.
That was one of my questions.  Just a word of caution, you may find that performance will degrade again unless you are prepared to be proactive doing maintenance on it.
Avatar of bluetab

ASKER

Thanks.  I had done a re-index just after importing the db to the new server.  We'll definitley monitor the performance as time goes on.  It's rather confusing to me that all of a sudden that after a 10 days the performance of the db all of a sudden improved so drastically.
Avatar of bluetab

ASKER

None of these questions pertained to the answer as far as I know, but I appreciate the response. Thanks...