April 17, 2008 at 2:58 am
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.
April 17, 2008 at 6:11 am
No doubt you're seeing contention for memory & processor. You'll need to run Perfmon and collect counters on wait times to see what is waiting on what. Where possible (and I know it's not always possible) it's best to put SQL Server into it's own machine because it just doesn't play well with others.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 17, 2008 at 6:13 am
It could be a number of different things. The application may be using too much memory causing SQL to cache to virtual memory, you could be contending for processor time, they may be accessing the same disk arrays, etc.
Ultimately, the solution is probably to move the application to it's own server. You could reduce the resources used by the SQL server, but if you do not have the ability to do the same with the JBOSS application, it will probably continue to steal resources that the database server needs. It would probably be good to spend some time using PerfMon to see what resources are being used up, but when you figure it out you will need to be able to increase the resource or throttle the use - if you can't do either of these you will have to move one of the contending applications.
April 17, 2008 at 7:12 am
Thanks for your answers.
I guess I will have to try to convince some people to put our application on a different machine. I don't have the time to find out what exactly is going wrong with perfmon or any other tool, not in the least because of my limited knowledge of SQL Server.
When the application runs on a different machine everything seems to run fine. So that would be enough for me 🙂
April 17, 2008 at 11:38 am
Please check on these before you do any decision. run sp_configure and see if you have allocated correct memory space for the server where you are running into problem. Maybe your other server has this configured correctly to take advantage of the memory. Like what Grant said, SQL server does not play well with others. So you want to make SQL Server to have the max memory in this case. It is turned off by default. Look into it and let us know.;)
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
April 18, 2008 at 3:31 am
The max memory was set to 1GB. I changed it to 2GB and the problem is still occuring.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply