Hey everyone! I'm in a bit of a bind here. We have a SQL server that's linked to our CAD application, and it's been neglected for years. I recently discovered that it really needs a lot of maintenance, including indexing. The company we bought the CAD application from isn't willing to help us, only referring us to a friend who wants an exorbitant fee to basically redo our whole setup—way more than we need. All we're looking for is someone who can assist specifically with the SQL server. It seems challenging to find someone reliable for this. Anyone have any tips or suggestions on how to find the right person? Thanks in advance!
3 Answers
You mentioned that the database is quite old and hasn't seen any maintenance, which could definitely be causing those issues you've described. You may want to start by identifying if the core issues are truly with the SQL server. Sometimes, the perceived problems can stem from elsewhere. It might also be good to share which CAD software you're using since that could help others give more specific advice. Also, if you're considering overseas assistance, it might broaden your options.
If you're dealing with a custom database that hasn't kept up with user growth, reworking it could indeed be a significant project. That high quote might feel steep, but sometimes those costs can be justified because of the amount of analysis required to fix underlying problems. Trying to get help from various avenues is a good approach, so posting in different forums might help too!
I appreciate that, but trust me, the quote we received felt unjustified. We were looking for an expert, not an entire infrastructure overhaul!
I recognize your situation—Microvellum, right? I was surprised that their support team wouldn't help you directly; they have great internal teams for SQL issues. If you haven't already, try reaching out to any local support groups or independent consultants who might be more reasonable about pricing; they could offer practical help. It might also benefit you to utilize community resources or maintenance scripts like those from Ola Hallengren to get you started on cleaning up the database.
You're spot on with Microvellum! They mentioned shifting us to a third party, which just feels wrong when I know help could be more accessible. Thanks for the script recommendation; I’ll definitely check that out!
I get your point, but we've pinpointed these issues to the database. Our team has noticed specific performance lags and locking conflicts during peak times, which all signs lead back to the server.