Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning All queries running slow after moving the db from staging server to production Server in SQL Server 2008 R2 RE: All queries running slow after moving the db from staging server to production Server in SQL Server 2008 R2

  • June 14, 2013 at 9:31 pm

    #1624313

    This is what I get as on wait stats output

    WaitTypeWait_SResource_SSignal_SWaitCountPercentageAvgWait_SAvgRes_SAvgSig_S

    OLEDB103923.24103923.24025341970.730.41010.41010

    CXPACKET23462.7122882.71580372167415.970.00630.00610.0002

    LATCH_EX7059.456811.85247.652829814.80.00130.00130

    PAGEIOLATCH_SH4573.954555.518.452213093.110.02070.02060.0001

    WRITELOG1256.891212.0644.838804830.860.00140.00140.0001