PAGEIOLATCH_SH Performance Issue

• aruram

  SSCrazy

  Points: 2379

  More actions

  October 7, 2008 at 2:53 pm

  #99308

  Hi,

  One of our reporting Stored Procedures runs fine (1 sec) when run from SQL QA, but when it is invoked from application, it takes 10 mins to finish and frequently times out. The activity monitor shows a PAGEIOLATCH_SH in waittype.. any idea why this is happening?

  Thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  October 7, 2008 at 3:30 pm

  #882006

  Have you set SET NOCOUNT ON in the beginning of stored procedure?

  Did you ran the stored procedure just after running it in QA?

  MJ