Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Performance issues when running other applications

Author  Topic 

roel_vz
Starting Member

16 Posts

Posted - 2008-04-17 : 04:56:57
I have a question about some problems when running SQL Server 2005 together with an application on the same machine (it's a JBoss application). The machine has 3GB which is more than enough of memory for our application + SQL Server.

When our application is running I notice a very large increase in the query execution time. When the application is run on another machine though, we do not notice this slowdown.

Both SQL Server and JBoss are using a different disk. (RAID1 and RAID5 respectively).

Any help or hints where I can start to find the reason for this problem.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-17 : 13:01:47
Well SQL Server should be on its own dedicated server. But if you need them to be on the same server and the application is causing performance issues, then you should increase your hardware specs. Run Performance Monitor to figure out where the hardware bottleneck is when both are running.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

roel_vz
Starting Member

16 Posts

Posted - 2008-04-18 : 08:02:10
Thank you for your answer. I think we will just install our application on a different machine.
Go to Top of Page
   

- Advertisement -