Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

 

MDS and Best Practice Analyzer new features were introduced in sql server 2008 R2,

System Health Session – Introduced in Sql server 2008

in Denali Microsoft tried to make it improved and stable.

  • MDS (Master Data Services) – Introduced in Sql server 2008 R2

 

Master Data Services (MDS) Add-in for Microsoft Excel

New Silver light Explorer UI

Entity-Based Staging

 

New capabilities include:

         Batch tags

         Purge capabilities

         Advanced capability to remove assigned domain-based attributes

         Significantly increased performance

 

http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/24/master-data-services-what-s-new-in-sql-server-code-name-denali-ctp3.aspx

http://www.microsoft.com/feeds/technet/en-us/how-to-videos/SQL_How-to_Videos_image.xml

 

  • Tool: Best Practice Analyzer
    - Introduced in Sql server 2008 R2

 

Denali also provided several TOOLs related to engine to enhance the database system and improve it which saves time and makes system more redundant.

 

Best Practice Analyzer is one of them.

http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx

http://blogs.msdn.com/b/sqlsecurity/archive/2012/04/19/sql-server-2012-best-practices-analyzer.aspx

 

 

  • System Health Session – Introduced in Sql server 2008

The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server Database Engine starts, and runs without any noticeable performance effects. The session collects system data that you can use to help troubleshoot performance issues in the Database Engine. Therefore, we recommend that you do not stop or delete the session.

http://troubleshootingsql.com/2012/05/08/awesomesauce-sql-server-2012-system-health-session/?utm_source=feedburner&utm_medium=twitter&utm_campaign=Feed%3A+TroubleshootingSQL+%28TroubleshootingSQL%29

http://msdn.microsoft.com/en-us/library/ff877955.aspx

 

They are new and I have not worked on it, Will blog more on it later.

About these ads
This entry was posted in Denali, Tool and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s