Performance Issue

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  June 3, 2008 at 2:22 pm

  #121877

  Guys,

  I am running the same query in the same copies of databases on 2 different instances it gives me different time periods

  10 secs for on instance A and 90 secs for on instance B. The database on instance B is exact copy/restore of database on instance A.

  The execution plans for the query is also same from Instance A and Instance B.

  How do I start troubleshooting the performance on the Instance B?

  Any suggestions and inputs would help.

  Thanks

• Jim

  SSCrazy Eights

  Points: 8720

  More actions

  June 3, 2008 at 2:23 pm

  #823868

  Are the hardware specs exactly the same on both machines?