troubleshooting sql server 2000 slowness

  • Hi for few days i am going to work at client side which has sql server 2000. I am knew to it show just want to know where to look for helps .

    I mean suppose i want to know which query are executing at present then where to look . dbbc inputbuffer does not shows complete query then where to look.

    I want to know how much time it would require to complete a database backup/restore then which queries to use.

    some faster way to know fragmenatation in table

    Thanks and regards

    Anoop

Viewing 0 posts

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