We have Quickbooks Enterprise 12 and have the same problems, it slows to a crawl. I reboot the server, and it's good for another 3 to 4 weeks. it is the only application on the server, a DL360 G4 with Dual Xeon processors and 2Gb of RAM... Monitoring memory and processor usage, I see no slow increase in either, it's just a case of "Hey, Quickbooks has slowed down!", I reboot the server, and "Thank you, Quickbooks is fast again"
I blame it on bad programming on Intuit. YMMV Michael -----Original Message----- From: Micheal Espinola Jr <[email protected]> To: "NT System Admin Issues" <[email protected]> Date: Sat, 1 Sep 2012 15:36:16 -0700 Subject: Re: Quickbooks getting slower and slower I have reservations that the .NET version would effect performance - it would either break or fix an issue. In my experience, Quickbooks performance is usually effected by network performance/configuration settings (typically on the server) - as per the reasons that others have already sited. I would recommend systematically going through all configs/service settings to make certain that they are optimal for your environment. OS filesystem settings should be involved. Next, I would take a look at the database itself: Size, objects, etc. You may have reached a performance threshold in the database. Question: Did the performance issues start to occur after a server update? -- Espi On Fri, Aug 31, 2012 at 12:58 PM, ANDREW F OFALT <[email protected]> wrote: Well, we have standalone clients, so its not the server. On a couple of machines I worked on reinstalling .NET 1, 1.1,2,3,3.5 seemed to fix "a" quickbooks problem. On others I have noticed that Quickbooks sometimes updated or installed some .NET software. On others I noticed that there are .NET updates that have not installed, but quickbooks runs ok. So I am not sure it is .NET, but suspecting it *might* have something to do with some of the slowness and popups we are seeing on some computers. So I am thinking that Quickbooks has some .NET code in it. Maybe, but, not a lot of time has been spent on Quickbooks. Just looking for verification, so I threw it out there. Andy0 ----- Original Message ----- What particular reason are you suspecting .NET to be the problem? Original Message: ----------------- From: ANDREW F OFALT [email protected] Date: Fri, 31 Aug 2012 14:46:31 -0400 (EDT) To: [email protected] Subject: Re: Quickbooks getting slower and slower on ours, i have been suspecting .NET, but I have not been able to prove it yet. Andy0 ----- Original Message ----- Found out that Intuit remotely moved Quickbooks from the server (wish I had known this earlier, lol) to a user's PC in hopes of fixing the problem. That's the Database Service wasn't running on the server. However, it wasn't performing any better on the user's workstation either. Doing the same tasks in a different Quickbooks file such as the sample file, results in things working as fast as expected. Only when using the company file do things get slow... So now we're waiting on a response from Intuit's datamanagement team. Fun. Thanks for the tips. Original Message: ----------------- From: Hank . [email protected] Date: Fri, 31 Aug 2012 11:28:42 -0400 To: [email protected] Subject: Re: Quickbooks getting slower and slower The "database service" definitely needs to be running. Even though they tout they have an "enterprise version" it really isn't a true database server. So stuff still works but really slow when the "database service" isn't running. On Fri, Aug 31, 2012 at 11:00 AM, [email protected] <[email protected] > wrote: > I just checked, and the QuickbooksDB22 service (Description listed as > "Quickbooks Database Service" is set for Disabled. The "Logon As" account > for that service is .\QBDataServiceUser22... Strange that it's disabled, > especially since you said your issues went away after it was running. I > might call Intuit and see if that service is supposed to be running. ?? > > Aside from that, I can't find anything wrong on the service except messages > once per day related to the USB backup drive Seagate GoFlex Desk Adapter > 3.0. The event log shows "The driver detected a controller error on > \device\harddisk2\dr2" nearly every other day at 7am (no idea the > significance of 7am since my backups run at Noon and 11pm to that drive). > I'm doubting this is related to the slowness issue with Quickbooks however > since those errors go back longer than when users started reporting > slowness with Quickbooks. I may still run a chkdsk /r on the server > anyways... ? > > > J > > > > Original Message: > ----------------- > From: Hank . [email protected] > Date: Fri, 31 Aug 2012 10:40:05 -0400 > To: [email protected] > Subject: Re: Quickbooks getting slower and slower > > > The "enterprise version" is not true client server (thats why you still > need to have a share with wide open permissions to the company files) so > make sure networking is solid. > > I had one case where the "database service" didn't start on the server and > the users complained about slowness. > > How big is the company file? > > > > > > On Fri, Aug 31, 2012 at 9:45 AM, [email protected] > <[email protected]>wrote: > > > Have a customer with an SBS2011 server. Server is basically brand new > > (good specs). For the last 4 months, no issues. Then over the last 3 > > weeks, their Quickbooks (Enterprise 12.0) has been getting slower and > > slower when saving invoices and work orders, etc. Initially it would > start > > taking 2 minutes, or 5 minutes, and now 10 minutes just to save a single > > invoice or work order. Prior to 3 weeks ago, everything was fast as can > > be. > > > > Quickbooks support hasn't been too helpful -- they keep pointing at the > > server itself, but Task Manager and Resource Monitor don't show any areas > > of bottlenecking (CPU, memory, disk, etc.). Users also say it doesn't > > matter if only ONE person is in the office, and using Quickbooks, they > > still get the slowness problems... So it's not load related either. > > > > I'm guessing right now there's something corrupt wiht the database maybe > or > > a problem with Quickbooks, but this is just a wild guess at this time. > > > > Thoughts? > > J > > > > > > -------------------------------------------------------------------- > > mail2web.com – Enhanced email for the mobile individual based on > > Microsoft® > > Exchange - http://link.mail2web.com/Personal/EnhancedEmail > > > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > > > --- > > To manage subscriptions click here: > > http://lyris.sunbelt-software.com/read/my_forums/ > > or send an email to [email protected] > > with the body: unsubscribe ntsysadmin > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > > -------------------------------------------------------------------- > mail2web.com – Enhanced email for the mobile individual based on > Microsoft® > Exchange - http://link.mail2web.com/Personal/EnhancedEmail > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin -------------------------------------------------------------------- myhosting.com - Premium Microsoft® Windows® and Linux web and application hosting - http://link.myhosting.com/myhosting ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin -------------------------------------------------------------------- mail2web.com – Enhanced email for the mobile individual based on Microsoft® Exchange - http://link.mail2web.com/Personal/EnhancedEmail ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
