Mongo Won’t Restart
MongoDB does not start after a reboot, sudo tail -10 /var/log/mongodb/mongod.log indicates 1Failed to unlink socket file /tmp/mongodb-27017.sock Operation not permitted To resolve the issue, run commands 123sudo rm -f …
SQL Server High CPU
Troubleshoot high CPU from specific queries https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-high-cpu-usage-issues Identify Queries Contributing to High CPU 12345678910111213141516171819202122232425SELECT TOP 10 s.session_id, r.status, r.cpu_time, …
Mongo DB Troubleshooting
Useful commands to troubleshoot why Mongo DB is in an error state Mongo Change Log https://www.mongodb.com/docs/manual/release-notes/5.0/ Check for disk space 1df -h Check the version 1mongod -version Check the status …
Database Repair MSSQL
Command: 1DBCC CHECKDB Returned: 123456789101112DBCC results for ‘AP_TypeLocations’. There are 3004 rows in 14 pages for object "AP_TypeLocations". Msg 8976, Level 16, State 1, Line 1 Table error: Object ID …
TSQL List all Columns in a Database
1234567891011121314151617Declare @Table_Name VarChar(100) ,@Column_Name VarChar(100) Set @Table_Name = ” Set @Column_Name = ” Select RowNumber = Row_Number() Over( PARTITION BY T.[Name] Order By T.[Name],C.column_id ), SCHEMA_NAME( T.schema_id ) As SchemaName …
Monitor CPU usage MS SQL Server
Ensure the user has permission 123USE master; GRANT VIEW SERVER STATE TO username; GO Select from view sys.dm_os_sys_info 1select * from sys.dm_os_sys_info