Post reply

Bench Test

  • September 29, 2003 at 10:16 pm

    #81165

    Hi All

    Is there any scripts that you can run to see if SQL or MSDE is working ok, i work for a company which installs MSDE and SQL in some schools, they use a program to convert/update the SQL db from DB 3 files, some work ok, others seem to hange, but if we copy all the files required to a latop then it works fine, i was just wondering if someone has some script that runs on SQL or MSDE which show how SQL is performing.

    Thanks

  • September 30, 2003 at 2:12 am

    #476311

    If you have a connection to the server using Query Analyzer, running sp_who2 and sp_lock can show you if the process is stil running.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 30, 2003 at 3:50 am

    #476332

    Microsoft's own clustering software just executes 'SELECT @@SERVERNAME' to see if an instance is alive.

  • September 30, 2003 at 9:54 pm

    #476475

    Thanks, i will give it a try when i go back to a school

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

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