This paper explains how SQL Server 2008 allocates memory for plan caching, how query batches are cached and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations and for minimizing plan cache pollution.
Read the white paper: http://msdn.microsoft.com/en-us/library/ee343986.aspx
SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.
The Resource Governor is a new feature in the Microsoft SQL Server 2008 Enterprise. It provides very powerful and flexible controls to dictate and monitor how a SQL Server instance behaves in terms of CPU, memory and response time.
This white paper is targeted at IT professionals and database administrators responsible for managing scale, concurrency, high availability, consolidation, virtualization, or service level agreements for the SQL Server instances in their production environments.
Read the white paper: http://msdn.microsoft.com/en-us/library/ee151608.aspx
This paper explores Policy-Based Management, a new management feature introduced in SQL Server 2008. Policy-Based Management allows DBAs to define a set of policies that can control many different aspects of SQL Server. Policies can be applied to a single server or to groups of servers. For example, a DBA could define a policy that specifies how a particular configuration option should be set on all the servers in the enterprise. What used to be time-consuming tasks and referencing paper manuals can now be virtually automated.
Read the white paper: http://msdn.microsoft.com/en-us/library/dd938891.aspx
SQL Server 2008 introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting. MDW is a set of components that enable a database developer or administrator to quickly track down problems that could be causing performance degradation.
Read the white paper: http://msdn.microsoft.com/en-us/library/dd939169.aspx
In this paper we’ll walk through an introduction to Windows PowerShell and its key elements. We’ll then look at the special PowerShell executable program provided with SQL Server 2008, sqlps.exe. Sqlps.exe incorporated a set of cmdlets specific to using PowerShell with SQL Server, and adds a PowerShell drive (PSDrive) allowing us to navigate SQL Server as though it were a filesystem. We’ll explore these features, then look at some scripts we can use to administer SQL Server as well as to extract data as needed.
Read the white paper: http://msdn.microsoft.com/en-us/library/dd938892.aspx
Extended Events is an extended event handling system for SQL Server. It has a highly scalable and highly configurable architecture that allows administrators to collect as much or as little information as is necessary to troubleshoot or identify a problem. It is important to note that it is not currently a replacement for the existing diagnostic features of SQL Server, though it has many parallel functionalities to SQL Trace.
One of the key features of Extended Events is its ability to collect data that can be output to an Event Tracing for Windows (ETW) target, which allows the data to be correlated with data collected from the operating system through ETW. Previously in SQL Server 2005, it was possible to collect SQL Trace data with ETW; however, this was limited to SQL Trace events only. In SQL Server 2008, Extended Events data for wait events can be correlated with system kernel ETW (file) data in a single view to isolate the specific cause of the waits, as being a true I/O bottleneck, or perhaps a major file copy operation in the operating system that is causing the delays in SQL Server.
Read the white paper: http://msdn.microsoft.com/en-us/library/dd822788.aspx
Microsoft.com Engineering Operations (MSCOM Ops), the team responsible for architecting and managing many of the most heavily trafficked Microsoft Web sites, recently documented substantial replication performance improvements for both push and pull subscriptions in Microsoft® SQL Server® 2008 running on Windows Server® 2008—up to 100 times faster than Microsoft SQL Server 2005 running on Windows Server 2003. This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.
Read Whitepaper: http://msdn.microsoft.com/en-us/library/dd263442.aspx
Microsoft SQL Server provides a policy-based system for managing one or more instances of SQL Server along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases and SQL Server instances.
Download Whitepaper: http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQL2008_ProductOverview.docx
With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers. While SQL Trace can be used to satisfy many auditing needs, SQL Server Audit offers a number of attractive advantages that may help DBAs more easily achieve their goals such as meeting regulatory compliance requirements. These include the ability to provide centralized storage of audit logs and integration with System Center, as well as noticeably better performance. Perhaps most significantly, SQL Server Audit permits fine-grained auditing whereby an audit can be targeted to specific actions by a principal against a particular object. This paper provides a comprehensive description of the new feature along with usage guidance and then provides some practical examples.
Read the Whitepaper: http://msdn.microsoft.com/en-us/library/dd392015.aspx
This white paper examines the deployment of the SQL Utility within Microsoft IT, including the decisions that Microsoft IT made, implementation details, and aspects of system quality. It assumes that readers are technical decision makers and are somewhat familiar with Windows Server and SQL Server technologies. Many of the principles and techniques described in this paper can apply to other organizations. However, this paper is based on the experience and recommendations of Microsoft IT as an early adopter. It is not intended to serve as a procedural guide. Each enterprise environment has unique circumstances; therefore, each organization should adapt the plans and lessons learned described in this paper to meet its specific needs.
Download the Whitepaper: http://download.microsoft.com/download/C/F/B/CFB498D0-37B0-4805-9B41-EE2FCA3F1196/SQL%20Sustainability%20Technical%20White%20Paper.doc
Posts
All Comments
