Question : I’m trying to find out whether it is possible to add tempdb files to a SQL Server without […]
Tag: troubleshooting
Rows deleted in the subscriber – what to do? – SQL Server Transactional Replication
Question : Someone has delete by mistake a row of a table in the subscribed server/database. I am getting the […]
MySQL: How to clean MySQL from RHEL5?
Question : I have installed MySQL 5.1.73 community edition through RPM. It was working fine. I uninstalled this version by […]
Periodically very slow execution of simplest queries
Question : Inspecting MySQL slow query log I found out that in certain periods of time there are a bunch […]
How can I trace the root cause of a MySQL database table that crashed?
Question : Are there any standard practices or methods for tracing the cause of a MySQL table crash? If I […]
DBA – Checklist Question- TempDB Is Full
Question : I’m trying to create some checklists for troubleshooting various issues, in this case, when TempDb is full. I’d […]
How do I find out what’s causing processes to wait for table flush?
Question : I’m currently using MariaDB 10.3 and am troubleshooting this case where threads will start to build up until […]
“SSIS Evaluation Period Has Expired” on Dev Instance?
Question : I recently started receiving the following error on a dev server. At one point SQL Server 2016 CTP […]
Rows deleted in the subscriber – what to do? – SQL Server Transactional Replication
Question : Someone has delete by mistake a row of a table in the subscribed server/database. I am getting the […]
SQL Server uses too much CPU
Question : I have a VM 2012 R2 server with SQL Server 2014 Express SP2 installed. There are some applications […]