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 |
|
zxh
Starting Member
2 Posts |
 Posted - 2013-02-02 : 10:30:52
|
| Hi,as SQL Server is basically part of the OS with all the services and whatnot, i'd like to know how to - for learning purposes - install with minimum impact and windows rot. Does a dedicated user account make a difference? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-02 : 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. |
 |
|
|
zxh
Starting Member
2 Posts |
Posted - 2013-02-03 : 12:41:50
|
| thanks. |
|
|
|
|
|
|
Registry Penalty