troubleshooting Question

Slow SQL Server?

Avatar of billyboy9200
billyboy9200 asked on
Windows Server 2003Microsoft SQL Server 2005
6 Comments6 Solutions479 ViewsLast Modified:
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 speed up SQL access/read/write???

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 6 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 6 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros