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 |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2012-09-06 : 00:00:04
|
| my SQL Server wait is high. What's the meaning of this? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-06 : 00:44:11
|
| What do you mean by this? What are the wait types? Waiting is normal, there are typically hundreds of processes running in SQL server, they can't all be on a scheduler(Processor) at once. If they are waiting for IO, Memory, Locks etc... they go into the waiting list until they have the resources they need, then they go into the runnable list until they get processor time. If a certain wait type seems high, then you would need to troubleshoot that.-Chad |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-06 : 01:51:58
|
| Could you post the details of the wait type?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
my SQL Server wait is high