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

jwcolby jwcolby at colbyconsulting.com
Sat Jun 12 08:19:40 CDT 2010


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
> 
> 



More information about the dba-VB mailing list