The ULTIMATE CHALLENGE: SQL Database performance issues with Goldmine CRM
Posted on 2010-08-16
We have an issue with a customer that's going on over a year now.
For the past year, they've been having terrible performance issues with Goldmine installed on 2 client PCs that use a SQL database on their server. I'm going to provide as much info about their setup as possible to help whomever reads this get the best idea of our setup.
Goldmine connects via ADO.NET to this DB. This DB is very large (4GB for 2 users). This is because they've been using Goldmine for 15 years and are in graphic design, so their email attatchments are large.
They're running MS SQL 2005.
The company has a dedicated Goldmine technician who's also been unable to pin-down the issue. We've contacted Frontrange, and they of course can find no issue. He has completely re-created the DB from scratch, run performance tests and consulted others. According to him, the DB is performing fast.
At completely random times throughout the day, performance slows to a crawl. It may take 10 minutes for them to switch between emails when they click one in their inbox. Sometimes it's 10 seconds, and for days it will work fine for both users. One user can be running fine, while the other is at a standstill. Both users could have days w/o problems, then both will experience the issue at the same time. There is no rhyme or reason to it, and it's starting to jeopardize our relationship with them.
We have tried literally everything to try to resolve this. We've replaced their switch w/ a new gigabit Netgear, rewired their CAT5, replaced NICs, installed new desktops, moved the Database to it's own own Windows server 2008 R2 box, ran ping tests from clients to the dedicated SQL server over 3 days which dumped to txt file w/o a single dropped packet.
We've turned off AV software for a week at a time on both the client PC & server with no change. They have 2 WAN connections so they won't loose connectivity. They're of course always running the latest version of Goldmine & all servers have the latest OS updates. I can't find anything that may be related in event logs, or program logs.
I know we've done even more things to resolve this, but as it's been an entire year I can't recall everything we've done anymore.
The only thing we've been able to say for certain is that Goldmine is loosing connection to the database when this happens, somehow. Sometimes it will wait up to 10 minutes & reconnect. Sometimes it gives an error that it's dropped the connection.
RANDOM RANDOM RANDOM!
I've never experienced this level of difficulty resolving an issue before. We highly value this customer and are at our whits end with this. We will be posting for help from Rent-A-Coder for some kind of SQL expert to have a look at this, but I wanted to post here as well, now that I have more information about how Goldmine works.
PLEASE, I need the best of the best on this issue & will be awarding as many points as possible for any kind of help to resolve this. The problems are killing their productivity.
Also, please don't respond with help-desk level suggestions like "try rebooting the server." We're not SQL knowledgeable, but we're not idiots either.
[b]I NEED REAL ANSWERS![/b]
I'm not sure of the exact rules here, but we're willing to compensate someone beyond points if they can provide real help on this.
Thanks for taking the time to read this and for any help you can provide.