April 18, 2011 2:00 PM
Posted by: Denny Cherry
EMC,
SQL Server,
StorageEven when using a storage array it is typically best practice to have the data on one LUN, logs on another LUN, and tempdb on another LUN. Especially if you have the option to putting each LUN on different physical disks. If you I talked a little more about this a
April 4, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
Storage,
TempDBIt really depends on the amount of load that you put on the tempdb database. Everything which is done within the tempdb database is going to be logged in the transaction log just like any other database so if the tempdb database has a very high IO then it may make sense to put the tempdb log on a...
March 25, 2011 2:00 PM
Posted by: Denny Cherry
Backup & recovery,
compression,
SQL Server,
SQL University,
StorageIf you have a modern tape backup solution you probably have some sort of dedup process in your backup environment. What these deduplication processes do normally is look at the data which is being written to the backup platform and remove duplicate values in order to save space on the tape backup...
March 24, 2011 2:00 PM
Posted by: Denny Cherry
Replication,
SQL Server,
StorageSo here's an answer to the great myth of SAN, it isn't always going to be faster than local disk (or DAS, JBOD, etc.). The reason for this is actually pretty straight forward.
Local disk is cheap. That's the reason in a nut shell. Let me see if I can't explain in a little more...
March 23, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL University,
StorageIn the server world we have three different kinds of storage available. Today, only two of these can be used with your SQL Server (as long as you want to keep the SQL Server in a supportable configuration). Your three options are Direct Attached Storage (DAS), Network Attached Storage (NAS) and...
March 22, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL University,
StorageIn a perfect work, you would use RAID 10 for everything. However we don't work in the perfect world, we have budgets to deal with. And these budgets mean that we have to make sacrifices at times so we don't get what we want.
RAID 10 is very expensive to implement, much more so per gig than...
March 21, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL University,
StorageWelcome to the first day of storage week of SQL University. Over the next week, we'll be covering some different topics, at different levels, but hopefully the information is useful to everyone.
One of the big reasons that companies pay for storage arrays is that when it comes to expanding...
March 3, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
StorageIn this sort of configuration, which is pretty normal actually, I would but the SQL Server binaries on the C drive.
Denny
February 21, 2011 2:00 PM
Posted by: Denny Cherry
Replication,
SQL Server,
SQL Server 2008So a while back we were seeing some very strange behavior with our SQL Replication. Every once and a while for no apparent reason the log reader would just slow down the pulling of records from a single publisher database. Our replication was setup with a single publisher, and a single...
