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 |
|
casolorz
Starting Member
1 Post |
 Posted - 2008-03-27 : 18:22:41
|
| I have windows 2003 with ms sql 2000. The machine has 3.6 gigs of ram and only runs ms sql, nothing else.Whenever the first query is made sql will allocate as much as 1.5 gigs of ram which is just killing the system. This system reboots nightly so this first query happens every morning. We have tried setting the min and max memory of sql, as well as the reserver memory setting to see if it will preallocate all that memory but we've had no luck.Is there a way to make SQL allocate all that memory ahead of time? maybe make it cache some tables or something?I know very little about MS SQL so please be very descriptive about possible solutions or troubleshooting steps.Thanks,--Carlos |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-27 : 19:01:17
|
| You should definitely not be rebooting the system every night. You are causing performance problems by doing this. We reboot monthly and only because there are MS security patches to be installed monthly. If there weren't any of these, we'd reboot only as needed for errors or similar.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 22:58:46
|
| Keep in mind that sql2k standard edition can only use 2gb memory, you may need upgrade to enterprise edition and add /3gb in boot.ini file to let sql use 3gb memory. |
|
|
|
|
|
|
Memory allocation