Post reply

Find expensive Queries in sql server 2000

  • August 14, 2012 at 10:08 am

    #98729

    Hi,

    I am working as jr dba.

    i want to find out the expensive queries with execution time in sql server 2000.

    i have read many blogs but not able to fine proper answer.

    if any one cay help me for this issue.

  • August 20, 2012 at 10:55 pm

    #1527934

    MSSQL does not have built-in diagnostics.

    but you can create your own based on sp_trace_create and etc. or use Profiler

    I Have Nine Lives You Have One Only
    THINK!

  • August 21, 2012 at 1:09 am

    #1527956

    Thanx,For update.

    My question is,

    Use of Profile put extra load on sql server.

    Because we are using sql server 2000 and our server frequently down. we are using Java application.

    so there is any other way. that you can suggest.

  • August 21, 2012 at 8:05 am

    #1528138

    I think no

    1. if you reduce the number of events to a minimum, the load will be minimal

    read this article Finding the Causes of Poor Performance in SQL Server, Part 1[/url]

    2. check may be you have enabled "default Trace"

    3. other too "DB Audit Expert™3.1"l

    I Have Nine Lives You Have One Only
    THINK!

  • August 21, 2012 at 8:11 am

    #1528141

    Don't use Profiler. Set up a server-side trace. It uses less resource than Profiler.

    John

  • August 21, 2012 at 8:13 am

    #1528143

    Thanx for updates.

  • August 21, 2012 at 8:42 am

    #1528150

    Thanx for your valuable response.

    I presume my DB do not have proper index and other stats,

    When I am using DMV/DMF in SQL Server 2005 I am able to get list of missing index and review Execution plan but in SQL Server 2k I am not able execute Index management stuffs,

    especially non cluster index and covering index, apart from this I can use scripts to find heap table and deadlock occurrences(incidents)

    Moreover Please suggest me to configure blocked process thresh hold

    Jitesh.

  • February 18, 2014 at 5:54 am

    #1689852

    Blacked process Th Hold is used to identify blocked query and process/alert or trigger any WMI event,

    moreover you can use it for broker services

    When you configure BPTHold SQL will automatically notify event.

    For that you can use SP_Configure for configuring BPT. Values would be seconds

Viewing 8 posts - 1 through 7 (of 7 total)

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