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 |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2004-01-19 : 01:49:56
|
| Hello All.Can any one tell me what is the defaul memory used by an instance (default or named) of sql server, considering memory options are set to default. Regards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-19 : 12:41:08
|
| Default option is to use all memory that the server has. This doesn't mean that SQL Server will use that much though.Tara |
 |
|
|
nishithrn
Yak Posting Veteran
58 Posts |
Posted - 2004-01-20 : 02:38:37
|
| Hi Tara,Tx for your reply.What I am tried to ask is, when I start my MSSQL Server service, how much memory does it consume...??I have to recommend hardware specification for a server which will hold 1 default instanve of SQL 7 and 3 named instance of SQL 2000. Total size of database to be installed on each instance is not more then 5GB. Can you help..??? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-20 : 12:06:27
|
| SQL Server starts out using very little memory (unless you have the minimum option set, but that's not the default). As queries are being executed, memory will increase. It is preferable to have enough memory to store all of your databases in RAM. For a lot of systems, this is not possible.Tara |
|
|
|
|
|
|
sql server memory