Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2008-02-05 : 14:47:15
|
| Guys,I started getting the following errors recently. They happen every day, at the same time, and last 5-10 minutes. During the time of this problem, we have a Purging Job Running, and no other job is running. And the purging job starts about 25 minutes prior to that and ends about 20 minutes after that. The errors are:Insufficient memory availableError: 17803, Severity: 20, State: 4Query Memory Manager: Grants = 2 Waiting = 0 Maximum = 136099 Available 112441Dynamic Memory Manager: Stolen=11173 OS Rserved = 13832Procedure Cache: TotalProcs = 1697 TotalPages = 2719...In addition to the purging job, there are some stored procedures or possibly something else running against the database, and causing this problem.As far as I understand, this has something to do with memory.I decided to create a Profiler(Server) Trace to monitor what is going on during those times. Could someone suggest which are the best counters to capture in order to find out what the problem is?Thanks a lot! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-05 : 22:46:49
|
| Can you tell us more about your server? How much memory does it have? How much used by sql? What's total db size? How many rows to purge? Did you delete rows in smaller batch? |
 |
|
|
|
|
|
Insufficient memory available problem!