• Search for:

    1. Home
    19 Jun, 2021
    How to check when procedure was last executed in SQL Server 0 (0)
    MSSQL , ,

    select
    db_name() [database name]
    ,[schema name] = SCHEMA_NAME([schema_id])
    ,o.name
    ,create_date [create date]
    ,modify_date [last modify date]
    ,ps.last_execution_time
    from sys.dm_exec_procedure_stats ps
    inner join
    sys.objects o
    ON ps.object_id = o.object_id
    where o.type = 'P'
    –and o.schema_id = schema_name(schema_id)
    and o.name = 'MonTlogUsage'    … Read the rest

    13 Jun, 2021
    How to monitor SQL server transaction log usage 0 (0)
    MSSQL , , , ,

    Problem Description:

    Many a times there are requirements to monitor SQL server log usage historically and analyze when it is needed. Below are the step by step solutions.

    Solution:

    Step1: create database

    create database MonitorDB
    go

    Step 2:- … Read the rest