Kiquenet kiquenet
kiquenet
/ SQL
Created
February 18, 2016 10:32
— forked from huguogang/SQL
SQL Server Performance DMV Sample Queries
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ----------------------------------------------------------------------- | |
| -- Collection of queries that helps in performance tuning | |
| --grant permission to user | |
| GRANT VIEW SERVER STATE TO [user_name] | |
| ------------ based on http://msdn.microsoft.com/en-us/magazine/cc135978.aspx | |
| ---------- Uncover hidden data to optimize application performance ----------------------- | |
| -- * Number of missing indexes |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Use ReportServer | |
| go | |
| /* Performance Tips | |
| 1. High TimeDataRetriveal | |
| * Removed unused datasets | |
| * Analyze the dataset query in SQL Profiler | |
| * Combine Datasets where possible | |
| 2. High TimeProcessing | |
| * Use less report parts (tables, charts...) | |
| * Do Grouping and Sorting on the SQL Side |