Operations | Monitoring | ITSM | DevOps | Cloud

Although writing better queries and building the right indexes are important parts of improving database performance, building clear database documentation can also contribute to this goal by helping you understand your database architecture. Painting a clear picture of the structure of your database gives you insight into your data flows and helps you identify redundant data and clarify business processes.

There are plenty of ways to gain insights on website availability and performance, from setting up complex monitoring agents to browsing through real-time logs. Few services are as straightforward and robust as SolarWinds® Pingdom®. Pingdom lets you set up checks for your website including uptime, page speed, and user interactions. It then collates the results in a dashboard for you to visualize.

Given the overwhelming importance of data to organizations, anything they can do to speed up troubleshooting problems in the databases they use is of great value. If a company can speed up or avoid troubleshooting, it frees up time they can invest in doing and building more with their data. Careful attention to database query construction and execution also pays similar dividends, as improved database performance helps organizations get more done faster.

In this enterprise cost containment series, we’ve tackled a range of topics from cloud to professional services and more. Now, I want to dive into the topic you may have expected us to cover from the start: monitoring. After all, at SolarWinds, we create monitoring software. The goal of this post is not to present or sell software, though. It’s our intention to help you have conversations with management and stakeholders—no matter the monitoring you use.

Welcome back to our five-part series in which we discuss a top habit for DBAs to increase business functionality. In part one of this series, we discussed the importance of a capability maturity model (CMM) and more specifically Level 1 of the information management maturity model (IMMM) and how the framework can provide a step-by-step process for DBAs to follow while also allowing businesses to gain skills along the way.

Data provides an essential basis for reports and analytics, with the databases storing the data now driving and informing most custom and line-of-business applications. Thus, anything organizations can do to speed up troubleshooting for database problems is pure gold. In fact, time saved on troubleshooting turns into time organizations can invest in being more productive and profitable.

Indexes play a critical role in SQL Server query performance. SQL Sentry Fragmentation Manager helps you make intelligent decisions about index management based on the table and index information collected. In this blog post, I’m going to discuss index fragmentation, several ways you can identify it, and why a more granular approach to index maintenance can save time and allow you to focus on other tasks during maintenance windows.

After 2020, there are only two types of businesses: those who have retained customers or grown, and those who lost customers to more nimble competitors. There are many reasons. The transition away from traditional retail, shifting customer expectations, and internal operations challenges due to increasing complexity all play their parts. However, the main reason is simple. 2020 affirmed that there’s no such thing as a non-digital business.