| Author |
Topic |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2007-03-29 : 10:52:15
|
| Hello,We have a SQL Server 2000 , Windows 2000 Machine. There are just 5 databases on the machine which are very small around 20 GB all togather. We have been getting Low memory alerts from the last 2 days. The total memory on it is 1 Gb. We have setup to mail the dbadmin when the memory is less than 150 MB. I didnot see any unsual things in the error logs.What can I look up or should i do to avoid those low memory alerts.Thanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-29 : 13:39:14
|
| Well 1 GB is kinda low considering how cheap memory is these days. Bump it up. Even my desktop has 2 gigs..:)************************Life is short. Enjoy it.************************ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-03-30 : 14:27:30
|
| Other than the 5 db's I donot have anything running on the box. The box has been working well for a long time..but its showing the memoery alert from 3 days. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-30 : 14:56:47
|
| Did you have any increased activity in the last 3 days?************************Life is short. Enjoy it.************************ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-11 : 09:33:09
|
| How can check if the tempdb is full or something wrong with the tempdb. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 10:20:26
|
| Shouldn't get full if you let it auto grow, but you can set alert to monitor its size. |
|
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-11 : 10:46:18
|
| The memory is set to auto growth and unrestricted file grwoth. I do not think its a problem. |
|
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-11 : 11:06:18
|
| Hello guys,Any other ideas why I am getting the low memory alerts. There are hardly 30 users , no long running queries.Thanks for any help. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 11:33:31
|
| Are we talking about memory or tempdb? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 11:36:35
|
| For low memory alert, did you let sql server manages memory dynamicaaly? If so, sql will use all available memory on the server. |
|
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-11 : 12:12:38
|
| I have set the sql server max memory to default and the low memory alerts increased. The server has a 1 gb memory. So I was thinking , if I can set it to some fixed value remaining some for the OS. what do you think would be good values to fix for sql server. It has got 5 DB's with average 35 users.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 14:50:53
|
| I'll set to dynamic since it's dedicated sql server, not even set low memory alert on it. |
|
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-11 : 14:57:09
|
| Its already been set to dynamic. Thanks for the suggestions. |
|
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-14 : 11:17:18
|
| The virtual memory seems to be running out . So I have reduced the fixed value to a less 500 MB. And the low memory alerts stopped. I chave read this linkhttp://msdn2.microsoft.com/en-us/library/aa196734(SQL.80).aspxthanks |
|
|
|
|
Low Memory Alert