The Next Release of  Microsoft SQL Server:  Manageability Overview

The Next Release of Microsoft SQL Server: Manageability Overview PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

. Trends Impacting Manageability. Resource Governor, Auditing, Data Compression, and others. Declarative Management. Session Objectives and Agenda. . . NET FrameworkCommon Language Runtime IntegrationUser-defined AggregatesUser-defined Data TypesUser-defined FunctionsSQL Server .NET Data Prov

Download Presentation

The Next Release of Microsoft SQL Server: Manageability Overview

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

2. DAT204 The Next Release of Microsoft SQL Server: Manageability Overview Dan Jones Lead Program Manager, SQL Server Manageability Microsoft

3. Session Objectives and Agenda

4. Trend 1: Product Releases Add Features

5. Trend 2: Data Center & Server Consolidation

6. Trend 3: Remote & Embedded DBs Proliferate

7. Session Objectives and Agenda

8. Overview of SQL Server 2008 Manageability Improvements Resource governor All actions audited Performance Studio Data compression Database mirroring page repair Others

9. Resource Governor Goals Ability to differentiate workloads Ability to monitor resource usage per workload group Limit available resources (CPU & Memory) to workload groups Covered Scenarios Runaway query scenario Prevent or minimize possibility Predictable concurrent execution of different-size workloads Provide mission critical workloads resources they need Limit known large workloads from abusing resources Workload prioritization Changes to Management Studio and SMO

10. All Actions Audited New audit configuration objects New T-SQL for audit configuration New permissions for controlling audit configuration i.e. ALTER ANY AUDIT, ALTER ANY AUDIT SPECIFICATION Audit filtering based on action, object and principal at server and database levels Backward compatibility for SQLTrace event group Audit for Select, Insert, Update, Delete actions Changes to Management Studio and SMO

11. Performance Studio

12. Data Compression CREATE TABLE... [WITH (<table_option> [,...n])] <table_option>:= { DATA_COMPRESSION = {NONE|ROW|PAGE} [ON PARTITIONS ({<partition_number_expression>|<range>} [,...n])]

13. Database Mirroring Page Repair Enables the principal and mirror nodes to automatically attempt recovery from bad page errors Recovery from physical data corruption, which might be caused by disk media going bad, or torn write caused by a power outage Requests a fresh page from the partner server New DMV (sys.dm_db_mirroring_auto_page_repair) Provides a moving picture of the last 100 auto repair actions New Trace Event (Database Suspect Data Page) Raised when a bad page is encountered

14. Others Powershell Integration T-SQL Intellisense in Management Studio

15. Session Objectives and Agenda

16. Declarative Management Declarative Management is a new policy- based management framework for the SQL Server Database Engine that delivers the following benefits: Ensure compliance with policies for system configuration Prevent/monitor changes to the system by authoring policies for the desired configuration Scale management across multiple servers Reduce total cost of ownership by simplifying administration tasks

17. Addressing the Trends Head-on

18. Sample Policies

19. Conceptual Model

20. Highlevel Architecture

21. demo Declarative Management

22. Q&A

23. Resources

24. Call to Action

  • Login