Chapter 39. Tuning JDBC for SQL Server

Jungsun Kim

When I look at the queries sent to SQL Server via JDBC, the query methods are often not optimized for SQL Server, resulting in performance issues. This problem has occurred in all of my customers’ systems that use JDBC to access SQL Server. JDBC-based applications will have performance issues if appropriate steps aren’t taken to correct the problems caused by JDBC.

For the last few years, I’ve diagnosed many performance problems for Java-based applications using the JDBC driver to access SQL Server. Doing so has required a lot of trial-and-error testing, but eventually I was able to come up with techniques to help resolve the performance issues.

In this chapter, I’ll share what I’ve learned, ...

Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.