|July 12, 2018||
If you are planning to implement a high availability cluster to protect SQL Server, you need to understand your Windows Server cluster quorum options. I explained these options in a recently recorded webinar which is available here. You may also be interested in a free white paper, “Understanding Windows Server Quorum Options for SQL Server Clustering” Here are some Q&As from the session.
Q: if we have a three node on premises cluster running Windows 2012 R2 is it possible to put another node in the Azure cloud and failover to it? Azure node?
Q: If you failover from an on-premises SAN-based cluster to a node in the cloud, is the SAN storage just for the local machines? Do they have a separate set of storage in the cloud, or is the cloud server actually able to access the SAN storage?
Q: Can you failover and failback when you have a cluster with both on-premises nodes such as SAN and nodes the cloud?
Q: If you have multiple nodes in a cluster, are there limitations with clustering as far as what can be accessed in terms of the RAM and CPU limitations – or is it based on the Windows operating system and the version of SQL Server?
– Dave Bermingham, SIOS Technology Corp. Technical Evangelist; Microsoft Cloud and Datacenter Management MVP
|May 18, 2018||
SIOS DataKeeper™, an AWS Customer Ready Solution: High Availability and Disaster Recovery for Microsoft SQL Server
More and more companies are looking to run SQL Server in the cloud to take advantage of the flexibility and cost-savings that it delivers. However, many cloud migration projects have been plagued by confusion about high availability protection options in the cloud where the shared storage needed for traditional failover clusters is not available. IT teams are understandably cautious. Downtime for these databases and the applications running on them can have costly consequences, including interruption of essential business operations, reduced end-user productivity, and poor customer satisfaction.
High Availability Options in AWS
But, good news! IT teams have more high availability (HA) and disaster recovery (DR) protection options in the cloud than many realize. You can even save thousands of dollars while still delivering comprehensive HA failover clustering protection for Microsoft SQL Server in AWS.
To simplify and accelerate the deployment of high availability SQL Server clusters in the cloud, Amazon Web Services is offering SIOS DataKeeper™ Cluster Edition on AWS Marketplace and can be deployed automatically using an AWS Quick Start. The AWS Quick Start deployment is perfect for organizations starting their venture into high availability clusters in the cloud.
With the AWS Quick Start program, system administrators and managers can use the SIOS Amazon Machine Images (AMIs) on AWS Marketplace to see firsthand how easy it is to deploy a two-node SQL Server cluster in AWS with SIOS DataKeeper™. The SIOS AMIs on AWS Marketplace provide a customer-ready solution to protect business-critical applications in AWS.
SIOS DataKeeper™ Cluster Edition for HA & DR in AWS
SIOS DataKeeper™ Cluster Edition is the first high availability and disaster recovery solution to combine fully automated, application-centric clustering and efficient data replication. SIOS DataKeeper™ integrates seamlessly into Windows Server Failover Clustering environments, enabling them to work in a cloud where shared storage is not possible.
SIOS, an APN Standard Technology Partner, solves the problem of HA and DR by replicating your SQL Server data between availability zones and/or Regions on AWS and integrates with failover clusters to allow you to build SANless clusters on AWS. SIOS DataKeeper™ overcomes the lack of a SAN on AWS, enabling you to build failover cluster instances just using local attached storage.
Leverage the AWS Quick Start to set up an AWS environment for SIOS DataKeeper™ Cluster Edition and deploy it to your AWS account. This Quick Start uses AWS CloudFormation templates to deploy SIOS DataKeeper™ into a new or existing virtual private cloud (VPC).
|May 15, 2017||
AWS Quick Start Templates Deploy SQL High-Availability Failover Cluster in the Cloud
Many businesses are struggling to deploy a high-availability failover cluster for SQL Server and other important applications in the cloud. This is because you need shared storage to create a SQL failover cluster. Shared storage is not available or practical in most public clouds. As a result, Many IT teams kept SQL on-premises. Their experts in IT network, storage, and server would take months to plan, order, install, and configure physical environments for HA failover clustering. Finally, they would spend spent thousands of dollars upgrading to SQL Server Enterprise edition to gain advanced clustering capabilities.
SANless Failover Clustering Enables Cost-Efficient SQL High Availability Protection in the Cloud
Today, SIOS DataKeeper Cluster Edition is the first HA/DR solution to combine fully automated, application-centric clustering and efficient data replication. By integrating seamlessly into Windows Server Failover Clustering (WSFC), it enables a WSFC to work in a cloud where shared storage is not possible. SIOS DataKeeper works by synchronizing local storage in real time using highly efficient block-level replication. In this way, creates a SANless cluster to protect your Windows applications in the cloud. You can use it to protect SQL Server Standard Edition without the need for costly upgrades to SQL Server Enterprise Edition.
Quick Start Templates Make Deploying a Failover Cluster in AWS Easy
Now companies can easily deploy a two-node high-availability failover cluster automatically using an AWS EC2 Quick Start deployment. System administrators and managers can simply purchase the SIOS Amazon Machine Images (AMIs) on AWS Marketplace. They can use the AMI to deploy a two-node SQL Server Standard Edition cluster in the AWS cloud using an AWS Quick Start template.
Quick Start templates are automated reference deployments for key workloads on AWS. Each Quick Start launches, configures and runs the AWS service required to deploy a specific workload on AWS. Importantly, the templates use AWS best practices for security and availability. As a result, Quick Starts eliminate manual steps with a single click – they are fast, low-cost, and customizable.
The SIOS AMIs on AWS Marketplace provide an easy, convenient way for customers to purchase SIOS DataKeeper software to protect business critical applications in AWS. You can use them to deploy a high availability cluster using cost efficient SQL Server Standard Edition in the cloud.
Customers can purchase SIOS DataKeeper through the AWS Marketplace at: https://aws.amazon.com/marketplace/seller-profile?id=3c91e2f7-fc8d-4cce-a8aa-1e37abcb4408
To learn more about the SIOS DataKeeper Quick Start for AWS Cloud, visit: https://aws.amazon.com/quickstart/architecture/sios-datakeeper/
To learn more about the SIOS DataKeeper Cluster Edition for High Availability in Cloud Deployments:
|January 26, 2017||
This is the first post in a two-part series highlighting challenges IT teams face in optimizing VMware performance. The original text of this series appeared in an article on Data Informed.
When virtual computing first became popular, it was primarily used for non-business critical applications in pre-production environments, while critical applications were kept on physical servers. However, IT has warmed up to virtualization, recognizing the many benefits (reduced cost, increased agility, etc.) and moving more business-critical and database applications into virtual environments. In a recent survey of 518 IT professionals we conducted, we found that 81 percent of respondents are now running their business-critical applications, including SQL Server, Oracle or SAP, in their VMware environments.
VMware Performance Becomes Critical as More Important Applications Virtualized
While there are numerous benefits, virtualized environments introduce a new set of challenges for IT professionals. For IT teams tasked with finding and resolving VMware performance issues, specifically those that can impact business-critical applications, many find they are hitting the same cumbersome roadblocks related to tools, time and strategy.
IT Pros Need Multiple Tools to Gain a Holistic View of their VMware Environments.
According to the survey results, 78 percent of IT professionals are using multiple tools– including application monitoring, reporting and infrastructure analytics– to identify the cause
Relying on several reporting tools every time an issue arises just isn’t sustainable for most IT teams. This is partly due to the fact that solving application performance issues requires a view of multiple IT disciplines or “silos” such as application, network, storage and compute. In larger organizations, that means each time an issue arises, representatives from each discipline need to come together and compare their findings– and the analysis results from the application team’s tool may point to a somewhat different cause than the storage team or the network team’s tool. The current strategy of relying on multiple tools and teams to evaluate each silo leaves IT with the manual, trial and error task of finding all the relevant data, assembling it and analyzing it to figure out what went wrong and what changed to cause the problem.
Stay tuned for part two of this series, where we’ll discuss issues related to time and resources wasted in uncovering issues, as well as finding the root cause of VMware performance issues.
|January 5, 2017||
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!