The HP will be setup using HP's recommendation of one large pool of drives. At an OS level we will partition the drives for tempdb, data and logs, but...

We are actually in the process of evaluating two SANs, one from EMC and one from HP. The EMC SAN utilizes metaluns, with one set of drives dedicated to...

We're running our tests for 120 seconds per test as follows.

Random Write - 1 thread 1 outstanding IO 8KB -BH -LS

Random Write...

Thanks. I'll do that. Does this mean there is no specific block size for reads vs. writes? It can be anywhere from 8, 16, 32, 64, 128,...

Regarding page counts, we haven't checked to see what benefits, if any, we are getting from defragmenting an index with a low number of pages such as 100. That...

Yes. One 250GB clustered index. It's a financial system used in the trading industry so we have no control over the design.

SORT_IN_TEMPDB is used, but that...

Unfortunately that's too risky for this system.

Thanks

We reviewed the Microsoft article regarding the registry setting and believe our symptoms are a little different than those stated in the doc. We've checked the network load on...

We had the problem occur again last week for the first time in a few months. In our case we believe the issue is related to a disk bottleneck,...

We, including Microsoft, suspected our problem was related to disk IO issues. It may be worth running perfmon to check your disks if you haven't already done so. ...

Microsoft didn't have much information on ACCESS_METHODS_BULK_ALLOC. They said it is a class used to perform bulk extent allocations.

With regards to EXECSYNC, they said it is another waittype related...

We encountered the same problem in April. I got lucky and found one discussion regarding the issue, which pointed me to the KB article.

http://relatedterms.com/ViewThread.aspx?t=1464269

We also...

Hi Steve,

I just found a quote from Kalen regarding open transactions.

The need for examining the open_tran value is greatest when looking at those sessions that aren't doing anything, but are...

We just encountered the same problem yesterday during reindexing on a SQL 2005 SP2 EE 64bit cluster running on Windows Server 2003 EE SP2. We have three reindexing jobs...

Our preference has been to store packages in MSDB, but we don't have a great deal of experience with SSIS so we aren't sure of all the pros and cons....