SQL Server Basic Query Tuning Techniques

Home/Administration, SQL Server/SQL Server Basic Query Tuning Techniques

SQL Server Basic Query Tuning Techniques

$15.00 $4.00

Many administrators address performance problems solely by tuning system-level server performance: for example, memory size, type of file system, number and type of processors, and so on. However, many performance problems cannot be resolved this way. They are better addressed by also analyzing the application queries and updates that the application submits to the database, and how these queries and updates interact with the data contained in the database and the database schema. In the first exercise of this lab we will look into different query and table hints available in SQL Server. In the second exercise we will look into ad hoc query and how to deal with them and in the third and last exercise we will look into parameter sniffing and how to deal with it.

Exercise 1: Query & Table Hints
Exercise 2: Ad Hoc Query Optimization
Exercise 3: Parameter Sniffing Optimization

Categories: ,

Description

Many administrators address performance problems solely by tuning system-level server performance: for example, memory size, type of file system, number and type of processors, and so on. However, many performance problems cannot be resolved this way. They are better addressed by also analyzing the application queries and updates that the application submits to the database, and how these queries and updates interact with the data contained in the database and the database schema. In the first exercise of this lab we will look into different query and table hints available in SQL Server. In the second exercise we will look into ad hoc query and how to deal with them and in the third and last exercise we will look into parameter sniffing and how to deal with it.

Exercise 1: Query & Table Hints
Exercise 2: Ad Hoc Query Optimization
Exercise 3: Parameter Sniffing Optimization

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.