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 |
|
winsysadmin
Starting Member
1 Post |
 Posted - 2005-01-06 : 10:40:24
|
| Hi Everyone,We are installing a new MS SMS 2003 central site server. It will have a dedicated SQL 2000 SP3a backend server on a separate 4 CPU box with 8GB of RAM. The engineering team here wants to configure SQL to only use 50% of the memory. They think this will prevent the server from crashing from poorly formed queries, etc. I think this memory setting will really hurt performance of the server. Any commnets, ideas?Thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-01-06 : 11:53:22
|
don't run poorly formed queries, if you have any doubts about them, show them here.  4 Gb of RAM should be plenty. i wouldn't worry about it.Go with the flow & have fun! Else fight the flow  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-06 : 18:30:21
|
| Pointless restricting the memory allocated to SQL server on a dedicated SQL box. Make sure the O/S has enough, and give SQL Server the rest.SQL Server will only use 2GB unless you have the [more expensive] Enterprise Edition. To get it to more than 3GB I think you need some fancy stuff - Data Centre Windows version? 64bit versions of everything? Sorry, I have forgotten exactly where the break points fall.Any idea how big the database will be?Kristen |
|
|
|
SQLMike
Starting Member
7 Posts |
Posted - 2005-01-06 : 19:56:49
|
| You can go up to 8Gigs of RAM with Windows 2003 Server Enterprise Edition and SQL Server 2000 Enterprise Edition. |
|
|
|
|
|
|
Memory Configuration Question