Zero Milli Seconds Disk Latentcy

Lately I done a performance lab where finding the limits of an existing SQL Server 2012 based application. The Test Lab was done with Team Foundation Server Test Suite on latest Hardware. SQL Server ran on HP DL 580 with 48Cores in 240GB RAM and Disk Subsystem was FusionIO 4TB Card. The application itself was…

0

Visual Studio Evolution 2013 – die Fachkonferenz zu Visual Studio und .NET

Visual Studio Evolution 2013 – die Fachkonferenz zu Visual Studio und .NET   Nach dem Erscheinen von VisualStudio 2012 und .NET Framework 4.5 im letzten Herbst, kündigen sich nun bereitsdie beiden Nachfolgerversionen Visual Studio 2013 und .NET 4.5.1 an, die jedeMenge spannende Neuerungen mit sich bringen. Zusammen mit den Möglichkeiten vonWindows Phone, Windows Azure oder…

0

Performance Guidance for SQL Server in Windows Azure Virtual Machines

Authors: Silvano Coriani, Jasraj Dange, Ewan Fairweather, Xin Jin, Alexei Khalyako, Sanjay Mishra, Selcin Turkarslan Technical Reviewers: Mark Russinovich, Brad Calder, Andrew Edwards, Suraj Puri, Flavio Muratore, Hanuma Kodavalla, Madhan Arumugam Ramakrishnan, Naveen Prakash, Robert Dorr, Roger Doherty, Steve Howard, Yorihito Tada, Kun Cheng, Chris Clayton, Igor Pagliai, Shep Sheppard, Tim Wieman, Greg Low, Juergen…

0

SSIS Tips Tricks and Best Practices: SSIS Operational and Tuning Guide

SSIS Operational and Tuning Guide SQL Server Technical Article Writer: Alexei Khalyako, Carla Sabotta, Silvano Coriani, Sreedhar Pelluru, Steve Howard Technical Reviewer: Cindy Gross, David Pless, Mark Simms, Daniel Sol Published: December 2012 Applies to: SQL Server 2012; Windows Azure SQL Database Summary: SQL Server Integration Services (SSIS) can be used effectively as a tool…

0

SSIS Tips Tricks and Best Practices: SSIS for Azure and Hybrid Data Movement

SSIS for Azure and Hybrid Data Movement SQL Server Technical Article Writer: Alexei Khalyako, Carla Sabotta, Daniel Sol, Silvano Coriani, Sreedhar Pelluru, Steve Howard Technical Reviewer: David Pless Published: December 2012 Applies to: SQL Server 2012 Summary: SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from…

0

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and Availability Groups

Authors: Joseph Sack (SQLskills.com), Sanjay Mishra (Microsoft) Technical Reviewers: Min He (Microsoft), Chuck Heinzelman (Microsoft), Alexi Khalyako (Microsoft), Charles Mathews (Microsoft), Prem Mehra (Microsoft) , Juergen Thomas (Microsoft), Mike Weiner (Microsoft), Amitabh Tamhane (Microsoft), Brent Ozar (Brent Ozar PLF), Gianluca Hotz (SolidQ), David P. Smith (ServiceU), Michael Steineke (Edgenet), Glenn Berry (SQLskills.com) Content Program Manager:…

0

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups

Authors: Joseph Sack (SQLskills.com), Sanjay Mishra (Microsoft) Technical Reviewers: Lindsey Allen (MS), Juergen Thomas (MS), Mike Weiner (MS), Prem Mehra (MS), Yorihito Tada (MS), Curt Matthews (MS), Amitabh Tamhane (MS), Aditya Samant (MS), Daniel Janik (MS), Jimmy May (MS), David P Smith (ServiceU), Richard Waymire (SolidQ), Brent Ozar (Brent Ozar PLF), Wolfgang Kutschera (bwin.party), Paul…

0

Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

Writer: Cephas Lin (Microsoft) Contributors: Sanjay Mishra (Microsoft), David Smith (ServiceU Corporation), LeRoy Tuttle Jr. (Microsoft) Technical Reviewers: Prem Mehra (Microsoft), Mike Weiner (Microsoft), Steve Howard (Microsoft), Kun Cheng (Microsoft)   Summary: Using Failover Cluster Instance (FCI) for local high availability within a data center and augmenting it with Database Mirroring (DBM) for disaster recovery has…

0

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Writer: LeRoy Tuttle, Jr. (Microsoft). Contributors: Cephas Lin (Microsoft), Justin Erickson (Microsoft), Lindsey Allen (Microsoft), Min He (Microsoft), Sanjay Mishra (Microsoft). Reviewers: Alexei Khalyako (Microsoft), Allan Hirt (SQLHA), Ayad Shammout (Caregroup), Benjamin Wright-Jones (Microsoft), Charles Matthews (Microsoft), David P. Smith (ServiceU), Juergen Thomas (Microsoft), Kevin Farlee (Microsoft), Shahryar G. Hashemi (Motricity), Wolfgang Kutschera (Bwin Party)….

0

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

Writers: Mike Weiner, Sanjay Mishra, Min He Contributors: Lingwei Li, Mike Anderson (EMC Corporation) Technical Reviewers: Shaun Tinline-Jones, Steve Howard, Prem Mehra, Paul Burpo, Mike Ruthruff, Jimmy May, Matt Neerincx, Dan Benediktson, Michael Steineke (Edgenet Inc.), David P. Smith (ServiceU Corporation) Applies to: SQL Server 2012 Summary: SQL Server Failover Clustering, which includes support for…

0