SQL Server also has separate logs for the SQL Server Agent, as well as other components of the data platform, such as SQL Server Analysis Services. In each case, SQL Server keeps seven rolling log ...

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.

How can understanding wait statistics improve query performance in SQL Server? Understanding wait statistics allows the data professional to tune individual queries or, if necessary, to tune ...

So we have (for example) 1,000 clients.We collect lots of data from these clients and in turn provide detailed reports and key performance indicators for how they are doing compared to themselves ...

Effective server monitoring can prevent downtime, improve performance, and help troubleshoot issues before they escalate. One of the most powerful tools for this purpose is Prometheus, an open source ...

If you're looking for a real-time server monitoring tool, Netdata gives you plenty of information with a simple installation.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...