Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lijo Cheeran Joseph
Posting Yak Master
123 Posts |
 Posted - 2011-04-06 : 06:30:54
|
| Hi Team,SQL Server 2005We have a requirement to restrict Average Wait Time (ms) to 500. When we are testing with 87 users, Average Wait Time (ms)is 415; whereas with 175 users it is 587. How do I ensure whether it is a hardware bottleneck or query issue? (Looking for DMV and their benchmark values to prove this)If it is a query issue, how do I list such queries? Also, can you provide a DMV for finding the following?Avg. Response Time on a particular database Avg. Wait Time on a particular database Avg. Service Time on a particular databaseFurther info:Lock Waits/sec (at 87 users) = 1.76Lock Waits/sec (at 175 users) = 9.2ThanksLijo Cheeran Joseph |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-04-06 : 07:22:36
|
| There is really no straight answer for this.You need to have the profiler and performance monitor set up in sync to find the queries and objects which are causing wait types.PBUH |
 |
|
|
|
|
|
Performance Issue: Average Wait Time (ms)