GeeCON Prague 2014*
The moose likes JDBC and the fly likes SQL Server performace Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server performace" Watch "SQL Server performace" New topic
Author

SQL Server performace

Prem Khan
Ranch Hand

Joined: May 30, 2005
Posts: 189
I have an application that intermintently slows down. I am trying to trac down the probblems.

I hold open a jdbc connection with the standard JDBC driver from Micro soft.
and call heavy procs that both query and insert alot of records.

I also use apache torque to query on the front end servlet applcaition.

Any ideas ?

Has anyone had probblems with the JDBC driver from MS ?
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30580
    
154

Shawn,
The first thing to do is figure out whether the problem is in the driver/network or the database/stored proc. You can do this with something as simple as print statements in the code and stored proc.

When the app slows down, are multiple stored procs being run simultaneously? You may have contention and locks on the database causing the slowdown.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
GeeCON Prague 2014
 
subject: SQL Server performace