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

tool to prove bottle necks

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
NAMEWITHELD12
Asked:
NAMEWITHELD12
  • 2
2 Solutions
 
EvilPostItCommented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
EvilPostItCommented:
That too, although if your newer to SQL Nexus can be confusing.
0

Featured Post

Cyber Threats to Small Businesses (Part 2)

The evolving cybersecurity landscape presents SMBs with a host of new threats to their clients, their data, and their bottom line. In part 2 of this blog series, learn three quick processes Webroot’s CISO, Gary Hayslip, recommends to help small businesses beat modern threats.

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