SQL Server Database Administration
- Reduce FTE Expenses
- Improve Server Performance and Reliability
I can do just about any task a DBA can be expected to do and I'm prepared to talk about those things. But my website's first page is primarily devoted to server performance and reliability because without those two characteristics, it's difficult for a server to provide any viable services.
Every company I have ever worked for had database server performance issues - no exceptions. They negatively affected the company's work environment and customer relations.
A company's databases and the data stored within them are the foundation for a company's business. Companies want their database servers to respond quickly and perform normally at all times, with predictability and reliability.
Database Server Performance Deterioration
Question: Why is it that database servers can appear to run perfectly for months, even years, and then, performance will start to deteriorate, sometimes slowly, sometimes quickly?
Answer: Because the internal dynamics of an operating database server are forever changing with changes to the data they host, the queries that access them, and the varying loads placed on the server. These conditions make predictable, normalized server performance an elusive, moving target. However, with proper tuning and automation, the variability of server operating characteristics can be smoothed out to provide a normalized, predictable level of performance.
What kind of DBA do you need?
So, what should a company do to solve its immediate database server problems and maintain a reliable, predictable level of database service in the future?
- Hire an expensive, senior DBA as a full-time employee with benefits; work him hard for 6 months or a year, until all the “fires” are out and he’s automated just about everything. Then, lay him off because he’s not busy enough and is operating in mostly maintenance mode.
- Hire a senior DBA as a consultant to analyze the database server and application environments, and have him/her:
- Make specific recommendations to management on the nature of the problems found and how they should be solved.
- Put out the “fires” starting with those that have the most significant impact on company operations.
- Develop and deploy automated maintenance jobs to keep the databases and the server fine-tuned for optimum performance.
- Proactively monitor the database server’s performance to intercept small problems before they become big problems.
- Implement best practices and automate them wherever possible. Best practices includes catastrophic failure and data recovery plans, and specific implementations to support them.
- Know their systems are properly configured, alarmed, and monitored.
- Utilize my knowledge and experience for a fraction of the cost of a full-time employee.
- Obtain more efficiency from their existing database and infrastructure investments, without having to resort to additional recurring or capital expenditures to improve server performance.
- Know the immediate status of their systems' operational environments because of regular, proactive server monitoring and reporting.
- Experience significant system performance improvements, with significant reductions in critical incidents and downtime.
If you need help with performance tuning your SQL Server, contact me to schedule a free consultation.