Database Reference
In-Depth Information
How to do it...
The following steps are required in implementing systematized monitoring methods for data
platform optimization to fine tune the queries:
1.
Use the SQL Server Management Studio tool and right-click on SQL Server instance.
Choose the Activity Monitor tool to open.
2.
Overview the % Processor Time, Waiting Tasks, Database I/O, and Batch Requests
status on the selected SQL Server instance.
3.
Expand the Recent Expensive Queries tab to show the list of queries that are
running slow.
2.
On the Recent Expensive Queries tab, select any of the queries against
AdventureWorks2008R2 database to obtain the query execution plan. Right-click on
any row and choose Show Execution Plan.
3.
The show plan launches the graphical image that we get from a query editor from the
query plan cache.
Search WWH ::
Custom Search