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

jwcolby jwcolby at colbyconsulting.com
Sun Jun 13 10:45:26 CDT 2010


BTW, are you using Mercurial from an add-on inside of Visual Studio?  You mentioned that you just 
used command line source control and I really need a wizard interface, preferably integrated into 
Visual Studio.

John W. Colby
www.ColbyConsulting.com


Mark Breen wrote:
> 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
>>
>>
> _______________________________________________
> 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