Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find expensive Queries in sql server 2000 Expand / Collapse
Author
Message
Posted Tuesday, August 14, 2012 10:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:28 AM
Points: 382, Visits: 151
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.
Post #1344841
Posted Monday, August 20, 2012 10:55 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:01 PM
Points: 1,304, Visits: 466
MSSQL does not have built-in diagnostics.
but you can create your own based on sp_trace_create and etc. or use Profiler


Post #1347567
Posted Tuesday, August 21, 2012 1:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:28 AM
Points: 382, Visits: 151
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.
Post #1347597
Posted Tuesday, August 21, 2012 8:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:01 PM
Points: 1,304, Visits: 466
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

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

3. other too "DB Audit Expert™3.1"l
Post #1347808
Posted Tuesday, August 21, 2012 8:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:28 AM
Points: 5,237, Visits: 9,489
Don't use Profiler. Set up a server-side trace. It uses less resource than Profiler.

John
Post #1347813
Posted Tuesday, August 21, 2012 8:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:28 AM
Points: 382, Visits: 151
Thanx for updates.
Post #1347816
Posted Tuesday, August 21, 2012 8:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:28 AM
Points: 382, Visits: 151
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.
Post #1347824
Posted Tuesday, February 18, 2014 5:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 3:54 AM
Points: 19, Visits: 166
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
Post #1542510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse