SQL Upkeep

Document Management: Improving SQL Server Performance

Several factors can affect SQL Server performance. This document describes some of the steps that can be taken to improve performance.

SQL Server Edition

System Processor

  • Always use the fastest possible CPU
  • Use a multi-core processor if possible
  • Configure your SQL server to make use of all available CPU cores on the machine
  • Use an edition of SQL Server which can use all available CPUs

64-bit Systems

  • If you have a 64 bit machine, install the 64 bit version of Windows OS and SQL Server. This will allow the SQL Server to access large amounts of memory where available (more than 4 GB)
  • Note that most 32 bit systems are limited to a maximum of 4 GB of memory

System Memory

  • Install more memory (RAM) on the SQL Server machine
  • On 32 bit systems, install a maximum of 4 GB of memory
  • You can install more than 4 GB on 64 bit systems
  • Use an edition of SQL Server which can make use of all available memory

Server Role

  • Use a dedicated server for the SQL database if possible
  • Avoid sharing the server with other functions such as Exchange Server or Domain Controller

Network Speed

  • Network speed affects the speed at which users can access data and files
  • Installing a 1000 MB network instead of a standard 100 MB network will make a huge difference to network access speed

Hard Disk

  • If possible store the SQL data files on a separate hard disk from the main system disk. (Using a separate hard disk controller for the second drive can also make a difference in performance)
  • Always use a NTFS partition to store SQL data (avoid FAT32 partitions)
  • Regularly defragment the data disk
  • Use the fastest possible hard disk controller and disk that you can

Re-building SQL Indexes

  • Regularly re-building the File Stream data indexes can help with speed of searches. This can be done easily from the Administration functions in File Stream
  • Try to re-index the data on a weekly or fortnightly basis

Truncating Log Files

  • Regularly backing up the SQL data and truncating the log files helps keep the files to a manageable size which helps with performance
  • The built-in backup function in File Stream Administration or in the Scheduler will automatically carry out log file truncation
  • If you use some other direct method of backing up your SQL data, then you should run the built-in backup feature periodically to ensure that the log files do not become uncontrollably large in size.

Regular SQL Database Maintenance Tasks Details

If you have any questions regarding the technical side of our software, please do not hesitate to get in touch.

File Stream Document Management

Introductory Video

Watch our Demo Video for further details.

Technical

Further information about the technical aspects of File Stream.

Product Benefits

Adherence to GDPR Compliance

 

Secure Software (Including Encryption)

 

Disaster Recovery

 

Integration to Existing Systems (Including Accounts)

 

A secure Archive but also document processing capabilities

 

Complete Scalability

 

Complete Flexibility

 

Scanning Solution

 

Clear Upgrade Plans

 

Need more information? Speak to one of our experts.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close