Script to Check log reuse wait type in sql server
- Kunal Ranpura
- Jan 12, 2020
- 1 min read
--Find log_reuse_wait_desc wait type for the database: DB_Name
select log_reuse_wait_desc from sys.databases where name='DB_Name'
top of page
bottom of page
--Find log_reuse_wait_desc wait type for the database: DB_Name
select log_reuse_wait_desc from sys.databases where name='DB_Name'
--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done,...
Comments