The service will not start after we rolled the cluster let me go check and see what the guys are telling me ....and to check the policies.

Did you get anywhere with this ..........we have same issue but not just one deadlock probrably 100 of them...at a time.

This is what i have for measuring Disk.

Using PHYSCIAL disk counters I assume this is correct and not LOGICAL DISK counter.

Avg Disk Queue length

-->How long have to wait and...

Your not on a cluster by anychance and the cluster has rolled to your standby...i had the same issue tried to edit a job and couldn't it was because the...

Thanks just found out more too.

Raid 0 -- I/Os per disk = (reads + writes) / number of disks

Raid 1 -- I/Os per disk = [reads + (2 * writes)]...

Which permon counter measures the volume of IO Per second that is being executed

Physical Disk

Disk Write Bytes/Sec

...

I will try that thanks.

Well i hope if they have a SAN i can ask the network team for the results 🙂 everyone has documentation 😉

Thanks for link, yes i used the sqlio before.

i add that to my checks to start running in a "slow period" for benchmarks.

Also set up permon on disk/cpu etc and...

I also run predeployment tests with SQLIO, and later tests for comparison are always a good idea.

In past i used the the sqlio.exe on all the disks on...

Thanks everyone.

I will work on that script. Thanks for the advice on profiler that made my day.

Activity Monitor - Don't suppose you know if there a way just for this...

Is there a command i can run to see the permissions he has.

When you go back into studio and look at secruables it blank so you can't see if unless...

Grant trace to user

How to do this in GUI i just need to see the little tick too

Oh it in the securables....for the login.

Cheers that great.

They did ask to...

Enterprise version is what we have and this is for development.

Too bad on the profiler....