New answers tagged

1

Performance Improvements REST GIS web service >> JSON object >> Parse the JSON into individual records >> Generate XML for each record >> Process the XML records with Java classes >> Insert the records into the database. You have a GIS database which - I assume, its an Oracle database. On the assumption that you don't need the ...


0

Seems it's your follow-up question of this.. Hope you got root cause of the issue using FailoverDetection tool. Perhaps the cause could be from either Internal Health Issue or system wide issues as detailed here... Why is that happening? As you found in error log, the AG trying to take recovery actions, as part of that either AG resources could fail-over ...


0

While CDC is one useful methodology in SQL Server, it can also be a little performance heavy too depending on how much data and how frequently it changes. You might want to consider a 3rd party tool to manage your synchronization between SQL Server and SQLite, which can help minimize the performance and maintenance overhead of a homebrew solution. For ...


Top 50 recent answers are included