CDC is acronym for Change Data Capture. This is one of the new feature added from SQL Server 2008. CDC helps us to provide information about DML changes on a table and a database. It provides these information’s in relational format. In previous versions of SQL Server we use triggers, timestamp columns etc., to capture the DML changes to the table which is resource expensive techniques, so to overcome this MS added this new feature.
On April 22nd 2010 SQL Server 2008 R2 is released to production. I tried to get the list of new features added to R2 however I couldn’t find all the new features in a single thread so I’m writing this article to populate the list of new features added to SQL Server 2008 R2. There are many new features added to DBA and BI however I feel we have more features for BI.
Performance Data Collector is one of the new features that’s accompanied from SQL Server 2008. If you are a DBA , you know it’s very hard to get performance data from necessary inputs. We will get the data from Perfmon (system monitor), profiler, DMV etc and correlating this data is very hard, implementing the same process or scripts across your environment is also time consuming one. To Overcome this MS has added Performance data collector feature in SQL 2008. In a Nutshell performance data collector will collect performance data (integrating all your data from your server), upload it in centralized management data warehouse (MDW) in relational format and finally allows you to see reports in graphical format.
In this article we are going to discuss about installing SQL Server 2008 R2, I know I’m little late as R2 is released last month. Before we stepping into installation make sure you have necessary hardware and software requirements, check http://technet.microsoft.com/en-us/library/ms143506(SQL.105).aspx this KB article for the same.