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 |
|
raxbat
Yak Posting Veteran
52 Posts |
 Posted - 2007-11-01 : 09:11:33
|
| Hello all!I have the following problem:I have got an application. During run, I see in task manager that the sql server memory size is growing rapidly! Every 5 seconds about 4-8Kb.There are no problem with programm code. I suppose that it is a trigger error:CREATE Trigger ClearingFarm_UpdateOn dbo.ClearingFarmFor Update AsIF UPDATE(ask) OR UPDATE(bid) OR UPDATE([date]) UPDATE t1 SET t1.LastChange = CURRENT_TIMESTAMP FROM ClearingFarm AS t1 INNER JOIN inserted AS i ON i.id = t1.id INNER JOIN deleted AS d ON d.id = t1.id WHERE i.ask <> d.ask OR i.bid <> d.bid OR i.[date] <> d.[date]Can it be true?Can You help me with this lack of memoryThank You! |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-01 : 10:16:43
|
| SQL Server will increase its memory use, as it finds it necessary, until it has used all the memory it is allocated.Kristen |
 |
|
|
raxbat
Yak Posting Veteran
52 Posts |
Posted - 2007-11-01 : 10:19:38
|
| So there will be no crash? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-01 : 10:22:22
|
| I don't see why there would be, no.Other than SQL Server gobbling up all the memory is there some other problem you have seen - error, process never finishing, etc.? |
|
|
|
raxbat
Yak Posting Veteran
52 Posts |
Posted - 2007-11-01 : 10:27:00
|
| Nope!Just simple operations with recordsets. Process info looks fine!:( |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-01 : 10:34:10
|
Rax, as an additional note, if you are on a service pack prior to SP4 you may experience memory leaks with certain operations.
Future guru in the making. |
|
|
|
|
|
|
Problem with memory