SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


When Do You Deploy?


When Do You Deploy?

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (248K reputation)SSC Guru (248K reputation)SSC Guru (248K reputation)SSC Guru (248K reputation)SSC Guru (248K reputation)SSC Guru (248K reputation)SSC Guru (248K reputation)SSC Guru (248K reputation)

Group: Administrators
Points: 248684 Visits: 19807
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
My Blog: www.voiceofthedba.com
ChrisP-374390
ChrisP-374390
SSC Veteran
SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)

Group: General Forum Members
Points: 216 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.w00t

The application ran 24x7 on DEC VAX / VMS...
honza.mf
honza.mf
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3141 Visits: 1323
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
Kelsey Thornton
Kelsey Thornton
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1145 Visits: 282
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.w00t

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
James Lean
James Lean
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4689 Visits: 2373
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.

-----
JL
John.Sansom
John.Sansom
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3091 Visits: 1558
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.johnsansom.com
george sibbald
george sibbald
SSC-Forever
SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)

Group: General Forum Members
Points: 44228 Visits: 13705
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.

---------------------------------------------------------------------
darragh.hickey
darragh.hickey
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 111
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.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)

Group: General Forum Members
Points: 162437 Visits: 33199
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
tosscrosby
  tosscrosby
SSCrazy Eights
SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)

Group: General Forum Members
Points: 8680 Visits: 5316
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search