Hi Bert,
My name is Sonya Whitfield and I provided technical support for Dr. Jana Peters Office. I am going to try to address your technical questions.....
The computer which is housing the databases and SQL Server should have at least 2GB of memory, 4GB if possible. Second, the key is what is on the other computer? Is there anything elses utilizing SQL? What applications is it running? Is that computer isolated or being used?We have a dedicated box that is running Server 2003 and has either 3GB or 4GB of memory.
This box is dedicated to running AC only. It also has the Labcorp interface running on it.
Nothing else SQL is being used. No one uses this computer, it's dedicated to only running the AC db.
It would be helpful if I knew more about your network. Are you running peer-to-peer or client/server? Are you on a domain? What are you using for a server. What OS are you using? SQL Server Express can handle quite a few computers but that is given that it gets its full allotment of memory. While it gets 1GB of memory if your main machine has 2GB and is using 1.5GB, then SQL is running on 512MBs. The OS alone is going to take up its fair share.We are not on a domain. Just a workgroup where some local printers are shared. The All cat5e running to all the hardwired desktops and server. Desktops are running Windows XP, Server running Server 2003 and laptop are running Windows 7. The server hardware is a Dell Optiplex 755 with a 2.0Gz process with 3gb or 4gb of Ram. We were running on a XP box with 2GB of Ram, 1GB of RAM was consumed by SQL Express. So we upgraded to the newer box (mentioned above). We are running on a Cisco 2950, running a default vlan. Nothing really special to report here. Everything is running at 100mb. We have two WAPs servicing the wireless network. We have Lenovo U350 laptops with N wireless cards.
Here's the deal. I have tried to help people with this before (and at the risk of offending someone who has tried to work with my tech buddies -- I haven't heard the outcome), it has been quite frustrating. I have two guys I use to help me. They are good. One, Raja, remoted into my server the other day to help me with some ICD-9 code issues, and watching him in SQL Server Management Studio was like watching Michaelangelo. An artist. I have taught myself a ton about computers and networking, and I am determined to learn SQL. But, it is an entirely different beast. To work with it, you need a SQL Server expert and a DBA. [/i]I think you will need SQL Server 2005 Workstation or Standard. Yes, it will cost for licenses, but once you have them, you will not have the connectivity issues. Given it has much less issues with the amount of RAM it can use, you will probably want to have a server that can house a lot of RAM. A 32-bit OS is limited to 4GB which is really 3.2GBs. A 64-bit OS can hold up to 64GB of RAM. SBS 2008 on a decent server will give you that capability. 2008 comes with both SQL Servers 2005 and 2008, although you get a license only for one.[i]I will check into getting a FULL version of SQL server. Once we get it will AC help us migrate the DB over to the full version?
]Now installing AC to an instance of SQL Server 2005 and 2008 is possible, it isn't necessarily a walk in the park. This is where I would recommend an expert.I agree about the expert -- will the AC support folks not help us with this?
You can either utilize the two I mentioned in Experts Exchange (www.experts-exchange.com) which you probably won't, because no one ever does on here, or you can hire them directly.I know that Raja could likely log in and find out where your performance issue lies. The difference between the other group's method and the one I would recommend is they took forever going back and forth trying to set up a time and a method, when it is probably best to do a few emails and then let the SQL expert remote into your network and look at the setup.If you are interested at all in trying to fix things, let me know, and I will have Raja email you. I can't guarantee you that he will fix the problem, but I think you will know if SQL Express is the problem.Meanwhile, if you can give me more specs on your network hardware and software including network switches, cabling, router, Cat5e vs Cat6, etc., it would be helpful.Specs are listed above....
Thanks,
Sonya Whitfield