A Set of Boon Tools – SSAS DMVs in SQL Server 2012

Hi All, As you must have heard or started using DMVs (Dynamic Management View) available in SQL Server to get information about local server operations and server health. But today I would like to focus specially on DMVs for monitoring SSAS (SQL Server Analysis Services) and dig-down to find out how powerful it can be. [...]

March 1, 2012 · bigator Khilitchandra Prajapati · bigator One Comment
bigator Tags: DMV, DMX, SQL Server 2012 · Posted in: DMX, Dynamic Management Views, Quick Tips, SQL Server, Uncategorized

Browse Posts
May 2013

M T W T F S S

« Feb

1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22 23 24 25 26

27 28 29 30 31
Categories Basket
- Business Intelligence (32)
  - Visio (2)
- General (46)
  - E-Book (3)
  - Excel (2)
  - Free (8)
  - Funny (1)
  - Microsoft Connect (1)
  - Microsoft Event (5)
  - New Features (10)
  - Quick Fix (9)
  - Training (3)
  - VB Script (1)
  - Windows (2)
- Interview QA (51)
  - Quick Tips (24)
  - Script (5)
  - Suggestion (8)
  - Tutorial (33)
- SharePoint (4)
  - SharePoint List Adapter (1)
- SQL Azure (2)
- SQL Server (60)
  - Database Diagram (1)
  - Database Snapshot (1)
  - Dynamic Management Views (2)
  - File Stream (1)
  - File Tables (1)
  - T-SQL (8)
- SQL Server 2012 (17)
  - Virtualization (1)
- SQLServerPedia (4)
- SSAS (15)
  - Data Mining (3)
  - DMX (4)
  - MDX (6)
  - Pivot Table (4)
  - Power Pivot (1)
  - Query Tuning (2)
- SSIS (19)
  - Default Logging (1)
  - DTEXEC (2)
  - Merge Join (1)
  - XP_CmdShell (1)
- SSRS (14)
  - Report Builder 3.0 (1)
  - SparkLines (1)
- Uncategorized (4)
- Video (1)