Solved

tool to prove bottle necks

Posted on 2013-06-30
3
206 Views
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


thanks
0
Comment
Question by:NAMEWITHELD12
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 250 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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 250 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.
0
 
LVL 16

Expert Comment

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

Featured Post

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

895 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

14 Experts available now in Live!

Get 1:1 Help Now