it is named, I am a little wary of building an AG and then bringing it in to a domain. DId this at old job with a 2008 cluster...

made some SAN settings change looks better today. DO have a question I was going to post anyhow. I have generally set my windows (on win 2008 enterprise)...

the spikes I see are from my Idera and verified with perfmon. Had a consultant help sysadmins setup SAN, looks like we may have hired wrong guy. Been...

trying to stay PC with rest of IT, but EMC did take a peek and saw numbers they could not believe. Disk queue spikes over 10000 MS (MS says...

more like sloppy development work have also found cases where they had duplicate unique indexes on same field in same table. Caught this thanks to Ozar's blitzindex.

Yes that is helpful but have to place nice in the sandbox, they will be done this weekend

that is kind of the issue, dependent on SAN people so don't want to make mad, however, would like to see after Exchange migration is done

yeah idera does show wait stats spiking, of course also doing a exchange migration, just trying to see if relationship between blocking and drive issue

No physical, not really anything from the SAN but after 15 years of dealing with them realizing like behind the curtain in the wizard of oz world

data, index, log and tempdb all on separate disks on new EMC SAN

http://www.brentozar.com

he has a whole group of great tools

i would look at ozar's index routine and use that. I would also advise not to become a trigger happy DBA with some of this stuff. Depending on...

it's about 50-50, interesting that when working with Sharepoint Consultants the push is for physical not virtual.

i would be looking at sp_blitzcache or Pinal Dave's query which shows what is chewing up your cache. Look at the statements it is returning and check their query...

berrys's stuff is great look at ozar's script for indexes