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


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQLServerCentral.com » Editorials » When Do You Deploy?
Add to briefcase
30 posts, Page 1 of 3
123»»»

When Do You Deploy? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Posted Thursday, February 18, 2010 8:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863
Comments posted to this topic are about the item When Do You Deploy?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #868735
ChrisP-374390
Posted Thursday, February 18, 2010 9:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 22, 2012 11:15 PM
Points: 130, Visits: 404
Our JDE changes occur mid-month on Thursday evenings. Why? That is the window Finance gave us.

Most interesting window I have ever seen was where the app ran on a server also controlling a factory floor - we could roll out upgrades annually on Xmas day.

The application ran 24x7 on DEC VAX / VMS...
Post #868755
honza.mf
Posted Thursday, February 18, 2010 11:36 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:11 AM
Points: 1,114, Visits: 1,209
Best time (for deployment too) is when boss is out.
My boss goes to holidays tommorow, our director is in spa. Life is beautiful.


See, understand, learn, try, use efficient
© Dr.Plch
Post #868772
Kelsey Thornton
Posted Friday, February 19, 2010 1:14 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, March 04, 2013 4:10 AM
Points: 532, Visits: 281
ChrisP-374390 (2/18/2010)

Most interesting window I have ever seen was where the app ran on a server also controlling a factory floor - we could roll out upgrades annually on Xmas day.

The application ran 24x7 on DEC VAX / VMS...



This is VERY familiar to me - I am a bit of a database lightweight, but our company provides process control systems for the chemical and paints manufacturing industry - I think I've NOT had to work through the Xmas holiday (vacation) only about 3 times in the last 10 years

Easter is another time when we quite often get roll-outs.

Kelsey Thornton
MBCS CITP
Post #868812
James Lean
Posted Friday, February 19, 2010 2:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:08 AM
Points: 2,962, Visits: 1,412
Surely this depends entirely on the usage patterns of the affected systems? We have some servers that are used mainly in the morning (eg 7am - 2pm) so we can often do maintenance during the late afternoon. Other servers aren't used until later in the day so we can do stuff first thing in the morning. Still other servers are used mainly for overnight loading/processing so we can take those down in the middle of the working day.

I guess if you're supporting internal systems used by other office workers then you're mainly going to be doing maintenance overnight. But for systems used by clients who don't necessarily work 9-5 you need to be more flexible.

-----
@jameslean
Post #868832
John.Sansom
Posted Friday, February 19, 2010 2:36 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 11:19 AM
Points: 343, Visits: 1,466
I have found that for platforms that support global customers, just before Europe comes online seems to be the most suitable time as this is when the lowest volume of traffic "tends" to be experienced,

So before the US and APAC come online.....

John Sansom (@sqlBrit) | www.sqlbrit.com
Post #868855
george sibbald
Posted Friday, February 19, 2010 4:05 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 5,313, Visits: 11,298
all out of hours, mostly weekends. We have an 'application weekend' and an 'infrastructure weekend' but there is flexibility.

If the work involves an outage we can't even touch non-prod boxes during working hours.

Gets tiring at times.

---------------------------------------------------------------------
Post #868921
darragh.hickey
Posted Friday, February 19, 2010 4:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 03, 2013 10:45 AM
Points: 1, Visits: 45
For us its weekends only for a major upgrade (once a quarter).
If its a small patch fix we can go on a weekday, but in the early morning (European) time.

D.
Post #868933
Grant Fritchey
Posted Friday, February 19, 2010 5:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281
With global access of most of our systems and engineers doing work at odd hours of the day & night, all around the world, we don't have a good time for down time. So, with input from the business, it was decided that hot fixes & minor updates would go out on Wednesday's in the evening EST. Major work is done over the weekend. I'm getting ready to retire an Oracle database (and yes, I like saying that) and start the app on SQL Server 2008 tomorrow (Saturday) morning.

I used to work for a dot com that was also 24/7. After analyzing access to the system, we tried to do major maintenance at 3AM on Sunday mornings because that was the time that we had the least number of people on the system.

I can't imagine taking down a system in the middle of the work day, on purpose, unless it was a dire emergency.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #868984
tosscrosby
Posted Friday, February 19, 2010 6:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316
Our schedule is usually every other Thursday evening for patches or minor version upgrades. Usually one Saturday a quarter for a major release. The thinking for Thursday is that we have Friday to fix anything or rollback and then the weekend if needed, but since they are only minor releases, fixes/rollbacks are usually fairly quick (and rare). Major releases on Saturday's get the affected user community in to test the move to production, allowing part of Saturday/all of Sunday to fix or rollback. It works for us.

-- You can't be late until you show up.
Post #869015
« Prev Topic | Next Topic »

Add to briefcase
30 posts, Page 1 of 3
123»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.