tool to prove bottle necks

Posted on 2013-06-30
Medium Priority
Last Modified: 2013-07-16
I am looking for freeware that will tell me where a bottle neck exists in read and right times for disk, i/o ect

Question by:NAMEWITHELD12
  • 2
LVL 16

Accepted Solution

EvilPostIt earned 1000 total points
ID: 39289237
Perf mon is a good place to start. With regard to whether the disk is running quick enough I generally look at the physical disk queue length. Anything that is consistently high (ie I normally look for constant values in the double figures area.)

Although the best source to find out a bottleneck is contents of sys.dm_os_wait_stats. This will show you what resources SQL Server has had to wait for since its last SQL Server restart.

Not many good free ware tools i'm afraid although there are free trials of Ideras SQL Diagnostic Manager, Quest Foglight for SQL Server etc.
LVL 61

Assisted Solution

by:Kevin Cross
Kevin Cross earned 1000 total points
ID: 39289916
You can try http://sqlnexus.codeplex.com/, which offers a free tool to analyze perfmon and other data collected in tools, such as SQLDiag, or trace files. Read through the documentation carefully as SQL Nexus has many good things to offer.
LVL 16

Expert Comment

ID: 39289924
That too, although if your newer to SQL Nexus can be confusing.

Featured Post

Turn Raw Data into a Real Career

There’s a growing demand for qualified analysts who can make sense of Big Data. With an MS in Data Analytics, you can become the data mining, management, mapping, and munging expert that today’s leading corporations desperately need.

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

In this article I will be showing you how to subnet the easiest way possible for IPv4 (Internet Protocol version 4). This article does not cover IPv6. Keep in mind that subnetting requires lots of practice and time.
Disk errors can be the source of sundry problems for the Exchange server, the most common one being that the database fails to mount.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

627 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