• Hello, thanks for the reply. please see below

    Brandie Tarvin (4/18/2014)


    What is the specific kind of locks that you are encountering?

    (294ms)PAGEIOLATCH_SH:testdb:1(*)

    If I do a simple record count on a small table, it is taking long time

    How are your articles designed? Are they whole tables or queries? If queries, can you paste the offending ones here with an execution plan so we can look at them?

    Only the tables are present