Solved

Identify high resource job / tasks in SQL Server 2008

Posted on 2014-01-15
2
317 Views
Last Modified: 2014-01-18
How can I identify a long running sql, procedure or jobs in SQL 2008 server ?

Tks
0
Comment
Question by:AXISHK
2 Comments
 
LVL 13

Assisted Solution

by:magarity
magarity earned 200 total points
ID: 39784469
Just use the Profiler tool that comes with sql server. Look for queries that have an excessive number of reads. The profiler will also let you browse the execution plans of running queries so you can look for table scans,  etc.
0
 
LVL 35

Accepted Solution

by:
David Todd earned 300 total points
ID: 39787639
Hi,

In SQL 2005 Microsoft introduced DMVs and in-built reports.

I suggest first off, that in SSMS, in Object Explorer, right click on the server, and click on reports, and look for Standard Reports, Performance - Top Queries by Total CPU.

Not strictly what you are after, but may help.

Also look at sp_who2. Connections with a high value in CPU or Disk might have issues and fit your criteria of long running.

HTH
  David
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now