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