My SQL 2008 Server has suddenly started running out of memory at random times during the day.
The windows application event viewer indicates this via an MSQLSERVER error where I get errors that indicate lack of memory is preventing connections to SQL Server. This clears itself after about an hour and then connections are accepted again.
I can't see anything in the windows event logs that indicates something external to SQL Server itself it causing the problem so I am going to run an SQL Server Profiler all day so when the problem next occurs I have something to look at to see if I can spot the event that triggers the event.
I don't want to create a huge Profiler log file so I would like the log to limit itself in size and overwrite itself when it gets
large. Is there a way to do this? The profiler only seems to allow new files to be created each time a size limit is reached so I can't limit the overall disc space the profiler eats up.
The only alternative is for me to manually deleted old trace files every hour or so.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.
The windows application event viewer indicates this via an MSQLSERVER error where I get errors that indicate lack of memory is preventing connections to SQL Server. This clears itself after about an hour and then connections are accepted again.
I can't see anything in the windows event logs that indicates something external to SQL Server itself it causing the problem so I am going to run an SQL Server Profiler all day so when the problem next occurs I have something to look at to see if I can spot the event that triggers the event.
I don't want to create a huge Profiler log file so I would like the log to limit itself in size and overwrite itself when it gets
large. Is there a way to do this? The profiler only seems to allow new files to be created each time a size limit is reached so I can't limit the overall disc space the profiler eats up.
The only alternative is for me to manually deleted old trace files every hour or so.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.