I'd also like to know how to handle the OLAP environment that is based on our OLTP database, and how to deal with...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
existing high availability clusters.
Do you have a "best practice" on these issues? Microsoft and Dell are telling me about the technical specifications, but I'm more interested in the operational part. (I'm just the DBA -- not one of the network guys.) We are using SQL Server 2000 SP3a/Windows 2000 servers.
There are many things that you could do and a few that you need to do. For example, you need to make sure that your data is copied from its source to its destination and verify the integrity of the new destination before removing the original source. You also need to make sure that your backup and recovery procedures are updated to include the destination of the migrated data and to verify that the backups are working properly. You should also randomly audit one of your backups and restore to an alternate location to verify that your backups are valid.
Not knowing your specific configuration and environment, it would be a guess as to what else should or could be done to enhance performance. However, you could start by looking for any signs of bottlenecks, including jobs that are taking longer to run than before, and device and I/O contention, using either server tools or storage management tools. You should also update your documentation and disaster recovery plan information to reflect any changes to your environment. There are many other items that perhaps can be covered in a future SearchStorage.com tip. In the meantime, if you have not done so, check-out the SearchStorage.com SAN School and other webcasts covering many of the topics you mention. Of course, I'll suggest that you read my book Resilient Storage Networks as well as those from fellow SearchStorage.com experts for best practices and tips.
Read Christopher Poelker's answer to this question.
Dig Deeper on SAN management
Related Q&A from Greg Schulz
Service provider outages should be a warning to customers that keeping data safe in the cloud is a shared responsibility.continue reading
When cloud durability is added to the mix, cloud providers are able to tout a high number of nines of availability.continue reading
Cloud storage can be less expensive from a cost-per-gigabyte perspective, but it's important not to lose sight of other benefits as a value ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.