kiquenet

-----------------------------------------------------------------------
-- 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

kiquenet

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