GilaMonster (9/30/2008)

---

Ouch. Your IO performance looks terrible. Average of 44 sec for an async IO completion with a max of 22 minutes is way, way too high.

I can't download the...

I have another one from this morning

Yes it was - but we did not hit the point where the speed was terrible low. Perhaps because of server agent restart earlier this morning.

GilaMonster

select top 20 *, cast(wait_time_ms as float)/waiting_tasks_count as Avg_WaitTime

from sys.dm_os_wait_stats

where waiting_tasks_count>0 and wait_type not like 'Sleep%'

order by wait_time_ms desc

This is my output:

Hello again,

I have uploaded some performance data to a ftp:

@REM To register the collector as a service, open a command prompt, change to this

@REM directory, and run:...

Hi Steve Jones,

Yes we did try reboot without any luck.

I tried to analyse where the time went using Nexus - but is seems everything looks good. Ill upload a few...

Hi Jeff Moden

Well havent thought about that - I will give it a try next time.

Regarding the memory - the limit is 29G at this moment. The MSSQL never uses...