SQL Server Best Practices: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
* Put the SQL database on a separate drive, not the C drive | * Put the SQL database on a separate drive, not the C drive | ||
** By default, SQL places the database in program files on C, but this is not a good location. C drive is already busy handling the operating system, so best to | ** By default, SQL places the database in program files on C, but this is not a good location. C drive is already busy handling the operating system, so best to put on a separate drive. | ||
* Put SQL database on a separate physical drive | * Put SQL database on a separate physical drive | ||
** This will provide best performance by not | ** This will provide best performance by not competing with the main OS drive running the SQL server program | ||
* Always provide maximum RAM memory that you can provide | * Always provide maximum RAM memory that you can provide | ||
** Ram memory tends to be inexpensive and always best to have plenty of memory for SQL | ** Ram memory tends to be inexpensive and always best to have plenty of memory for SQL | ||
** See this site for info on how or search for this info as it may change: https://technet.microsoft.com/en-us/library/ms191144(v=sql.105).aspx | |||
* More even more performance the following will give good cost performance benefits: | * More even more performance the following will give good cost performance benefits: | ||
** Use SSD or fast drives if you need ultimate performance and speed | ** Use SSD or fast drives if you need ultimate performance and speed | ||
** Have a third drive for the temp table databases. this could be SSD also for fast performance. | ** Have a third drive for the temp table databases. this could be SSD also for fast performance. | ||
Latest revision as of 17:13, 21 January 2016
SQL Server Best Practices
- Put the SQL database on a separate drive, not the C drive
- By default, SQL places the database in program files on C, but this is not a good location. C drive is already busy handling the operating system, so best to put on a separate drive.
- Put SQL database on a separate physical drive
- This will provide best performance by not competing with the main OS drive running the SQL server program
- Always provide maximum RAM memory that you can provide
- Ram memory tends to be inexpensive and always best to have plenty of memory for SQL
- See this site for info on how or search for this info as it may change: https://technet.microsoft.com/en-us/library/ms191144(v=sql.105).aspx
- More even more performance the following will give good cost performance benefits:
- Use SSD or fast drives if you need ultimate performance and speed
- Have a third drive for the temp table databases. this could be SSD also for fast performance.