SQL Server Best Practices: Difference between revisions

Revision as of 16:27, 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 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
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.

@@ Line 2: / Line 2: @@
 * 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.
+** 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 competeing with the main OS drive running the SQL server program
+** 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