Hi Everyone
Just to give an update i disabled all the stored procedures which were running and to my surprise the log file still grew to 2GB for 1 database and 1GB for another when i ran the TL backups this morning at 7am
This doesnt make any sense as we arent running any queries or jobs or anything between 5pm and 7am
I checked in the error log and i found this error:
AppDomain xxxxxxxxxxxxxxxx is marked for unload due to memory pressure.
04/29/2017 00:00:29,spid18s,Unknown,This instance of SQL Server has been using a process ID of 1612 since 4/11/2017 4:01:24 PM (local) 4/11/2017 1:01:24 PM (UTC). This is an informational message only; no user action is required.
I will check if there are any applications job which run from the application side but how can i check from the DB side if there are any applications accessing the database after 5pm?
thanks
have a good weekend
KY
Don't have time to read the entire thread, but I am just not getting why you are concerned with 2GB and 1GB log files.
As for finding what is running, start a simple profiler trace to local disk on the server, capturing just rpc batch completed and sql batch completed. Easy, peasy, very light weight.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service