Question

Locked

Network Floods

By dbl ·
Hi I have an Access database with the front end on the local computers and the back end on the server. When anyone does a search for a record on our Access 2003 database it takes about 15 seconds to find the record it was taking about 1-2 seconds maximum. This has only just started and we haven?t made any system changes. (It?s been working fine for years).

The server is running on windows 2003 server and is running at about 10%, I have never seen it peak at any more than 25% usage. All 6 computers and the server are less than 2 years old. The system is all set up on 1000 network cards and so is the switch. All computers are on windows XP pro sp2.

All of the IP address are set to static, if I change any of the computers to automatically detect the IP address then when you do a search it only takes about 1-2 seconds as it use to do, but this only lasts for about 5 minutes tops then it goes back to 15 seconds or more. When you change it back to the static address again it works really fast but after a few minutes it goes back to being really slow. We have had 2 IT companies have a look at it but they just go away scratching their heads not knowing what to do to put this right all they say is its flooding the network when ever we do a search, they came to this conclusion after they had installed some software on the server to monitor the network.

Any help, ideas would be very much appreciated.

Regards Bob

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Do you have access to the data...

by Fregeus In reply to Network Floods

...they gathered on your server? I figure its probably a sniffer they installed on your server and I wonder if you still have access to the data stream?

If yes, can you isolate what traffic is flooding the network? Is there a lot of retransmissions, garbage, error notification, etc.


TCB

Collapse -

Access 2003 database is causing the flooding

by dbl In reply to Do you have access to the ...

No there are not any errors the only time this happens is when we do a search on our database. The rest of the time the system runs fine.

Bob

Collapse -

What TCB is asking is

by cmiller5400 In reply to Access 2003 database is c ...

what traffic did you see during the searches? Collisions, Errors, Garbage, ETC.

Collapse -

Error Messages

by dbl In reply to What TCB is asking is

Hi the only bits I can find on the server are the following error and information messages which are repeated very many times.

The DNS server has encountered a critical error from the Active Directory. Check that the Active Directory is functioning properly. The extended error debug information (which may be empty) is "". The event data contains the error.

And

The zone _msdcs.smallbusiness.local is configured to accept updates but the A record for the primary server in the zone's SOA record is not available on this DNS server. This may indicate a configuration problem. If the address of the primary server for the zone cannot be resolved DNS clients will be unable to locate a server to accept updates for this zone. This will cause DNS clients to be unable to perform DNS updates.

Regards Bob

Collapse -

Yup.

by cmiller5400 In reply to Error Messages

You got a DNS issue and/or an AD issue. Fix them and maybe it will sort out the search.

Collapse -

Where do I start?

by dbl In reply to Yup.

Ok but where do I start to sort out this problem?

Collapse -

From what i gather...

by Fregeus In reply to Where do I start?

The zone _msdcs.smallbusiness.local is configured to accept updates but the A record for the primary server in the zone's SOA record is not available on this DNS server. This may indicate a configuration problem. If the address of the primary server for the zone cannot be resolved DNS clients will be unable to locate a server to accept updates for this zone. This will cause DNS clients to be unable to perform DNS updates.


This means that in the SOA record of the zone _msdcs.smallbusiness.local, there are name servers assigned to answer request. That is usually the name of your dns server. Lets say, for an exemple, that your dns name is "pluto". Now, I see three possibilities here.

1- The SOA record does not list pluto in its record. If that is the case, you need to insert it in there.

2- The SOA record does list pluto in its record, but pluto is not in your DNS as an "A" record. If that is the case, you need to add an "A" record in the zone wiht the IP address of your server.

3- The SOA record does list pluto on its record, but it either lists the wrong domain. Like pluto.something.com when it should say pluto.yourdomain.com. If that is the case, change the SOA record to show the right domain.

I just thought of another possibility. It could be that your SOA record show pluto, but that the "A" record in your zone for pluto points to the wrong IP address. In that case, correct the "A" record in your zone to show the right address.

Hope this helps.


TCB

Back to Networks Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums