[dba-VB] Fwd: SQL Server / 2003 server locks up

Mark Breen marklbreen at gmail.com
Sun Jun 13 06:06:25 CDT 2010


Hello John,

Let me say, I am not religious on almost any topics (with the possible
exception of the best motorcycles), so I am not favouring Mecurial
over Subversion religiously.

But here is the problem.  Even if you have one programmer - and you already
have two you have the scenario that you work, work, work and then test a
routine.  You think that it is good, and want to preserve that current
version.  But you really do not want to check it in to you repository.  So
what do you do?  One option is quickly xcopy some files (this is surely the
medieval option).  Another choice is check in and be-dammed.  Third Choice
is copy to notepad and hope that we do not have a power cut.

Now with two programmers this gets even worse, Paul works all day and does
not check in, in the evening time, he wants to check in for safely, but he
cannot be sure that there are no breaking changes in his code, so he cannot
check in his code or he will break your code.  So, result is programmers
world wide are afraid to check in their code until they are finished
working.  I know about this problem when I worked on a three person team
that were world wide, so I was never really sure who might check out after I
had checked in untested code.

In effect I had to operate without SCCS.

Mecurial systematically solves that problem.  They made is the first goal of
the product.

In a nutshell, when you install Mecurial you install first a local version,
which is your private SCCS.  Then later when you hire a guy named Paul, he
also gets a private SCCS on his machine.  At that point you install a
central SCCS and from time to time you can merge your code to the central
SCCS.  Paul can do the same and Mecurial is built from the ground to assist
in this process.

It solves the problem I had when I was terrified to check in, but I still
wanted local version control.

Take 20 minutes and read Joel Spolsky's last ever blog post.  After ten
years he chose to make it about Mecurial.  I see now that FogCreek also has
launched a paid for product based on Mecurial so he must be committed.

thanks and good luck,

Mark


On 12 June 2010 14:19, jwcolby <jwcolby at colbyconsulting.com> wrote:

> I am quite happy with VisualSVN over Tortoise.  I have had a couple of
> conflicts that I had to
> settle but it wasn't a big deal.  OTOH it is only Paul and I doing the
> development.  We both found
> VisualSVN to be just dead simple to use and "if it ain't broke".
>
> I installed Mercurial but I did not uninstall VisualSVN and that was really
> confusing.  I am open to
> Mercurial but it really seemed to be a solution for large team development,
> and specifically making
> specific things that I do not do easy to do (branching and such).  At this
> point, I only have one
> project, and I am the only user and one of two users.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> Mark Breen wrote:
> > Hello John,
> >
> > I completely echo what Hans-Christian says about TortiseSVN.  It is one
> > level of comlexity less that doing your checkins in VS.  When I ran into
> > compatability issues between Tortise and AnKH, I de-installed AnKH and
> now
> > happily checkin from the Windows Explorer.  It has the added benefit that
> I
> > do not clutter the solution with overlaid icons also.
> >
> > I know, I know "but I cannot see what needs to be checked in when I am in
> > VS", but you can easily flick over to Win Explorer and you can still do
> all
> > the check-ins there, only it might be safer.
> >
> > Having said all of that, Joel Spolsky believes that Mecurial is the way
> of
> > the future with SCCS.
> >
> > I installed Mecurial last week and had it up and running in ten minutes,
> it
> > is conceptually different than SubVersion.  I value Joel's opinion, so I
> am
> > thinking of switching completely to Mecurial.  However, I am trying to
> > decide whether to run it solely from the command line -  have to admit I
> do
> > not favour that - but it might be fun to try.
> >
> > Thanks
> >
> > Mark
> >
> >
> > On 10 June 2010 22:31, Hans-Christian Andersen <ha at phulse.com> wrote:
> >
> >> John,
> >>
> >> Without looking at code, it would be hard to determine if the issue you
> are
> >> suffering from is related to deadlocks or race conditions or misbehaving
> >> code in your thread model or whatnot... nor is it out of the realm of
> >> possibility that SQL Server itself is causing the operating system to
> hang
> >> at a time of high load from your application, due to its own internal
> >> operations.
> >>
> >> But by performance graphs, I'm referring to something that collects data
> of
> >> your system (cpu, networking, memory, paging, database queries/loads,
> etc)
> >> and provides graphs or raw data for you to get a general idea of where
> the
> >> problem may lie (take one of my servers, for example:
> >>
> >>
> http://kungfusus.gotdns.com/munin/localdomain/localhost.localdomain/index.html
> >> ).
> >> On my side of the fence in *nix land, I use something called Munin which
> >> does such a thing. I believe there's even a Munin node for Windows,
> >> although
> >> I'm sure there are solutions that suit the Windows environment far
> better (
> >> ie. http://www.monitortools.com/ ).
> >>
> >> Long story short, while it may not necessarily spell out what your exact
> >> problem is, at least you have some information about the mental state of
> >> your server in the last moments before it shuffled off this mortal
> coil...
> >> and
> >> this can be quite useful in narrowing down where the problem is.
> >>
> >> But, I have to say, it doesn't seem like you are doing anything too
> >> 'exotic', and considering that SQL Server is used by governments and big
> >> enterprise, I'd be surprised if there were serious stability problems
> >> merely
> >> from the process of exporting and importing.
> >>
> >> With regards to VisualSVN, well, personally, I do all my subversioning
> from
> >> the command line, because I felt relying too much on a GUI would one day
> >> put
> >> me at a disadvantage, but I recommend http://tortoisesvn.tigris.org/ .
> It
> >> integrates with Windows Explorer, so it's a level deeper than a plug-in
> for
> >> Visual Studio and has always worked rather reliably.
> >>
> >> However, it would be interesting to see if moving your app off to
> >> a separate workstation solves the problem... I think that would raise
> more
> >> questions than it would answer though! :p
> >>
> >> Hans-Christian
> >> Software Developer, UK
> >>
> >> -----------------------------------------------------------------
> >> tel: +44 (0)782 894 5456
> >> e-mail: hans.andersen at phulse.com
> >> www: nokenode.com
> >> -----------------------------------------------------------------
> >> Unique Gifts, Collectables, Artwork
> >> -----------------------------------------------------------------
> >> Come one
> >> Come all to
> >> www.corinnajasmine.com
> >> -----------------------------------------------------------------
> >>
> >>
> >>
> > _______________________________________________
> > dba-VB mailing list
> > dba-VB at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>



More information about the dba-VB mailing list