Hi All,
Every Saturday my SQL Server Database size automatically grow to 6 GB and next day Database size reduce automatically .
I used default tracer to find the which process cause this increment but didnt get any clue, the result of the query didnt give anything.
then i configured extended events database_file_size_change but interesting thing is when i manually grow the initial size of database it give the result but it didnt work automatically and didn't trace any activity running on the database not only on Saturday but other day same.
I want to know which process causing this database size increase , could anyone help me about this issue.
My Default Tracer SQL query.
DECLARE @id INT
SELECT EventClass,*
FROM [fn_trace_gettable]('D:\MSSQL13.MSSQLSERVER\MSSQL\Log\log.trc', DEFAULT)
WHERE EventClass IN (92,93)
ORDER BY StartTime;
please refer the attached file.
Regards
Syed
