Home Forums Discussions Problems problems with SQL server

I am currently running window XP pro, with one of the computer as the "server" where the SQL server is located, and the other two clients computer accessing the server. I use Lytec 2009 as my PM and started using Amazing charts in 2012. Overtimes, Lytec 2009 is taking longer and longer to access the SQL server. On average, it takes about 1 minute for the "server computer" to load up the information, and 2 minutes for the "client computer" to access the data base from the server. I don't have any problems with amazing charts. I was wondering if this is caused by conflicts between lytec and amazing charts. Any suggestions? thanks.

I hope amazing charts would come up with their PM soon so I can get rid of lytec!

They're likely competing for resources rather than for SQL. I believe Lytec runs on SQL 2008 while Amazing Charts runs on SQL 2005. The recommended amount of memory/RAM for Lytec is 4GB and AC also needs 1-2GB. The issue is that Windows XP is limited at 4GB (realistically at 3-3.3GB).

My first recommendation would be checking the Task Mananager by pressing CTRL+SHIFT+ESC on the XP server to see if memory usage is high. We are interested in the total and the amount available. The example below the total amount is ~2,000,000 K or (2 gigabytes) and the free amount is ~1,500,000 K or (1.5 GB).




Also given that the server is XP Pro, my guess is that the processor is also dated as well.

Thanks! I will give it a try.