Max CPU and Memory Usage SQL Server 2008

[graven21]

Hi all,

I have an extraction server that stores xml entries on SQL Server Enterprise Edition (Evaluation trial) then forward it to My SQL 5.1. The application supposedly run 24/7 downloading xml files every 35 seconds on the production server,mean while i'm testing it on our test server.

For the first 20 hours, the application runs well but i noticed in exceeding more than 24 hours the sql CPU usage and Memory are too high as a result the application's performance is slow.

i run "sp_who2" and noticed that there are "RUNNABLE" processes.I also checked the activity monitor of sql i oberved the cpu usage is high (80-90%) and memory usage was increasing as time goes on even reaching morethan 1GB.Is this a database issue?

Please let me know.

Test Server: Windows Server 2008 Standard Edition (x64)
.NET Framework: 2.0
SQL Server: Enterprise Edition Evaluation
My SQL: 5.1 version

I'm using Linked server in SQL Server 2008 to communicate with My SQL

Thanks in advance!

keep posting!