James K
Flowing Fount of Yak Knowledge
3873 Posts |
Posted - 02/02/2013 : 15:26:23
|
A few things to consider:
1) When you install SQL Server, choose only the bare minimum options that you need.
2) In the Server Properties (in the SSMS object explorer, right click on the server name and select properties) set various parameters to low values (server memory is one thing you can limit (know what you are doing when you do this), max degree of parallelism is another)
3) When you create a database, you can choose to create in simple recovery model which can sometimes be beneficial in terms of resources.
By the way, SQL is not part of the Windows OS. It is a service like any other that runs on windows, but it has its own "SQLOS" that does memory management on its own and other tasks. |
 |
|