Solution for Intermittent Delays while viewing/entering data

The network is the forum.

Moderators: Steel, notfred

Solution for Intermittent Delays while viewing/entering data

Postposted on Mon Mar 01, 2010 3:51 pm

Hardware:
Server - Athlon II 630 2.80, 4GB of RAM, W2K8 32-bit, NIC 1Gb
W/S - various CPUs, 2/4GB of RAM, XP Pro, NIC - 100Mb

Software:
Client/Server based application runs on MS Access

Problem:
Intermittent Delays lasting upto 30 secs while entering and/or viewing information on w/s.

Any help would be appreciated.
Last edited by michael_d on Sat Mar 06, 2010 5:04 pm, edited 1 time in total.
Core i7 960 3.2GHz | 12GB RAM | 1.5TB HD | Asus GTX Titan | Dell WFP 3008 30" 2560x1600 | Windows 7 Ultimate 64 Bit
michael_d
Gerbil Elite
 
Posts: 562
Joined: Sun Dec 16, 2007 2:42 pm

Re: Intermittent Delays while viewing/entering data

Postposted on Mon Mar 01, 2010 5:58 pm

How large is the database?
Image
Nitrodist
Grand Gerbil Poohbah
 
Posts: 3280
Joined: Wed Jul 19, 2006 1:51 am
Location: Minnesota

Re: Intermittent Delays while viewing/entering data

Postposted on Mon Mar 01, 2010 6:07 pm

Nitrodist wrote:How large is the database?
And how many simultaneous users of the database, particularly updating users?
UberGerbil
Gerbil Khan
 
Posts: 9980
Joined: Thu Jun 19, 2003 3:11 pm

Re: Intermittent Delays while viewing/entering data

Postposted on Tue Mar 02, 2010 9:55 am

UberGerbil wrote:
Nitrodist wrote:How large is the database?
And how many simultaneous users of the database, particularly updating users?


-Number of users less than 10
-DB size is around 80MB
Core i7 960 3.2GHz | 12GB RAM | 1.5TB HD | Asus GTX Titan | Dell WFP 3008 30" 2560x1600 | Windows 7 Ultimate 64 Bit
michael_d
Gerbil Elite
 
Posts: 562
Joined: Sun Dec 16, 2007 2:42 pm

Re: Intermittent Delays while viewing/entering data

Postposted on Sat Mar 06, 2010 5:03 pm

Solution found for those who may encounter the same problem. Quick Books 2010 SQL Server has a conflict with MS Access Database Management application if they run on the same server which would cause performance dips in MS Access application. They simply need to be installed on separate servers.
Core i7 960 3.2GHz | 12GB RAM | 1.5TB HD | Asus GTX Titan | Dell WFP 3008 30" 2560x1600 | Windows 7 Ultimate 64 Bit
michael_d
Gerbil Elite
 
Posts: 562
Joined: Sun Dec 16, 2007 2:42 pm

Re: Solution for Intermittent Delays while viewing/entering data

Postposted on Sun Mar 07, 2010 9:32 pm

That's a workaround, not a solution. :evil:
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.
titan
Grand Gerbil Poohbah
 
Posts: 3276
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains


Return to Networking

Who is online

Users browsing this forum: No registered users and 6 guests

cron