Difference between revisions of "SQL Server Best Practices"

From High5Wiki
Jump to navigation Jump to search
 
(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 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
 
* 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
 
* 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
  • 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.