Find expensive Queries in sql server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Find expensive Queries in sql server 2000

Find expensive Queries in sql server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

jkhilosia

Posted Tuesday, August 14, 2012 10:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:33 AM
Points: 134, Visits: 44

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

handkot

Posted Monday, August 20, 2012 10:55 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:18 PM
Points: 1,015, Visits: 432

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

jkhilosia

Posted Tuesday, August 21, 2012 1:09 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:33 AM
Points: 134, Visits: 44

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

handkot

Posted Tuesday, August 21, 2012 8:05 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:18 PM
Points: 1,015, Visits: 432

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

John Mitchell-245523

Posted Tuesday, August 21, 2012 8:11 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:51 AM
Points: 4,425, Visits: 7,187

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

John

Post #1347813

jkhilosia

Posted Tuesday, August 21, 2012 8:13 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:33 AM
Points: 134, Visits: 44

Thanx for updates.

Post #1347816

jkhilosia

Posted Tuesday, August 21, 2012 8:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:33 AM
Points: 134, Visits: 44

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

« Prev Topic | Next Topic »

Permissions