Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive cold fronts this winter! Learn 12 tips to prepare for winter and the storm of the century tonight at 11!”
“Oh my gosh!” you think, “I’d better pay attention and record that for future reference”
Yeah. You are probably like me and just get back to trying to find something not over propagandized to watch. Is there anything like that on TV anymore?
Reality is, winter is coming, at least for those of us in the northern hemisphere. That doesn’t seem to mean much to us when dealing with SQL Server databases, right?
Well, actually, it does.
For a lot of companies, the end of year is an exceptionally heavy workload month. There is a culmination of month end, quarter end and year end analysis and reports to be done. If the company happens to be part of the retail industry, there are sales and promotions that start to push websites, applications, and databases to an extreme they usually don’t experience any other time of the year. If a company’s fiscal year matches is based on the calendar year, there is a lot of other reporting and analysis to be done for that. It all adds up very quickly.
Let’s go back to the initial opening statement I had, about the news coverage of the upcoming winter. There will most likely be some story about how to prepare your car, your home, or even yourself to make it through the rough winter ahead.
My question is what are you doing to make sure your database is ready for the onslaught of winter.
Here are 12 things to check to make sure your system is prepared for this winter. There are lots of other things that can be checked as well. I invite you to share in the comments anything else you do to prepare SQL Server for this winter’s onslaught of transactions and analysis.
The post 12 Things To Check With SQL Server To Prepare For Winter appeared first on .
