CPU burden is minimal--never more than 20%.
The msde is taking up around 80MB of ram with 4 clients connected for less than one day...normal?
Main Topics
Browse All TopicsI have speciality software that is running on a windows 2003 server for small businesses (this was a Dell-ordered clean install system). The software was installed and it uses the Microsoft SQL Desktop Server Engine, so it installed/configured that too. This has been done at about 3-4 other locations and everything has been fine.
However, at this location (4 clients all running the software accessing the SQL Desktop Server on the 2003 Server), the clients are running very slow (about 2-3 times slower than they should).
The connection is apparently still being made because after 10-20 seconds or so the software responds and continues to respond slowly. Data is slowly being loaded into the client programs from the server.
I have tried to troubleshoot it. Thought it might have been some kind of hardware...shut off all but one computer a couple of times. I turned off the cable modem. I replaced the switch connecting the computers. I even brought another switch in and connected only the server and one client on their own 2 node network...still as slow as before. To test the network connection, I downloaded Service Pack 2 network install (~260MB) and transfered it between the two computers (client-->server) and back (server-->client). It took around a minute or less...which is about what it should be...no problem there.
I am at a loss...I've run out of ideas. I figure it must be some problem with the server configuration, specifically the SQL Desktop Server Engine...but I know so little about it that I thought I would ask here for some advice...please help!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Not sure if SQL is actually the problem.
We have also noticed degradation of file transfer/copy speed on Windows 2003 Enterprise, Domain Controller Servers.
There are several registry patches listed on MS web site. I have tried two that did not work. Our network admin has found one that worked on his none production network. We have not had the opportunity to get together on this yet, however it is becoming a problem for me “and another network admin we know” so we are likely to get on it soon.
Today I am setting up a new development workstation that will be running against SQL 2000 on the Win2003 sever where we are experiencing the slow transfer/copy problem. Will let you know later today if we encounter your problem here.
In the meantime here are related KB articles for Win 2003;
http://support.microsoft.c
Keep the faith, we are all in this together!
PS how much RAM you got?
We have servers running;
System Ram FreeRam
1) 512 60
2) 1GB 329
3) 512 120
Problem solved. I dont know how to close the question without awarding points at nothing given was the answer. The problem was that because this software uses TCPIP...the Norton Corp edition on the workstations was deep scanning the traffic as if it was virus activity. Disabling the Norton fixed the problem, but now we need to find out how to massage the Norton settings to allow for this activity without stopping the aV software completly...
Anybody have any experience doing this with Norton?
We also are using "Norton Corp" and do not have this problem, however we are using ADO w/ ODBC System DSN's for connections.
Post a link to this question on the "Community Support" forum noting that you solved the problem yourself; an EE mediator will close the question and refund your points.
BTW Open “Norton’s System Console” Help and search TCP, I think you will find your answer there.
TaTa for now,
Greg
Business Accounts
Answer for Membership
by: SurferJoePosted on 2005-04-19 at 08:03:19ID: 13816104
If you have access to a computer with the "SQL Server Enterprise Manger” installed on it. You can launch “Tools, SQL Profiler” this should give you a good idea of where the bottleneck is, and what resource usages are. You can also look at the server’s configuration settings for memory usage etc…
Have you taken a look at the “Windows Task Manager” to see what the memory usage and CPU burdens are?