SQL Server Best Practices

From High5Wiki
Jump to: navigation, search

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.