Spring Clean your SQL Server

SQL Server Performance Tuning

Now could be the time to think about Performance Tuning your SQL Server.  Sequallity has 18 years experience of doing just that.  We will monitor your current performance and recommend a course of action to improve the productivity of your SQL Server.  We can then help you implement the suggested changes or train you to effect the implementation.

Tuning databases for performance

There are a few tips and tricks for how we monitor and tune your database.  SQL Server provides utilities to view the current condition of the database and track performance as conditions change. There are a variety of tools and techniques we use to monitor SQL Server.

  • We monitor the response times for frequently used queries, we then determine whether changes to the query or indexes on the tables are required.
  • We evaluate application activity. By monitoring applications trying to connect to an instance of SQL Server, we can determine whether one application is having more of an impact than another application.
  • We troubleshoot problems or debug SQL Server components, such as stored procedures and views.

Monitoring in a dynamic environment

Changing conditions result in changing performance. In our evaluations, we can see performance changes.  This could be as the number of users increases, user access and connection methods change, databases and tables grow, client applications change and queries become more complex with new functionality, new releases.

We monitor the response times for frequently used queries, we can determine whether changes to the query or indexes on the tables where the queries execute are required.

  • We monitor Transact-SQL queries as they are executed, we can determine whether the queries are returning results optimally.
  • Response time is the length of time required for the result set to be returned and throughput is the total number of queries handled by the server during a specified period of time.
  • As the number of users increases, so does the competition for a server’s resources, which in turn increases response time and decreases overall throughput.

Our Tips for Performance Tuning

  1. Monitor SQL Server Components
  2. Performance Monitoring and Tuning Tools
  3. Establish a Performance Baseline
  4. Isolate Performance Problems
  5. Identify Bottlenecks
  6. Server Performance and Activity Monitor
  7. Regular maintenance (intelligently designed)
  8. Display and Analyse Execution Plans
  9. Utilise New Features of SQL Server
  10. Amongst many others…