• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

High QUEUE Length on Server

I have an SQL Server 2000 running on Windows Server 2003 R2 Standard SP2 and I've been getting complaints that our point of sale is crawling on a daily basis.  I pretty much concluded that it's due to our high Avg. Disks Queue Length. Whenever we have slowness complaints I do see the our Avg. Disks Queue Length is through the roof. Any idea how I can see who's making request to the SQL server causing the Avg. Disks Queue Length to spike OR any recommendations on how to better analyze the situation so I can see where I need more resources? Are there better tools I should be using other than the Performance Monitor?
0
vrosas_03
Asked:
vrosas_03
  • 2
  • 2
1 Solution
 
vrosas_03Author Commented:
Avg. Disks Queue Length
0
 
AnujSQL Server DBACommented:
Run both SQL Server Profiler trace and Performance monitor for while with an interval of 1 sec. These will capture both sql server queries and the data from Performance monitor. Once you done this, import both performance monitor log and sql trace to profiler. This gives you an overall view from both profiler and Perfmonitor. You can check which queries causes the avg.queue length spikes to go up.

Once you got the queries, tune them and recheck.
0
 
vrosas_03Author Commented:
Thanks, I'll try that out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now