Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Availability Rss

Search for any content tagged availability

   Items 1 to 19 of 19   
 

Improved Application Availability During Online Operations in SQL Server 2014

SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact.  Read more...
By Additional Articles 2013/09/13 | Source: Microsoft MSDN | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 3,059 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,502 reads

Fundamentals of Storage Systems – RAID, An Introduction

In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...  Read more...
By Wesley Brown 2009/12/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,138 reads

Low-Cost High Availability: Simple Database Monitoring in a Windows En

The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding.   Read more...
By Additional Articles 2006/10/18 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 3,510 reads

Stress Testing SQL Server

Properly sizing your SQL Server hardware and testing application loads against them is a complex and difficult topic. Anthony Bressi brings us a great new article that gives you a systematic approach to performing your own stress test.   Read more...
By Anthony Bressi 2006/10/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 20,558 reads

Monitoring SQL Servers Availability

How many SQL Server instances are you running? Do you ever have customers calling you stating that their application is not working, then when you research the problem you find that the instance that supports their application is unavailable? Have you ever had someone mistakenly shutdown the SQL Agent service and forget to restart it, causing a number of scheduled jobs to not be run? One of the tasks of a DBA is to monitor the availability of all SQL Server instances and services.  Read more...
By Additional Articles 2006/08/10 | Source: Database Journal | Category: availability
Rating:  Rate this |   Briefcase | 2,902 reads

Server Consolidation

Are you thinking about consolidating your SQL Servers on to fewer machines? It is an interesting idea and one that is definitely more possible with SQL Server 2005 and 64-bit servers. Steve Jones takes a look at some of the pros and cons of moving to fewer servers.   Read more...
By Steve Jones 2006/03/15 | Source: SQLServerCentral.com | Category: availability
Rating: |  Discuss |   Briefcase | 7,467 reads

Rebuilding SQL Server Cluster Nodes

Active/Passive SQL Server 2000 clustering gives more reliability and fault tolerance to Production SQL Server environments. When a failure occurs, all of the resources fail over from the active node to the passive node and make the passive node active. This article explains how to rebuild the node that failed and attach it back to the cluster.  Read more...
By Additional Articles 2005/02/10 | Source: Database Journal | Category: availability
Rating:  Rate this |   Briefcase | 1,995 reads

Custom Log Shipping

One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.   Read more...
By Chris Kempster 2003/11/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,338 reads

Should you buy a SAN?

Andy recently implemented a SAN and shares some of the info he picked up during the purchase and implementation. This article also discusses briefly the differences between SAN and NAS, and has some links to other sites for more info as well.   Read more...
By Andy Warren 2003/03/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,003 reads

Server Hardware Standards

Standards are important in the computer business, both the hardware and software side. After looking at Coding Standards in a previous series, Steve Jones looks at the server side of standards beginning with hardware.   Read more...
By Steve Jones 2003/01/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,021 reads

Worst Practices - Making On-The-Fly Changes

Continuing with our worst practices series, Steve Jones looks at another administrative no-no. Making a change to your live system on the fly.   Read more...
By Steve Jones 2003/01/20 | Source: SQLServerCentral.com | Category: availability
Rating: |  Discuss |   Briefcase | 7,742 reads

Who Needs Change Management?

You have spent thousands of dollars on that cool technology; clustering, redundant controllers, redundant disks, redundant power supplies, redundant NIC cards, multiple network drops, fancy tape backup devices and the latest and greatest tape technology. You are all set. There is no way your going to have downtime. Right?   Read more...
By Greg Robidoux 2003/01/16 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,869 reads

Another Disaster (Almost)

Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.   Read more...
By Andy Warren 2003/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,034 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,502 reads

Is 0% Downtime Possible?

Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.   Read more...
By Steve Jones 2002/02/25 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,955 reads

SQL Server 7.0 Log Shipping Frequently Asked Questions

This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.   Read more...
By Additional Articles 2001/07/02 | Source: Microsoft MSDN | Category: administration
Rating:  Rate this |   Briefcase | 1,330 reads

Microsoft SQL Server 2000 Reliability

Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.   Read more...
By Additional Articles 2001/06/05 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 1,261 reads

SQL Server 7.0 and 2000 Clustering Resources

A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.  Read more...
Rating:  Rate this |   Briefcase | 1,435 reads
   Items 1 to 19 of 19