Post reply

sql server 2005 blocking locks

  • June 3, 2009 at 9:51 am

    #1004147

    I would personally start with why you are getting blocking...?

    1. What hardware does the SQL server run on and is it enough?

    2. Check for "missing" indexes. The script attached uses dmv's that are collect since the last reboot. Not all indexes need to be created, so just use it as a guide.

    3. Do you update statistics?

    4. Why do you shrink the data files?

    JL

  • June 4, 2009 at 4:52 am

    #1004513

    Hi

    1. What hardware does the SQL server run on and is it enough?

    intel(R) Xeon(R) cpu 2.33ghz 32gb ram windows server 2003 sp2

    2. Check for "missing" indexes. The script attached uses dmv's that are collect since the last reboot. Not all indexes need to be created, so just use it as a guide.

    Actually I have a doubt, whenever server or sqlserver is restarted,is it necesserary to recreate the indexes?what happen to the index when we restart sql server at that stage?

    3. Do you update statistics?

    As i daily rotuine we are updating statistics after rebuilding the indexes/tables.

    4. Why do you shrink the data files?

    I can avoid this as per your advice.

    thanks

    vijay.s

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply