Some Notes, Some Scripts

These are the noted taken for searching solutions and some scripts to identify the problem

Categories:

You realized that your database has grown and you want to check who perform data load or run heavy queries: DECLARE @current_tracefilename VARCHAR(500);DECLARE @0_tracefilename VARCHAR(500);DECLARE @indx INT;SELECT @current_tracefilename = pathFROM sys.tracesWHERE is_default = 1;SET @current_tracefilename = REVERSE(@current_tracefilename);SELECT @indx […]