Archive for the ‘SQL 2008 R2’ Category

Powershell MSDTC cluster add in

Teched 2010 Berlin #TEE10 #Teched

For Demo and learning Sites you need often thing that takes only a minute but when you play with it it takes more time than you want.

So with this in my mind I created 3 powershell scripts that you can use for builing a cluster , NLB Cluster and a MSTDC cluster resource.

So If you want to create a MSDTC resource in your Cluster you can do this in the GUI or with a Powershell Script.

You can find the Scripts Here : Powershell Scripts

Powershell MSDTC cluster add in

First We load the powershell modules If it is a cluster you should do this on all the Cluster Nodes

Servermanagercmd -install Application-Server
Servermanagercmd -install AS-Dist-Transaction AS-Ent-Services –allSubFeatures

I Comment every line for what it does.

# Create a new HA Server Role – Distributed Transaction Coordinator
Add-ClusterServerRole -Name ServerDTC -Storage "Cluster Disk 6" -StaticAddress 192.168.1.1

Here we create the resource and chuck it to a disk and IP

# Add the MSDTC Service to the new Server Role
Get-ClusterGroup ServerDTC | Add-ClusterResource -Name MSDTC-ServerDTC -ResourceType "Distributed Transaction Coordinator"

Put in the MSDTC services.

# Create Dependencies for the DTC group
Add-ClusterResourceDependency MSDTC-ServerDTC ServerDTC
Add-ClusterResourceDependency MSDTC-ServerDTC "Cluster Disk 6"
# Start DTC group
Start-ClusterGroup ServerDTC

 

So Now that this is ready you can configure the MSDTC but remember the items that I mentioned in my previous blog.

http://robertsmit.wordpress.com/2010/10/20/msdtc-clustering-logfile-bug/

Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database

 

Yes there is support for SQL 2008 R2 , Soon all products are supported. But remember not all third  party’s are ready for SQL 2008 R2.

The support is divided into two phases. Phase one supports new installations of System Center Operations Manager 2007 R2. Phase two supports upgrading an existing System Center Operations Manager 2007 R2 deployment to run on a SQL Server 2008 R2 database. The existing deployment has database roles hosted on a Microsoft SQL Server 2005 Service Pack 3 (SP3) server or on a Microsoft SQL 2008 Service Pack 1 (SP1) server.

http://support.microsoft.com/kb/2425714

There is a great document for SQL 2008 R2 Microsoft SQL Server 2008 R2- The Best Data Platform on Windows Server 2008 R2

Posted September 30, 2010 by Robert Smit in SQL 2008 R2, Windows 2008 SQL 2008 Cluster

Microsoft SQL Server 2008 and SQL Server 2008 R2

guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 The Infrastructure Planning and Design team has released an updated guide for Microsoft SQL Server 2008 and SQL Server 2008 R2.

The Infrastructure Planning and Design (IPD) guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 helps organizations address key design decisions and confidently plan the efficient implementation of a SQL Server infrastructure. The tasks addressed in this guide help technical decision makers identify the appropriate SQL Server roles needed as well as determine the infrastructure components, server placement, and fault-tolerance configuration necessary to meet planning requirements. By using this guidance, organizations can make efficient planning and optimal design decisions for their SQL Server infrastructures.

SQL Server architecture

Download the IPD Guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 at http://go.microsoft.com/fwlink/?LinkId=160982

 

 

 

 

 

 

What’s New in Microsoft SQL Server 2008 R2

Built on SQL Server 2008, SQL Server 2008 R2 has expanded reporting and analytics through self-service business intelligence.

• Master Data Services. With Master Data Services, IT organizations can centrally manage critical data assets companywide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time.

•Improved application and multi-server management capabilities.

•The SQL Server Utility allows DBAs to centrally manage and view instances of SQL Server, data-tier applications, database files, and volumes.

•The Utility Control Point (UCP) collects configuration and performance information from managed instances of SQL Server every 15 minutes, and provides dashboard views of health summary of SQL Server resources.

•Data-tier applications (DAC), which contain all of the database’s schema, dependent objects, and deployment requirements used by an application to improve the deployment of data applications and the collaboration between data-tier developers and DBAs.

•Utility Explorer dashboards to monitor resource utilization and health states.

•Two new premium editions. SQL Server 2008 R2 introduces two new premium editions to meet the needs of large-scale datacenters and data warehouses: Datacenter and Parallel Data Warehouse.

•Integration with Microsoft SQL Azure. The client tools included with Microsoft SQL Server 2008 R2 allows DBAs to connect to SQL Azure, a cloud-based service that offers a flexible and fully relational database solution in the cloud.

•Integration of SQL Server with Sysprep. Allows DBAs to automate the deployment of SQL Server.

•Analysis Services integration with SharePoint. SQL Server PowerPivot for SharePoint is a new role-based installation option in which PowerPivot for SharePoint will be installed on a new or an existing SharePoint 2010 server to support PowerPivot data access in the farm.

•See http://msdn.microsoft.com/en-us/library/cc645993.aspx for more detailed information on features in specific versions of SQL Server 2008 and http://msdn.microsoft.com/en-us/library/cc645993(SQL.105).aspx for SQL Server 2008 R2.

Determine capacity and performance requirements

 

•Disk storage required. For databases that don’t yet exist, an estimate will need to be made of the disk storage required. Storage needs should be calculated for the database, transaction log, indexes, and tempdb database.

••IOPS and throughput required. Since the main function of SQL Server is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in performance degradation of SQL Server. Although it may not be possible to calculate the required IOPS in advance, benchmarks for some workloads may be available from SAN and disk vendors that may provide a baseline for estimating the required performance and the disk storage configuration required to deliver that performance level.

More information about the IPD series:

image

The Infrastructure Planning and Design guides are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario. All guides share a common structure including:

  • Definition of the technical decision flow through the planning process.
  • Listing of decisions to be made and the commonly available options and considerations.
  • Relating the decisions and options to the business in terms of cost, complexity and other characteristics.
  • Framing decisions in terms of additional questions to the business to ensure a comprehensive alignment with the appropriate business landscape.
  • These guides complement product documentation by exposing and focusing on infrastructure design options.

Posted May 27, 2010 by Robert Smit in SQL 2008, SQL 2008 R2

Tagged with

  • Tag