Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    358
    Thanks
    2
    Thanked 0 Times in 0 Posts

    how to test the speed of SQL processing in SQL...

    Dear,

    im now have two different SQL Statements and i want to test out the speed of this two SQL Statements, what should i do? like i want is show the processing usage time? posssible?
    Thanks.
    =====================================================
    From NinjaTurtle
    ++http://ohmygoh.blogspot.com|http://technology.ohmygoh.com++

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Location
    Cincinnati, OH
    Posts
    545
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try this:
    http://www.indus-soft.com/winsql/

    Look for the "WinSQL Lite - FREE" utility.

    I use this tool all the time at work.
    If you happen to have MSSql server there is a "Query Analyzer" tool that installs with MS SQL Server.

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Posts
    358
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Yes, i do have Query Analyzer but how to check the time usage?
    is that the Statistic tab?
    Last edited by NinjaTurtle; 02-06-2003 at 03:11 AM.
    Thanks.
    =====================================================
    From NinjaTurtle
    ++http://ohmygoh.blogspot.com|http://technology.ohmygoh.com++

  • #4
    Senior Coder Morgoth's Avatar
    Join Date
    Jun 2002
    Location
    Ontario, Canada Remaining Brain Cells: 6
    Posts
    1,402
    Thanks
    2
    Thanked 1 Time in 1 Post
    You mean like how long it takes the page to load while doing sql stuff???

    http://www.askasp.com/articles.asp?ArtID=85


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •