SQL Server Performance & Tuning Course

Delegates should have extensive experience with SQL Server 2000 or later and should have a knowledge level equivalent to that provided by the PTR Advanced SQL, Stored Procedures & Triggers For SQL Server course . Knowledge of basic SQL Server Administration would be beneficial.

Synopsis

Do you have SQL Server database applications that seem to be struggling to keep up with user demand or deliver information as fast as required?

Consider the following questions:

• Are your customers complaining that your system is too slow?
• Are your users complaining that tasks are taking too long?
• Are some client applications running slowly or timing out?
• Are some queries taking forever?
• Are reports running slowly?
• Is data entry taking too long?
• Is the Database Server not responding very well?
• Are your users and /or customers generally complaining that SQL
• Server based systems are not performing very well?

If the answer to any of the above is “Yes”, then you could benefit from your database administrators, developers or data analysts attending the SQL Server Performance & Tuning Course.

Database applications can perform badly for a number of reasons. Here are just some:

• Server specification not up to the job
• Network congestion
• SQL Server not configured optimally
• Database Design not perfect for the job
• Interactive users competing with Reporting/Data analyst users
• Inefficient programming code in client applications
• Inefficient Index and Locking strategies
• Inefficient query design

The SQL Server Performance & Tuning course will address all these areas and equip delegates with the internal architectural knowledge and available tools to enable them to identify the cause of performance problems and plan to eliminate such problems leading to an efficient and well performing SQL Server database solution. The course is relevant to SQL Server 2000, 2005 and 2008.


For further details see the full course outline for this course