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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Sharepoint 2010 and how to Baseline using sqlio an

Author  Topic  jspatz Starting Member 15 Posts Posted - 2010-05-06 : 16:37:17 Good afternoon! OK, We are rolling out sharepoint 2010 on sql server 2008 in the next couple of months and the microsoft tech we have on site is asking for a baseline from either sqlio or sqliosim for our environment. I am trying to figure out how to do this and present the data properly, I have searched the net, and ran through Brent Ozars docs, kevin klines blogs .. but they don't seem to match my environment and I am anything but overly knowledgable as far as measuring and reporting on IO. We have a san and we are connecting to it through duel fiber cards. We are on a dual node cluster and our storage guys have given me storage on an"F" drive and then individual partitions under it like this F:\TempD1 (5gig) F:\TempD2 (5gig) F:\TempL1 (5Gig for log file) F:\SearchD1 (40gig) ... .. and so on we are giving each content database a data folder and a log folder each on their own drive. We are giving the Temp Databases 4 separate folders (one per cpu thread) and 1 for the log, the search database 4 for data and one for logs, so all said and done I have 20 or so separate drives just for sharepoint. Now when doing SQLIO should I be testing one drive at a time.. or should I just make one giant parameter file large files on each drive... Also if this setup is totally ridiculous and overkill I won't mind hearing that as well, This is our first delve into the sharepoint world and are always interested in others successful (and unsuccessful) implementations as well as best practices that we may have not seen.