File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "SQL Server performace" Watch "SQL Server performace" New topic

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

Joined: May 26, 2003
Posts: 33117

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: SQL Server performace
It's not a secret anymore!