SQL Performance Tuning

SQL Server Performance


Improve performance and
scalability of your SQL databases.

sql database performance

SQL Server Performance Tuning

SQL Server Performance and SQL tuning - SQLXL

What is a SQL server?

Microsoft® SQL Server is a popular and widely-deployed relational database management system (RDBMS) developed by Microsoft. Its primary function is to manage your business' SQL databases by storing and retrieving data as requested by your technicians or by other software applications which may be running on your business' computer network or the Internet.

The term 'SQL Server' may also refer to a specific installation of the Microsoft® SQL Server software on your business’ computer network.

What factors affect SQL server performance?

There are many factors which affect SQL server performance. These factors may seem strange to those unfamiliar with SQL tuning, but experienced SQL professionals will readily identify them. The SQL server is a software system with a well-defined internal structure that can be optimized to deliver better performance results in certain areas (SQL performance tuning), even though minimum hardware configurations are required for optimum SQL server performance.

The minimum hardware requirements for optimum SQL server performance are as follows:

a.) CPU: Ensure you go for a server that is able to expand the number of CPUs it is using. A cardinal rule here is to always anticipate growth. So for example, if testing shows you can use a server with one CPU satisfactorily for your workload, it would still be ideal to go for a server with room for two CPUs to allow for future growth.

b.) Memory: This is possibly the single most important hardware consideration for optimum SQL server performance. In the best possible situation, your entire corporate database(s) should fit into the available RAM. This is hardly the case however, so a rule of thumb is to ensure that the largest table you can expect to have will fit into the available RAM. Memory is cheap, buy as much as you can.

c.) I/O subsystem: Always ensure that you have many drives in your array, as the I/O speed generally increases with the number of drives. A valuable point to note here is that it is better to go for many small-size drives than to select few large-size drives. This significantly affects SQL server performance.

d.) Network Connection: It would be advisable to have at least one 100Mbs network card connected to a switch. In an ideal case, two network cards in the server can be connected to a switch in full-duplex mode. If clients are connecting remotely, ensure the queries return on the required information so as to reduce bandwidth requirements. This also contributes to optimum SQL server performance.

What is SQL tuning?

SQL server performance tuning or SQL performance tuning or just simply SQL tuning, refers to a number of techniques usually employed by DBAs (Database Administrators) to improve the efficiency and performance of the SQL Server and the various SQL databases by making certain changes to the configuration of the SQL Server itself and tuning the queries and indexes on the database.

SQLXL provides these SQL performance tuning services to businesses in order to help them improve the performance, reliability and scalability of their corporate databases:

  • Identify hardware bottlenecks.
  • Identify and tune expensive queries.
  • Identify unused or rarely-used indexes.
  • Fine-tune queries to take advantage of existing indexes.
  • Identify tables that require additional indexing.
  • Identify inefficient data types and recommend alternatives.
  • Design and implement maintenance routines to keep SQL running smoothly.

SQLXL now provides a free consultation for businesses. Please feel free to CALL us on 1 613 822 1997 or send an email to sales@dthsoftware.com to get started. We look forward to your feedback.

Get Started with Your Free Consultation.