|
Posts: 52
Joined: July 2021
|
|
#69857
09/20/2016 8:15 AM
|
Joined: Jul 2011
Posts: 8
Member
|
OP
Member
Joined: Jul 2011
Posts: 8 |
Is there anyone else who has database storage on-site and the server PC keeps stopping the services? I can't seem to tie it to any specific event, time or reasoning. It isn't that big of an issue, but it is like a splinter in my brain now. Any help would be great. Thanks!
|
|
|
|
|
Joined: Jun 2009
Posts: 165
Member
|
|
Member
Joined: Jun 2009
Posts: 165 |
Is there anyone else who has database storage on-site and the server PC keeps stopping the services? I can't seem to tie it to any specific event, time or reasoning. It isn't that big of an issue, but it is like a splinter in my brain now. Any help would be great. Thanks! I do not know the reasons but it happens quite a few times in a month.You have to do the following on your SERVER. START > SERVICES > STOP SQL services(Amazing charts)> START SQL services (Amazing Charts) Hope this helps Grenville 9AMA
|
|
|
|
|
Joined: Jul 2011
Posts: 8
Member
|
|
OP
Member
Joined: Jul 2011
Posts: 8 |
Thanks, at least I am not alone. I do know the fix but the cause is what is driving me nuts.
|
|
|
|
|
Joined: Apr 2014
Posts: 53
Member
|
|
Member
Joined: Apr 2014
Posts: 53 |
Just fyi, I have my own server and I have NOT had the issue you mention...
Sandy
|
|
|
|
|
Joined: Sep 2012
Posts: 342 Likes: 7
Member
|
|
Member
Joined: Sep 2012
Posts: 342 Likes: 7 |
Dear Schelprock,
It drove me crazy, too. One server did it, two others didn't.
AC tech suggested using task manager to auto-run a 2-line batch file late at night to stop and restart the service:
net stop "SQL Server (AMAZINGCHARTS)"
net start "SQL Server (AMAZINGCHARTS)"
You can put some pauses in and run it by hand to see if it works for your AC version, but it won't display onscreen when run from task-manager, due to windows-7-and-greater security.
From what AC tech said and the errors that I saw, it looked like a memory-leak problem. A daily stop and start probably resets things before the leak threw away too much memory.
Cheers,
Carl Fogel
|
|
|
|
|
Joined: Jul 2011
Posts: 8
Member
|
|
OP
Member
Joined: Jul 2011
Posts: 8 |
Thanks Carl, I will give that a shot for sure.
|
|
|
|
|
Joined: Jun 2008
Posts: 165
Member
|
|
Member
Joined: Jun 2008
Posts: 165 |
I was wondering, if AC is backing up nightly, does it not do the SQL stop and start already?
|
|
|
|
|
Joined: Sep 2012
Posts: 342 Likes: 7
Member
|
|
Member
Joined: Sep 2012
Posts: 342 Likes: 7 |
Dear Jack,
On my recalcitrant server, the AC backup started at 10 p.m.
The automatic stop-start-ac-services batch-file ran 8 hours later at 6 a.m.
Maybe this fresh start was enough to get the office through a 7 a.m. to 6 p.m. day?
Cheers,
Carl Fogel
|
|
|
|
|
Joined: Sep 2003
Posts: 12,856 Likes: 32
Member
|
|
Member
Joined: Sep 2003
Posts: 12,856 Likes: 32 |
What is your services set for Startup? Manual, automatic?
Your services should not be turning off randomly. This is really a sign of something else.
Bert
Pediatrics
Brewer, Maine
|
|
|
|
|
Joined: Sep 2012
Posts: 342 Likes: 7
Member
|
|
Member
Joined: Sep 2012
Posts: 342 Likes: 7 |
Dear Bert,
It seemed to be a sign of an AC bug.
Below is the full text of that nightly batch file.
Cheers,
Carl Fogel
:rem suggested by danny, dsouthiseng@amazingcharts.com
:rem lots of users, RAM on server used up
:rem error message about AC upgrade, need to run dbtuner
:rem restarting server fixed this
:rem but quicker & easier to stop & restart the non-agent AC sql on server
:rem run as a scheduled task after hours
REM Restarting SQL services
net stop "SQL Server (AMAZINGCHARTS)"
net start "SQL Server (AMAZINGCHARTS)"
|
|
|
|
0 members (),
25
guests, and
12
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
