Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Perf Problems w/ SQL Server 7.0

 
Tapan Parikh
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am getting terrible performance using Jrun w/ SQL Server 7.0. Im using the standard Merant drivers supplied w/ Jrun. We thought that the problem could be with connection pooling, so weve tried many options of how to allocate connections but none seem to be too great. We have a lot of tables in the DB (>150).
Has anyone had similar problems? Does anyone have any ideas on how to troubleshoot this and get an idea of what is causing the slowdown?
--Tap
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Most of the problems occur in the code itself. You must fully understand how the database implements lockings, transactions, concurrency control, etc. If you don't your code may seem correct when in fact it is causing a major problem.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic