JDBC for SQL2005 version 1.2 performance problem

• grldsrw

  Newbie

  Points: 7

  More actions

  October 13, 2008 at 7:34 pm

  #213990

  I have an application run with SQL2000 originally, last month the database has been migrated to SQL2005, I've updated the jdbc driver to version 1.2 accordingly, but found the performance of the application is greatly downgrade, it take around 4 times as long as before for the same task.

  Thanks for any suggestion!

• noeld

  SSC Guru

  Points: 96590

  More actions

  October 14, 2008 at 2:11 pm

  #884877

  Verify that you have updated the stats on all your tables (preferably with FULLSCAN)

  and you should also run DBCC UPDATEUSAGE on each DB.

  
  * Noel