Category Archives: Hardware Bottelneck
Dedicated to Grant Fritchey, a Leader of SQL Server community.
TSQ Tips & Tricks
- SQL Server: TSQL Script to Get Hard Drives Detail
- SQL Server: Querying Case Insensitive Data with Case Sensitive Filters
- SQL Server: Cascade Delete
- SQL Server: The Magical OVER clause
- SQL Server: How to Get Strings Which Contains Special Characters
- SQL Server: How to Load Files From Given Directory To a Table
- SQL Server: Small Tables’ Clustered Indexes Fragmentation
- SQL Server: How to Analyze Blocking and Deadlocking
SQL Server Basic Concepts
- SQL Server: Understanding Output of SET STATISTICS TIME ON
- SQL Server: Execution Plan Major Points in Query Optimization
- SQL Server: Difference between Locking, Blocking and Dead Locking
- SQL Server: What is an Algebrizer ?
SQL Server Community
- SQL Server: Great Opportunity to Learn Indexes
- SQL Server: A Brief Introduction to SQL Server Denali
- SQL Quiz: Solve Simple TSQL Quiz and Win an Apple iPad
SQL Server Hardware Health
- SQL Server: How to Find Costliest Nodes in Graphical Execution Plan
- SQL Server: Multiple Objects Script but Save Each to Separate Files
SQL Server Management
Few days back, a friend asked that “Is there any quick way to check database server hard drive health?”
Well, there are few performance counters which can help you to determine health of your database server hard drive. Among these counters two counter are really important. These are Avg Disk Sec/Read and Avg Disk Sec/Write.
These counters shows amount of time (in milliseconds) it takes to read from disk or write to disk. Standard value for both counters is 10 milliseconds and if your hard drive is taking more time, continuously, then surely, it’s the time to change your hard drive.
Other performance counters, which can help you to determine hard drive health, are as follow:
%Disk Time (Percentage of time your had drive was busy)
<85% is considered as average value as per BOL
Current Dist Queue Length
Its value must be <2 per disk