<div>
<div class="content wysiwyg-content">
We have a doctor's office and use a propitiatory program to manage our patients. &nbsp;Every system in the office is hooked to a switch with goes into our router and then server. &nbsp;We only have a few computers and see maybe 20-30 patients a day.<br />
<br />
Network speed is not an issue.<br />
<br />
Internet connectivity/speed is not an issue.<br />
<br />
Server speed is not an issue (quad core with 8GB of memory -- only a few years old).<br />
<br />
When we go to access our software, it loads fine. <br />
<br />
However, when we try to pull up and manipulate client data (add appointment, add client, et cetera) it is extremely slow. &nbsp;I know it runs off the SQL server on our W2K3 server and all the data is stored locally.<br />
<br />
The company that built this has horrible tech support.<br />
<br />
Can someone offer some &quot;good practices&quot; to maintain SQL database? &nbsp;Something to look for....to speed up SQL access/read/write???
</div>
</div>


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???

Slow SQL Server?

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.