1 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Merging individuals

Merging individuals hangs.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Merging individuals

Hi Charlie
How long did you leave it? Merging individuals takes a lot longer than other types of merges, since virtually every database table contains links to the individuals to store the person who last entered and last changed each record. Therefore every table needs to be searched for the person you are merging.
Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Merging individuals

Well it seems to be taking a lot longer than it used to.

Can I recommend some kind of activity notice for these situations - waiting 8 hours for Recorder to finish, when it turns out it's hung is getting annoying.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Merging individuals

Charlie,

I find the best activity monitor for these situations is a combination of Windows' own Task Manager (or better yet Process Explorer),  and SQL Server Management Studio tools such as the SQL Server Profiler and Activity Monitor. If you keep an eye on these it's easy to see if SQL Server, or Recorder, is doing any processing or not.

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

5 Reply by charliebarnes (edited by charliebarnes 19-04-2010 14:43:09)

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Merging individuals

charlesr wrote:

I find the best activity monitor for these situations is a combination of Windows' own Task Manager (or better yet Process Explorer),  and SQL Server Management Studio tools such as the SQL Server Profiler and Activity Monitor. If you keep an eye on these it's easy to see if SQL Server, or Recorder, is doing any processing or not.

How elegant. Sadly, I find the kill switch far too tempting when I have the task manager open (and very unreliable w/regard to Recorder activity).

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

6 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Merging individuals

It's mainly SQL Server I keep an eye on, not Recorder itself. I definitely wouldn't want to be killing the SQL Server process via the task manager! The above mentioned tools are as reliable a means of monitoring for activity as it gets so I'm not sure what else beyond these would be useful. Did you have something else in mind?

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

7 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Merging individuals

charlesr wrote:

Did you have something else in mind?

I'm not interested in monitoring activity per se, all I want is an assurance from Recorder that it hasn't hung and is still working (i.e. redrawing the window so you're not left with a blank screen).

You can't expect Tom, Dick or Harry to open up the task manager and watch for signs of activity from sqlserproc.exe

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website