To follow up on Grant and Eric's comments.

Splitting to spread out IO load and splitting to allow partial database restores require completely different decisions about what tables/indexes go onto different...

Nested loop joins may fetch the same row many times from the outer table, and if there are functions there they might get evaluated before the join. Also you may...

Are you planning to put all the files on the same set of drives?

Ed Wagner (12/14/2015)

---

Someone needs to alert the silver spoon manufacturer to start running overtime immediately. I have a feeling we're a couple of cases short in stock and we're...

and I've used

SQL Monitor, Foglight and Spotlight. All good,...

As Anthony said

What's best for my requirements may not be best for yours,...

This is a Microsoft SQL Server forum, not MySQL. You'll probably get better MySQL help at http://forums.mysql.com/

Ok, the log reader is failing. Why? What steps have you taken to debug the log reader?

Never heard of conditional. The states that a process may be in are running, runnable, suspended, background (for system processes) and sleeping.

https://msdn.microsoft.com/en-us/library/ms177648.aspx

Running means just that, the process is on the...

Custom ETL won't satisfy any of those requirements (except maybe 4). To even start, you'd probably need to write IO filter drivers, or maybe a transaction log reader, implement something...

https://technet.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspx

http://dba.stackexchange.com/questions/28801/sql-server-ntfs-allocation-unit-size

Bear in mind that changing the size means repartitioning the drives, so that's a re-partition, re-format and reinstall. Downtime could be nasty.

And you've, of course, looked at the errors it logs, googled them if you don't understand immediately and hence know...

I just told you! And the error message that you posted told you as well!

You've either got transactional replication with a log reader job that's not running or change data...

Continues here: http://www.sqlservercentral.com/Forums/Topic1744862-2799-1.aspx

Yes. Remove the UDFs. They're a notorious performance problem, especially when they're data-accessing UDFs that run in a clause of a query, because they will run multiple times and, as...