We help IT Professionals succeed at work.
Get Started

Slow SQL Server?

475 Views
Last Modified: 2012-05-11
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???
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 6 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE