Link to home
Start Free TrialLog in
Avatar of billyboy9200
billyboy9200

asked on

Slow SQL Server?

We have a doctor's office and use a propitiatory program to manage our patients.  Every system in the office is hooked to a switch with goes into our router and then server.  We only have a few computers and see maybe 20-30 patients a day.

Network speed is not an issue.

Internet connectivity/speed is not an issue.

Server speed is not an issue (quad core with 8GB of memory -- only a few years old).

When we go to access our software, it loads fine.

However, when we try to pull up and manipulate client data (add appointment, add client, et cetera) it is extremely slow.  I know it runs off the SQL server on our W2K3 server and all the data is stored locally.

The company that built this has horrible tech support.

Can someone offer some "good practices" to maintain SQL database?  Something to look for....to speed up SQL access/read/write???
ASKER CERTIFIED SOLUTION
Avatar of twol
twol
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
SOLUTION
Avatar of Imran Javed Zia
Imran Javed Zia
Flag of Pakistan 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
SOLUTION
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
SOLUTION
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
SOLUTION
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
SOLUTION
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