Just finished a script that will show the top 10 OS wait states. This is helpful in determining the issue with SQL server.
For more information, check out Brent Ozar's site http://www.brentozar.com/sql/wait-stats/ where he give more information on this topic.
I hope you find it helpful.
Download script here: https://docs.google.com/file/d/0B07PMQYOhF2DNnBkZmlUeTNFSTA/edit?usp=sharing
About Me - Who is DR DBA?
- Who am I?
- Hello. My name is Rudy Panigas and I am a Production Senior Microsoft SQL Server Database Administrator (DBA) with over 14 years of experience. Have published articles with SQL Central, am a leader for the my local PASS chapter in Toronto (TORPASS) and love to automate anything SQL including disaster recovery. I created this blog to share my views, knowledge and to discuss Microsoft SQL server in order to help out others in this field. Please test these scripts before using. I do not warranty and do not take any responsibility for it, its misuse or output it creates. You can reach me at this email address: firstname.lastname@example.org