SQL Server Best Practices: Difference between revisions
Jump to navigation
Jump to search
Created page with "SQL Server Best Practices * Put the SQL database on a separate drive, not the C drive" |
No edit summary |
||
| 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 but on a separate drive. | |||
* Put SQL database on a separate physical drive | |||
** This will provide best performance by not competeing with the main OS drive running the SQL server program | |||
* Use SSD or fast drives if you need ultimate performance and speed | |||
* | |||
Revision as of 16:24, 30 December 2014
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 but on a separate drive.
- Put SQL database on a separate physical drive
- This will provide best performance by not competeing with the main OS drive running the SQL server program
- Use SSD or fast drives if you need ultimate performance and speed