But a couple of years ago, I’ve learned that backups are more than just for disaster recovery. In fact, that’s how I sell the importance of backups: they’re an insurance policy. As a high availability and disaster recovery expert, I used to think that backups are merely for the “ ooopppss” moments that happen every once in a while. I bet that you also have a place where you store those database backups for archiving such as a tape, file server or even a backup server. I ended the previous blog post with a question: “ do you have database backups?” If you do (and I sure hope so,) you’re in luck. How else can I perform capacity planning for my storage requirements? Backups Are More Than Just For Disaster Recovery These monitoring tools not just check for the health of your databases but they also collect operational data such as CPU, memory and disk space utilization.īut, what if you don’t have those monitoring tools yet? Where do I get the operational data for my database disk capacity? I do have the current size of the databases but that wouldn’t be enough to do capacity planning and forecasts. That’s where tools like SQLSentry, System Center Operations Manager (OpsMgr,) Idera, SolarWinds, Quest Software (now a part of Dell,) etc. I also mentioned at the end of the blog post that the proper way to deal with database space issues is to monitor your disk space utilization and do proper capacity planning. In a previous blog post, I mentioned why regularly shrinking your databases is not the right way to reclaim space.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |