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.
| 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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
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. |
 |
|
|
|
|
|