|
|
|
Database Performance Tuning Services.
|
|
Does your new application running since implementation without
a hitch begins to exhibit signs of stress?
Do a few users occasionally complain about slow response times.
Are some user requests simply blocked and not getting through at certain times of the
day,. Is your application suddenly "too busy" and it hangs?
If the answer to one or more of these questions is positive, you have a database or application
performance problem. Vigilant performance monitoring will ensure that your
application continues to provide its intended service.
|
|
|
As your enterprise application changes over time, it must handle more users,
heavier transaction workloads, increased network traffic, and larger, more
complex databases. Data access throughput becomes a primary concern because each
increase in the workload requires additional computer and network resources.
|
|
We provide the following performance tuning services:
 Automate performance tuning and develop SQL Server maintenance plans
Recommend hardware specifications (hard-disk, RAM, ...)
Create and maintain good indexes
Optimize sql queries in server side stored procedures and client applications
Monitor database performance
|
|
Our approach
|
>> Let SQL Server take care of most of the tuning work.
We will configure your SQL Server dattabase to take advantage of
auto-configuring and self-tuning settings by creating database maintenance plans.
This helps SQL Server to run at peak performance even as user load and queries change
over time.
>> RAM is a limited resource.
A major part of any database server environment is the management of random
access memory (RAM) buffer cache. Access to data in RAM cache is much faster
than access to the same information from disk. But RAM is a limited resource. If
database I/O (input/output operations to the physical disk subsystem) can be
reduced to the minimal required set of data and index pages, these pages will
stay in RAM longer. Too much unneeded data and index information flowing into
buffer cache will quickly push out valuable pages. The driving focus of
performance tuning is to reduce I/O so that buffer cache is best utilized.
>> Create and maintain good indexes.
A key factor in maintaining minimum I/O for all database queries is to ensure
that good indexes are created and maintained.
>> Monitor disk I/O subsystem performance.
The physical disk subsystem must provide a database server with sufficient
I/O processing power in order for the database server to run without disk
queuing. Disk queuing results in bad performance. This document describes how to
detect disk I/O problems and how to resolve them.
>> Application and Query Tuning.
This becomes especially important when a database server will be servicing
requests from hundreds or thousands of connections through a given application.
Because applications typically determine the SQL queries that will be executed
on a database server, it is very important for application developers to
understand SQL Server architectural basics and how to take full advantage of SQL
Server indexes to minimize I/O.
>> Take advantage of the powerful combination of SQL Server Profiler and Index
Tuning Wizard.
SQL Server Profiler can be used to monitor and log a SQL Server's workload.
This logged workload can then be submitted to SQL Server Index Tuning Wizard so
that index changes can be made to help performance if necessary. Regular use of
SQL Profiler and Index Tuning Wizard helps SQL Server perform well as the
overall query workload changes over time.
>> Monitor SQL Server Performance Monitor to detect bottlenecks.
SQL Server provides a revised set of Performance Monitor objects and
counters, which are designed to provide helpful information for monitoring and
analyzing the operations of SQL Server. This document describes key Performance
Monitor counters to watch.
For additional information, see Microsoft site for SQL Server Performance Tuning |
|