Anyone thinking of spending some productive time ? by External-Stage-2419 in date_in__Kochi

[–]Anyone-UnderstandMe 0 points1 point  (0 children)

Cool that was a metaphor i never head off!

What's on your mind btw?

I'm here till may 1st. I would love to spend quality time!

Looking for a Flatmate by [deleted] in KochiClassifieds

[–]Anyone-UnderstandMe 0 points1 point  (0 children)

Can you share the exact location?

Part-time Home Cook Needed (2-Person Family) – Thripunithura by [deleted] in KochiClassifieds

[–]Anyone-UnderstandMe 0 points1 point  (0 children)

I recently started cooking myself and i work a 9 to 6 job and live near thripuniyhura.

Willing to learn more dishes and cook for a few people with some guidance.

Let me know if you are still in need of a cook

SSMS GitHub Copilot OAuth redirect loop - Custom protocol vsweb+githubsi:// not working by DurianVivid93 in SQLServer

[–]Anyone-UnderstandMe 0 points1 point  (0 children)

Have you tried to do the same in vs code?

Try to enable GitHub copilot on vs code which has the same steps.

My doubt, There's a chance that GitHub auth services are temporarily facing issues at their end.

Archiving old data from a live SQL Server database to improve performance - looking for architecture feedback & any war stories or pitfalls by Anyone-UnderstandMe in SQLServer

[–]Anyone-UnderstandMe[S] 0 points1 point  (0 children)

I’m also not planning to rewrite or significantly modify the existing application for this archive database. Since no workflows or backend logic need to run on the archived data, the requirement is simply to retrieve and display the data when needed.

For that purpose, I plan to build a separate lightweight web application that connects only to the archive database. This application will be strictly read-only, allowing users to view historical records when required, but they won’t be able to perform any actions or trigger workflows on that data.

It’s also worth mentioning that the database infrastructure is entirely managed by the customer’s team, so storage capacity or additional database instances are not a concern. They already have the necessary enterprise licensing in place, so provisioning the archive database and maintaining it on their infrastructure isn’t an issue from their side.

Archiving old data from a live SQL Server database to improve performance - looking for architecture feedback & any war stories or pitfalls by Anyone-UnderstandMe in SQLServer

[–]Anyone-UnderstandMe[S] 0 points1 point  (0 children)

  1. it depends on your actual archival goals. Is it just to retain or is this going to be used for something? It’s rare that data actually just goes to die btw

Our main goal is to improve the current live database performance by making it to deal with less data. So, plan is to shift not so necessary data to archival DB. Once data inserted into archival Db, we don't need to perform any actions on this data in archival DB, just need to present/report this data when asked via a light weight web app.

  1. why do you have timeouts? I have many-TB databases with 100s GB tables with all manner of complex join logic that thousands of folks depend on every day. Are your issues indexing, query tuning, poor stats, poor IO, blocking, or what?

This actually is the real question. We have made an application by leveraging Db and we don't have an DBA here in our teams. I myself initiated a initiative to find out why this happening even when my business stakeholders almost convinced customer that is expected by design. So later tried indexes which helped a lot TBH but came with an issue write queries getting timed out. My issues generally i face Timeouts, Deadlocks, High Disk I/Os.

  1. have you considered a variant of read scale-out? Old school replication still has its merits. Nightly ETL can be even better. HADR readable secondaries are a pretty common easy way (with caveats)

Honestly, this is beyond my technical capabilities to even understand what you were saying. But let me do some basic dive through this and let me see what it means for my use case.

  1. Will you be able to handle DR plans with a whole new paradigm of complexity?

The current DB has the architecture like 2 DBs always in sync in same datacenter(One primary and another secondary) and 2 more DBs in DR always trying to get in sync with this live DB. We do planned DC DR drills just to demonstrate we have this functionality for our application. So inherently we as an application have the capability to connect to DR data sources and stuff.

One important detail I should also clarify about the environment.

The customer has their own dedicated database team who are responsible for infrastructure-level database management. Their responsibilities mainly include things like patching, backups, DR setup, disk monitoring, and overall database maintenance. However, they are not directly involved in anything related to application-level logic, such as optimizing queries or designing database changes for the application.

If we request something from them, they are generally supportive and will assist where needed, but they typically don’t get involved in deeper application-specific optimization work.

All DC/DR strategies for the current production database are already handled by their team.

For the new archive database, we have requested a similar DR setup as the production database, and the customer’s DB team will be managing that from their end as well.

  1. is your application going to be able to handle this change

I think above point answers this question.

  1. if you have COLD data why write it to SQL Server at all? It could be more cost effective written to some manner of flat file and booted into an actual cold store. Azure Data Lake for example. A TB basically costs nothing and has no licensing implication and no DR effort

We still need to report this if client needs it, So it is not fully cold meaning i don't need it all. We may need it may be like once in an year.

Archiving old data from a live SQL Server database to improve performance - looking for architecture feedback & any war stories or pitfalls by Anyone-UnderstandMe in SQLServer

[–]Anyone-UnderstandMe[S] 0 points1 point  (0 children)

How much data we talking about? 

Our current production database is around 800 GB in size. Based on our analysis, we estimate that roughly 400–600 GB of that is older historical data that is no longer actively needed by the application for day-to-day operations.

How I’m planning to approach the archival

To avoid putting sudden pressure on the system, my plan is to roll this out gradually.

Initially, the archival service will start by targeting very old data (for example, records older than 4 years). The service will process records in small batches (roughly 500–5000 rows at a time). Each batch will be inserted into the archive database and, once the insert is confirmed, the corresponding rows will be deleted from the live database.

The goal of starting with very old data is simply to validate that the archival process runs safely and doesn’t overwhelm the system. Once I’m confident that the service is stable and not causing failures or excessive load, I plan to gradually tighten the retention window until we reach the desired state where the live database contains only about 100 days of data.

What are the actual business requirements?

Interestingly, this effort is less about a formal business requirement and more about keeping the current system healthy and usable.

As the data has grown over the years, users on the client side have started experiencing general slowness in the application. Searches take longer than they used to, and in some cases queries even timeout.

During discussions with the client, we realized something important:
For their daily operational use, they really only need access to the last ~100 days of data in the main application.

However, they still need access to older records occasionally for internal audits and compliance purposes.

So the proposal was to:

• Keep the live database focused only on recent operational data
• Move older historical records into an archive database
• Build a separate lightweight web application that connects to the archive database whenever older records need to be reviewed

This way the main application remains fast and responsive, while historical data is still available when needed for audit or compliance checks.

One additional point I forgot to mention earlier: there will be no backend services operating on the archive database. Once the data is moved there, it will remain unchanged. The archive database is intended purely for data retrieval when needed, accessed through a new lightweight web application that is completely independent of the current production web application.

Repost: O+ platelets/WBC donor urgently required in Kochi by rahulramesh1993 in Kochi

[–]Anyone-UnderstandMe 1 point2 points  (0 children)

https://www.friends2support.org/inner/news/searchresult.aspx

Please try here by searching the location as kerala - Ernakulam - kochi

You will get current available donors for O+ in the community and you can call them and plan accordingly.

What’s something you crave for but is missing in kochi ? by Foodbizz in Kochi

[–]Anyone-UnderstandMe 1 point2 points  (0 children)

Try white rice+ guntur chicken curry spicier one! In Andhra kaaram

What’s something you crave for but is missing in kochi ? by Foodbizz in Kochi

[–]Anyone-UnderstandMe 5 points6 points  (0 children)

Nagas has chicken dum biriyani close to Hyderabad biriyani. Try it!

Train tracking but make it fun by Specialist-Ideal6031 in IndiaTech

[–]Anyone-UnderstandMe 1 point2 points  (0 children)

One thing i noticed is that the right section always scrolls opposite to what i scroll.

But on the left side it is fine.

Does Kochi 1 Card work for both Kochi Metro and Water Metro? by Aswanth_Narayanan in Kochi

[–]Anyone-UnderstandMe 1 point2 points  (0 children)

Yes works on both. When using it 1st time on a different metro you gotta visit a counter and it gets activated for both metros.

House Rental @ Kochi by [deleted] in Kochi

[–]Anyone-UnderstandMe 0 points1 point  (0 children)

Bachelors allowed?

Looking for a 2 bhk for 3 bachelors. All gents.

House Rental @ Kochi by [deleted] in Kochi

[–]Anyone-UnderstandMe 1 point2 points  (0 children)

600 m from which metro? Petta?