Database Administration & Monitoring, Database management, Development & Performance, SQL Server SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW 11.06.2021 by Stéphane Haby By a customer, the SCOM’s Database OperationManagerDW growth fast and becomes very big. To see what’s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports>Standard Report> Disk Usage by Top Tables: You have(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server: How to compare Server and Database Collation 09.06.2021 by Stéphane Haby Sometimes during an SQL Server audit, I check the collation of the server and the databases but every time separately. The goal of this blog is to give you a script to have both and compare it. First step(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server: Analysis of SCOM Warning on the Health Check 08.06.2021 by Stéphane Haby Sometimes, it’s hard to find how to analyze a Warning in the SCOM Interface and correct the problem. By a customer, we install new instances in SQL Server 2019 and change the version of SCOM. All new servers have a(…)
Database Administration & Monitoring, SQL Server SQL Server Tips: Get back permissions lost for mount points! 04.06.2021 by Stéphane Haby Recently by a customer, we are facing the case to lose all mount points on a secondary node in a HA SQL Server AlwaysOn infrastructure due to a big problem on the Datacenter. We need to build from scratch(…)
Azure, Database Administration & Monitoring, SQL Server Virtual Symposium SQL Server & Azure SQL – Session: Debugging without debugger 06.05.2021 by Steven Naudet As a consultant at dbi services we can dedicate a significant part of our time to training and I took the opportunity today to attend an online conference. In this blog post, I will present this event and(…)
Database Administration & Monitoring, SQL Server SQL Server CPU limitation for Express and Standard Edition 28.04.2021 by Steven Naudet Introduction When performing an audit on an SQL Server VM the first thing the system administrator told me was that there’s no issue with the CPU on this box, the monitoring shows it’s always around 50% usage. Problem Here is(…)
Database Administration & Monitoring, SQL Server SQL Server: Get email notifications for Error Log entries 23.04.2021 by Steven Naudet Introduction In a previous blog post, I did a T-SQL script reading Audit files to send emails with valuable information about instance changes. In this one, you will see how to get nice emails from critical errors or(…)
Database Administration & Monitoring, SQL Server SQL Server: How to delete the msdb backup history kindly 22.04.2021 by Steven Naudet This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged. I already wrote a post on this topic and(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server: Replace the old SCOM login by the new one 22.04.2021 by Stéphane Haby It’s every time hard to replace a login who as role and permissions in every database like the service account for SCOM. In the previous version of Scom, you create a service account (dbiscom) to access the SQL Server(…)
Database Administration & Monitoring, SQL Server SQL Server: Audit changes on Instance Configuration, Linked Servers and Agent Jobs 12.04.2021 by Steven Naudet Introduction Very often with our customers, there is only one person with the DBA role. The configuration of the instances is then under control and if anything strange has to be questioned, the culprit is quickly identified. 🙂 When(…)