• Blog Post: What's Data Collector

    Highlights of this video blog :- 1. What is Data collector 2. Architecture 3. MDW(Management data warehouse) setup 4. System Data Collection Presented By: - Manish Upadhyay,SE,Microsoft GTSC Reviewed By: - Karthick Krishnamurthy,TL,Microsoft GTSC
  • Blog Post: NORECOMPUTE : Can lead to SQL server performance degradation!!

    ANALYSIS :- In this case when we captured PSSDiag and noticed huge recompiles due to AutoStat updates, here’s a snippet of what we noticed in SQL Server 2005 Vs SQL Server 2008 on the same machine. SQL 2008 ========= EventID Occurrences Description ----------- ----------- ------------------...
Page 1 of 1 (2 items)