Eric1/2aB (12/20/2010)

---

Final followup to this thread in case anyone was interested....

We ended up having the problem re-occur and neither Microsoft nor I could determine the source of the issue even...

brian118 (12/20/2010)

---

Yeap, the problem is the storage! In fact it's a SAN and I did confirm with the network admin that there are issues with it's performance. The drive is...

True and false, respectively (certainly for MLC SSD's; I haven't investigated comparative benchmarks on SLC...

JottoMagic (12/17/2010)

---

I have found that the "magic number" for FF would be the amount of index space that needs to be available between index rebuilds. Our indexes grow approximately...

brian118 (12/17/2010)

---

Thanks for your feedback!

I have 8 core allocated to the SQL Instance, and although I specify MAXDOP=4 for the index rebuild operation, I'm seeing only ONE core spiking at...

Watch CPU core performance during the rebuild; on a 16 core physical box, using 2008 R2 Enterprise (i.e. parallel rebuild), and up to 500MB/s of sequential disk transfer rate (per...

Use DBCC LOGINFO to check your VLF's; if you are or were autogrowing in small increments, you may have a very large number of VLF's which will decrease performance.

Kimberly Tripp...

Why focus on Hyper-V alone; VMWare also is used in all sizes of enterprise.

I strongly suggest doing some tests with the following cases:

A) More than 10,000 pages of data!

B) A couple indexes, to watch behavior differences when SELECT, INSERT, UPDATE, and DELETE happens

...

Jeff Moden (12/15/2010)

---

nigel. (12/15/2010)

---

Nice little eye opener Jeff, thanks.

I particularly like :

Can I quote that the next time I see...

May I suggest that if...

2008 (R2) Intellisense has more time savers than time wasters (overall it saves time), but A) it requires a change in how you write things, and B) it completely screws...

Every server I've set up to use SQL Server backups to a UNC location on the network has been using a Domain User account to start all SQL services; this...

Rebuilding small indexes during business hours in systems that aren't highly time-critical isn't a problem; if the table's locked for 2 seconds, does anyone care? If they do... don't...

I love ANSI C coding too; but SQL is a dramatically different language, with its own benefits and disadvantages. C is close enough to assembly to be good at...