24/7 availability

Hi there,
I'm maintaining a database which is used mainly during officehours.
Plenty of time to do maintenance and batchprocesses. In the near future
we are going to a 24/7 situation, and I wonder what impact this has on
hour maintenance and batchjobs. I can think of solutions myself, like
looking for lowest activitytimes to plan batchjobs and maintenance,
maybe create a copy of the database to run batchjobs on. Still, anyone
know of solutions to tackle these things? Is there a site maybe where a
change to 24/7 availability is describes? Any ppl with experiences with
such a process? Advice?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!One thing is you might consider is to not reorganize data (assuming you do in the first place) using
DBCC DBREINDEX, instead consider using DBCC INDEXDEFRAG.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Hans Brouwer" <hansbrouwer@.hotmail.com> wrote in message
news:OFU5T4ylDHA.2068@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> I'm maintaining a database which is used mainly during officehours.
> Plenty of time to do maintenance and batchprocesses. In the near future
> we are going to a 24/7 situation, and I wonder what impact this has on
> hour maintenance and batchjobs. I can think of solutions myself, like
> looking for lowest activitytimes to plan batchjobs and maintenance,
> maybe create a copy of the database to run batchjobs on. Still, anyone
> know of solutions to tackle these things? Is there a site maybe where a
> change to 24/7 availability is describes? Any ppl with experiences with
> such a process? Advice?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi Hans,
As I understand, since 24/7 requires high availability, lengthy maintenance
operations during working hours are not recommended. I think clustering may
worth consideration.
This article discusses the technology of clustering, and the steps involved
in setting up a cluster for an e-commerce site. It also examines how
clustering has been implemented in the sample Duwamish Online store.
Building a Highly Available Database Cluster
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnduwon/htm
l/d5clustering.asp
This article describes ways to reduce or eliminate downtime in a Microsoft
Commerce Server 2000 environment. It focuses primarily on the hardware and
software needed to create a Commerce Server site with no single point of
failure.
Planning for Reliability and High Availability - SQL Server Availability
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncomsrv/ht
ml/planavailability.asp
For additional information regarding this issue, please refer to the
following articles:
Microsoft SQL Server MegaServers: Achieving Software Scale-Out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/megasrvs.asp
Designing Federated Database Servers for High Availability
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/cm
_fedserv_8dq1.asp
High-Availability Solutions Using Microsoft Windows 2000 Cluster Service
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbiz2k2/ht
ml/bts_2002clustering.asp
Thanks for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.